Enroll in all 3 Levels of our instructor-led Excel classes and save $60. This course package includes:
• To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking the Windows for End Users Course.
Excel - Level 1 (Day 1)
Chapter 1: Set up a workbook - 3
Create workbooks
Modify workbooks
Modify worksheets
Merge and unmerge cells
Customize the Excel app window
• Manage the ribbon
• Manage the Quick Access Toolbar
• Customize the status bar
• Change the magnification level of a worksheet
• Arrange multiple workbook windows
Skills review
Practice tasks
Chapter 2: Work with data and Excel tables - 41
Enter and revise data
Manage data by using Flash Fill
Move data within a workbook
• Sidebar: Quickly access data-formatting commands
Find and replace data
Correct and fine-tune data
Define Excel tables
Skills review
Practice tasks
Chapter 3: Perform calculations on data - 71
Name data ranges
• Sidebar: Operators and Precedence
Create formulas to calculate values
Chapter 4: Change workbook appearance - 103
Format cells
Define and merge cell styles
Apply and modify workbook themes
Apply and modify table styles
Make numbers easier to read
Change the appearance of data based on its value
Add images to worksheets
Skills review
Practice tasks
Chapter 9: Create charts and graphics - 207
Create standard charts
Create combo charts
Create specialized charts
• Hierarchy charts
• Statistic charts
• Scatter charts
• Stock charts
• Map charts
Customize chart appearance
Identify data trends
Summarize data by using sparklines
Illustrate processes and relationships
Insert and manage shapes
Sidebar: Insert mathematical equations
Skills review
Practice tasks
Chapter 11: Print worksheets and charts - 285
Add headers and footers to printed pages
Prepare worksheets for printing
• Fit your worksheet contents to the printed page
• Change page breaks in a worksheet
• Change the page printing order for worksheets
Print worksheets
Print parts of worksheets
Print charts
Skills review
Practice task
Excel - Level 2 (Day 2)
Chapter 3: Perform calculations on data - 71
Summarize data that meets specific conditions
Copy and move formulas
Create array formulas
Find and correct errors in calculations
Configure automatic and iterative calculation options
Skills review
Practice tasks
Chapter 5: Manage worksheet data - 137
Filter data ranges and tables
Summarize filtered data
• Sidebar: Randomly select list rows
Enforce data entry criteria
Skills review
Practice tasks
Chapter 6: Reorder and summarize data - 159
Sort worksheet data
Sort data by using custom lists
Outline and subtotal data
Skills review
Practice tasks
Chapter 7: Combine data from multiple sources - 175
Look up data from other locations
• Locate information in the same row (VLOOKUP)
• Locate information in the same column (HLOOKUP)
• Locate information anywhere (XLOOKUP)
Link to data in other locations
Consolidate multiple sets of data
Skills review
Practice tasks
Chapter 8: Analyze alternative data sets - 193
Define and display alternative datasets
Forecast data by using data tables
Identify the input necessary to achieve a specific result
Skills review
Practice tasks
Chapter 14: Collaborate with colleagues - 351
Manage comments
Protect workbooks and worksheets
Finalize workbooks
Save workbook content as a PDF file
Create and distribute workbook templates
Skills review
Practice tasks
Excel - Level 3 (Day 3)
Chapter 8: Analyze alternative data sets - 193
Define and display alternative datasets
Forecast data by using data tables
Identify the input necessary to achieve a specific result
Skills review
Practice tasks
Chapter 10: Create PivotTables and PivotCharts - 253
Analyze data dynamically in PivotTables
Filter, show, and hide PivotTable data
Edit PivotTables
Format PivotTables
Create dynamic PivotCharts
Skills review
Practice tasks
Chapter 12: Automate tasks and input - 307
Enable and examine macros
• Set macro security levels in Excel
• Examine macros
Create and modify macros
Run macros
• Assign a macro to a Quick Access Toolbar button
• Assign a macro to a shape
• Run a macro when a workbook opens
Present information and options as form controls
Skills review
Practice tasks
Chapter 13: Work with other Microsoft 365 apps - 335
Combine Excel, Word, and PowerPoint content
• Link from Excel to a document or presentation
• Embed file content
Create hyperlinks from worksheets
Copy or link to charts
Skills review
Practice tasks
Chapter 15: Perform business intelligence analysis - 373
Manage the Excel Data Model
• Sidebar: Power View data visualizations
Define relationships between data sources
Manage data by using Power Pivot
Display data on timelines
Import data by using Power Query
Skills review
Practice tasks
Chapter 16: Create forecasts and visualizations - 403
Create Forecast Worksheets
• Linear forecasting
• Exponential smoothing forecasting
Define and manage measures
Define and display Key Performance Indicators
Create 3D maps
Skills review
Practice tasks