Cloisters Level 1 863 Hay Street, Perth WA 6000 | 08 9218 9059
Copyright © 2018 ATI-Mirage. All rights reserved.
RTO No; 1918
Microsoft Excel - Advanced Course
Objectives of this course are to enable experienced users of Microsoft Excel to increase their knowledge of the advanced features of this powerful spreadsheet application.
This is best for
Power end Excel users who want to develop their skills using a range of formulas and use various advanced techniques to manipulate Excel data.
Review of Intermediate concepts
Overview of topics covered during Intermediate Excel course
Working with Multiple Sheets & Workbooks
Add, remove and copy sheets
Grouping sheets for editing & linking data from multiple sheets
Create 3 dimensional formulae
Advanced Data Tools
Consolidating data with identical and different layouts
Filter data - auto & advanced filter
Data validation & conditional formatting
Sensitivity analysis with goal seek, scenarios & data tables
Working with specific function groups
Nesting & combining functions
Using named ranges
Charts & Pivot Tables
- Apply advanced concepts to Excel charts
- Create pivot tables & charts
- Using calculated fields and other pivot table techniques
Working with templates & styles
Creating and editing simple Excel macros
Assigning macros to buttons, toolbars and other objects
Customising toolbars & ribbons
Applying protection to worksheets & workbooks
On completion of this course, participants will be able to use multiple files, link these with formulas, and work with three dimensional ranges; as well as perform Data distribution analysis, attach passwords and have a fuller understanding of the features of Excel.
Completion of Microsoft Excel Introduction and Intermediate course or equivalent knowledge is required.
Two days: 9am to 4pm
$890 GST free per person
- Experienced facilitator
- Interactive, practical and hands on learning
- Comprehensive take-home training and reference manual
- Post-course Help Desk support
- Certificate of Attendance for participants
- Morning & afternoon refreshments
- Delicious cafe lunch
- Post course follow up
Enjoy Real People, Real Conversations, Real Results
Certification Options - Microsoft Office Specialist
Microsoft Core Certification in Excel.
Available for 2010, 2013, 2016 & 365
Is this the right course for you?