Microsoft Excel 365 / 2019 / 2016 Level 2
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.
Duration: 1 Day
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
Prerequisites
- Microsoft Excel 365 / 2019 / 2016 Level 1 or equivalent experience
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