Microsoft Excel Advanced, 1-Day Training Course in Melbourne
Event description
Course Code: EXLADV
Duration: 1 Day
Overview
This one-day course covers aspects of Microsoft Excel that goes well beyond building basic workbooks, including workbook automation and productivity features. Participants will learn advanced Excel techniques in a range of areas such as worksheet and workbook consolidation, data validation, PivotTables and Pivot Charts, Lookup and Reference Functions, Linking Data, Financial Functions, Recorded Macros and much more.
Audience
This course is intended for experienced Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks. Upon completion of the course, students will have learned the skills to able work with Excel’s advanced data analysis tools, automate workbook operations and effectively use complex functions.
Prerequisites
Participants should have already completed both the Excel for Beginners course and Excel Intermediate course before attending this course, or have Excel skills up to the intermediate level course.
Module List
Module 1: Setting Excel Options
Module 2: Lookup Functions in Excel
Module 3: Text Functions in Excel
Module 4: Financial Functions
Module 5: Information Functions
Module 6: Complex Formulas
Module 7: Goal Seeking
Module 8: Data Linking in Excel
Module 9: Data Consolidation
Module 10: Protecting Data
Module 11: Summarising and Subtotalling
Module 12: Grouping and Outlining
Module 13: Pivot Tables
Module 14: Pivot Charts
Module 15: Pivot Table Features
Module 16: Recorded Macros
Tickets for good, not greed Humanitix dedicates 100% of profits from booking fees to charity
