Course Outline
Pre-Requisites
Microsoft Excel 365 / 2019 / 2016 Level 1 or equivalent experience
Lessons
This course provides a thorough exploration of the intermediate-to-advanced features in Excel that helps users perform more sophisticated data analysis, calculations, and formatting.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Objectives
- Managing multiple worksheets and workbooks
- Working with intermediate/advanced formulas and functions
- Using advanced formatting techniques
- Using the auditing tools to determine data dependencies and errors
- Using charts to graphically represent data
Outline
- Using Multiple Worksheets and Workbooks
- Using Multiple Worksheets
- Inserting New Worksheets
- Renaming Worksheets
- Deleting Worksheets
- Creating Multiple Views
- Freezing Panes
- Viewing and Arranging Multiple Worksheet Windows
- Navigating in Multiple Workbooks
- Selecting and Viewing Multiple Workbooks
- Managing Multiple Worksheets and Workbooks
- Selecting Multiple Worksheets
- Moving and Copying Data between Worksheets
- Linking Data Between Worksheets and Workbooks
- More on Formulas and Functions
- A Quick Review on Creating and Using Functions
- Using The PMT Function
- Using The IF Function
- Using The AND and OR function
- Creating Nested Functions
- Auditing Worksheets
- Identifying the Auditing Commands
- The Watch Window
- The Formula Evaluator
- Tracing Precedents and Dependents
- Correcting Worksheet Errors
- Naming Cells and Ranges
- Creating and Using Named Ranges
- Automatically Naming Ranges
- Navigating with Named Ranges
- Using Range Names in Formulas
- Pasting a List of Named Ranges
- Deleting and Editing Range Names
- Creating Named Constants
- Advanced Formatting
- Using Comments in a Worksheet
- Reviewing, Showing, and Hiding Comments
- Deleting a Comment
- Using Format Painter
- Creating Custom Number Formats
- Applying Conditional Formatting Rules
- Charting
- Using Charts
- Creating a Chart
- Changing Chart Type, Style and Chart Sub-Type
- Changing the Chart Source Data
- Adding data to an existing chart
- Changing the data in an existing chart
- Removing data from a chart
- Managing Chart Objects
- Moving and Resizing Chart Objects
- Deleting Chart Objects
- Adding Data Series and Objects to a Chart
- Changing the Chart Type
- Formatting Chart Objects
- Printing Charts
Cancellation Policy
Should you postpone or cancel your course you must give 5 business days notice.
Training Location
Virtual
Your Address
Your City,
Your Province
Your Country