Microsoft Excel 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
- Short review of Level 1 concepts
- Managing 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 Level 1 or equivalent experience
Outline
- Short Review of Level 1 concepts
- Navigation
- Data Entry
- Basic Formulas
- Basic Formatting
- Using Worksheets and Workbooks
- Inserting, Renaming, Deleting Worksheets
- Freezing Panes
- Moving and Copying Data between Worksheets
- Linking Data Between Worksheets and Workbooks
- Intermediate Formulas and Functions
- A Quick Review on Creating and Using Functions
- Using The PMT Function
- Using The IF Function
- Creating Nested Functions
- Auditing Worksheets
- Identifying the Auditing Commands
- The Formula Evaluator
- Tracing Precedents and Dependents
- Correcting Worksheet Errors
- Naming Cells and Ranges
- Creating and Using Named Ranges
- Using Range Names in Formulas
- Creating Named Constants
- Advanced Formatting
- Review Format Painter
- Review Flash Fill
- Conditional Formatting Rules
- Charting
- Using Charts
- Creating a Chart
- Changing Chart Type, Style and Chart Sub-Type
- Changing the Chart Source Data
- Managing Chart Objects
- Adding Data Series and Objects to a Chart
- Printing Charts
- Inserting Charts into other documents
- Performing What-If Analysis
- Using Goal Seek
- Using Data Tables
- Using Data Lookup Functions
- VLOOKUP, HLOOKUP
- IFERROR
- Data Validation
- Managing data
- Using INDEX/MATCH
- Introduction to XLOOKUP, XMATCH