Microsoft Excel Advanced
O365/2021/2019/2016
Microsoft Excel is a spreadsheet application used all over the world in commercial and industrial applications where numbers are involved. This could include analysis, payroll, inventory, finance, accounting, charting, data listing and complex calculations of any kind.
Our Excel Advanced course is designed for office users or those planning to work in an office. It is an advanced course that prepares you to work with data validation, macros, formula auditing, conditional formatting and tools related to data analysis. Please refer to the detailed course outline below to learn what is covered in the course.
Prerequisites: Substantial working experience with Microsoft Excel or skills learnt in our Excel Level-1 and 2 courses. At least six months of experience working in Windows environment with mouse. Some keyboard skills also required.
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person option is available for group training only)
Course Outline Download: Excel_Advanced_Level
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements
Course Outline
Excel Features Covered with Hands-on Exercises
- Advanced File Properties
- Data Validation
- Macros-Using Absolute References
- Macros-Using Relative References
- Macros-Nesting
- Macros-Editing
- Customizing Excel
- Conditional Formatting
- Advanced Conditional Formatting-Function AND
- Advanced Conditional Formatting-Function MOD
- Range Protection
- Worksheet Protection
- Workbook Protection
- Remove Duplicates
- Tracing Cells
- Error Checking Tool
- Using Watch Window
- Evaluating Formula
- Charts: Adding a Trendline
- Charts: Creating a Dual Axis Chart
- Using Goal Seek
- Using Scenario Manager
- Quick Analysis- Sparklines
- Consolidating Data
- Linking Workbooks
- Importing Text Data into Excel
- Excel Custom Formats
Handy Keyboard Shortcuts
- Covered with Above Exercises
