This course introduces Microsoft Excel users to the advanced features of the software application, in addition to the usual features such as creating and editing charts; modifying chart options; working with multiple worksheets and workbooks and use financial and logical functions. Participants will earn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables. In-class exercises will involve the use of data tables and scenarios to make projections about data and use Goal Seek and Solver to analyze data. Participants will also learn how to audit worksheets, protect worksheets and workbooks, create and use macros, and import and export information and documents.
Who Should Attend
Anyone whose chosen field of work requires the involvement of extensive and detailed use of the more complex MS Excel skills and functions.
By the end of the Advanced Microsoft Excel training course, participants will be able to use Microsoft Excel’s in-built features to import, analyse and present their data. The training is hands-on. Theory is introduced only as far as is required for practical application.
Participants are expected to follow-along with the guided examples in the training manual as well as complete all assigned exercises. While participants are expected to perform all tasks themselves, they are encouraged to discuss possible solutions amongst themselves to support individual learning.
Participants are encouraged to share actual problems they face in using Microsoft Excel in their daily work. In this way practical solutions can be created and shared with the entire class. A digital training manual will be provided provided. Participants are encourage to print a hard-copy if it will support their learning. Digital exercise files will also be provided.
|Introduction to Power Query||Learn how to use Microsoft Excel’s newest an most exciting tool to import and transform frequently changing data from external sources.|
|Data Tools||Learn the tools that Excel provides to help clean your data including automatically splitting into columns, intelligence-based automatic pattern filling and data validation.|
|Data Analysis with PivotTables||Deepen your knowledge of PivotTables by learning different ways you can summarize an
present the PivotTable data
|Logical Functions||A revision on the IF(), OR() and AND() functions|
|Text functions||A revision on PROPER(), UPPER(), LOWER(), CONCAT()/CONCATENATE(), LEFT(), RIGHT(), MID(). Learn about LEN(), FIND(), SEARCH(), REPLACE(), SUBSTITUTE()|
|Formula Auditing||Learn how to investigate why your functions and formulas are displaying errors.|
|Nested Functions||A powerful technique involving using functions within other functions.|
Learn how to make specific data stand out using a variety of colour formatting, data bars and icons.
|Goal Seek & Scenarios||Learn how Excel can help you handle what-if situations to display the possible data you need.|
|Forecast Sheet||Apply Excel’s powerful forecast functionality to statistically predict future data.|
|20 June 20222 (Day 1)||
8:30 am - 12:00 pm
|21 June 2022 (Day 2)|
|22 June 2022 (Day 3)|
|23 June 2022 (Day 4)|
|Normal Price||$490 (10% SBS)||$500|