Learn how to use Microsoft Excel to create advanced formulas and analyse data.
You'll learn advanced Excel features and tools such as applying advanced formulas to test and retrieve data, managing and manipulating lists with Sorting and Subtotals, and presenting data in graphical formats with Trendlines.
After completing this course, students will be able to:
Freeze panes and split a worksheet; open and arrange a new window with the current worksheet content; hide and unhide data; set print titles and page breaks to optimise print output; insert different even and odd headers; manage multiple worksheets; link worksheets by using 3-D formulas; add a Watch window; and create and manage links between workbooks
Apply special and custom number formats; control the display of zero values; apply and modify themes; merge and split cells; change the orientation of data in cells; transpose data; use Paste Special operations; and add a background colour and a watermark
Create an outline and consolidate data; create custom views to save different sets of worksheet display and print settings; create subtotals in a list; use multiple subtotal functions;
Define and apply cell and range names; use names in formulas; and define and apply 3-D names
Sort and filter data; create, format, and name a table; add rows and columns; and use structured references
Save and publish a worksheet as a web page; insert and edit hyperlinks; publish a worksheet; and send a worksheet as an e-mail attachment
Use auditing features; add comments to cells and workbooks; protect a worksheet or part of a worksheet; protect the workbook structure; share, merge, and track changes in a workbook; find and remove hidden and personal data in a workbook; and mark a workbook as final
Change Excel default application settings and customise the ribbon; and create and modify templates
Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. Join more than 5,000 students who attend our quality Microsoft courses every year.
This course is intended for those wanting to build on existing Microsoft Excel skills.
To maximise your success in this course, it is recommended that you have completed Microsoft Excel - The Essentials or possess equivalent knowledge and skills.
The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.
Subscribe
