Excel Fundamentals |
Understand the Excel Screen |
Create Workbooks |
Navigate Worksheets |
Open Workbooks |
Save Workbooks |
AutoRecover |
The Quick Access Toolbar |
Print |
Help |
Close and Exit |
Edit a Workbook |
Select Cells and Ranges |
Edit Cell Data |
Cut, Copy, and Paste |
Undo, Redo, Repeat |
More Pasting Options |
Insert and Move Cells |
Delete Cells |
Check Spelling |
Hide Columns and Rows |
Document Properties |
Basic Formulas |
Formula Basics |
AutoFill |
Sums and Averages |
MIN and MAX |
COUNT |
Basic Formatting |
Format Text |
Align and Merge Cells |
Format Numbers and Dates |
Borders and Background Colors |
Copy Formatting |
Row Heights and Column Widths |
Insert Objects |
Images |
Shapes |
Hyperlinks |
Object Properties and Alt Text |
Manage Worksheets |
View Worksheets |
Multiple Windows |
Move and Copy Worksheets |
Insert, Rename, and Delete Worksheets |
Freeze Rows and Columns |
Hide Worksheets and Gridlines |
Excel Fundamentals |
Understand the Excel Screen |
Create Workbooks |
Navigate Worksheets |
Open Workbooks |
Save Workbooks |
AutoRecover |
The Quick Access Toolbar |
Print |
Edit a Workbook |
Select Cells and Ranges |
Cut, Copy, and Paste |
Undo, Redo, Repeat |
More Pasting Options |
Insert and Move Cells |
Delete Cells |
Check Spelling |
Find and Replace Text |
Hide Columns and Rows |
Basic Formulas |
Formula Basics |
AutoFill |
Sums and Averages |
MIN and MAX |
COUNT |
Basic Formatting |
Format Text |
Align and Merge Cells |
Format Numbers and Dates |
Borders and Background Colors |
Copy Formatting |
Row Heights and Column Widths |
Insert Objects |
Images |
Hyperlinks |
Manage Worksheets |
View Worksheets |
Move and Copy Worksheets |
Insert, Rename, and Delete Worksheets |
Freeze Rows and Columns |
Hide Worksheets and Gridlines |
Charts |
Move and Resize |
Chart Types |
Layout and Style |
Titles and Legends |
Gridlines, Labels, and Data Tables |
Chart Elements |
Modify Chart Data |
Trendlines |
Dual-Axis Charts |
Chart Templates |
Sparklines |
Print and Distribute |
Page Size and Scale |
Print Area and Page Breaks |
Print Titles, Gridlines, and Headings |
Headers and Footers |
Intermediate Formulas |
Reference External Worksheets |
Absolute and Relative References |
Order of Operations |
Cell and Range Names |
Insert Functions |
CONCAT Function |
PMT and NPER Functions |
Display Formulas |
Date Formulas |
Manage Data |
Quick Analysis |
Outline and Subtotal |
Data Validation |
Flash Fill |
Import and Export Data |
Tables |
Insert a Table |
Sort Data |
Filter Data |
Remove Duplicates |
Slicers |
Structured References |
Intermediate Formatting |
Apply Conditional Formatting |
Collaboration |
Cell Comments |
Share Workbooks |
Version History |
Protect a Worksheet |
Protect Workbook Structure |
Password Protection |
PivotTables |
Create PivotTables |
Add Multiple PivotTable Fields |
Add Calculated Fields |
The GETPIVOTDATA Function |
Filter PivotTables |
Group Values |
Refresh a PivotTable |
Format a PivotTable |
PivotCharts |
Create PivotCharts |
Troubleshoot Formulas |
Formula Errors |
The Watch Window |
Evaluate Formulas |
Advanced Formatting |
Customize Conditional Formatting |
Conditional Formatting with Formulas |
International Currency and Formats |
Color Formats |
Custom Themes |
Form Controls |
Advanced Formulas |
IF Function |
Nested Functions |
AND, OR, and NOT Functions |
SUMIF, AVERAGEIF, and COUNTIF Functions |
VLOOKUP |
HLOOKUP |
INDEX and MATCH |
UPPER, LOWER, and PROPER |
RIGHT, LEFT, and MID |
Formula Calculation Options |
Analyze Data |
Goal Seek |
Scenario Manager |
Consolidate Data |
Macros |
Enable Macros |
Create Macros |
Modify Macros |
Getting Started |
Understand the Excel Screen |
Create Workbooks |
Navigate Worksheets |
Open Workbooks |
Save Workbooks |
AutoRecover |
The Quick Access Toolbar |
Print |
Share a Workbook |
Help |
Close and Exit |
Edit a Workbook |
Select Cells and Ranges |
Edit Cell Data |
Cut, Copy, and Paste |
Undo, Redo, Repeat |
More Pasting Options |
Insert and Move Cells |
Delete Cells |
Check Spelling |
Find and Replace Text |
Hide Columns and Rows |
Document Properties |
Basic Formulas |
Formula Basics |
AutoFill |
Sums and Averages |
MIN and MAX |
COUNT |
Basic Formatting |
Format Text |
Align and Merge Cells |
Format Numbers and Dates |
Borders and Background Colors |
Copy Formatting |
Row Heights and Column Widths |
Insert Objects |
Images |
Shapes |
Hyperlinks |
Object Properties and Alt Text |
View and Manage Worksheets |
View Worksheets |
Multiple Windows |
Move and Copy Worksheets |
Insert, Rename, and Delete Worksheets |
Freeze Rows and Columns |
Hide Worksheets and Gridlines |
Charts |
Create Charts |
Move and Resize |
Chart Types |
Layout and Style |
Titles and Legends |
Gridlines, Labels, and Data Tables |
Chart Elements |
Modify Chart Data |
Filter Charts |
Trendlines |
Dual-Axis Charts |
Chart Templates |
Sparklines |
Print and Distribute |
Page Size and Scale |
Print Area and Page Breaks |
Print Titles, Gridlines, and Headings |
Headers and Footers |
Margins and Orientation |
Inspect for Issues |
Intermediate Formulas |
Reference External Worksheets |
Absolute and Relative References |
Order of Operations |
Cell and Range Names |
Insert Functions |
CONCATENATE Function |
PMT Function |
Display Formulas |
Date Formulas |
Manage Data |
Quick Analysis |
Outline and Subtotal |
Data Validation |
Flash Fill |
Import and Export Data |
Tables |
Insert a Table |
Sort Data |
Filter Data |
Add Rows and Columns |
Table Styles |
Remove Duplicates |
Slicers |
Structured References |
Intermediate Formatting |
Apply Conditional Formatting |
Apply and Remove Cell Styles |
Create and Modify Cell Styles |
Find and Replace Formatting |
Apply a Theme |
Collaborate with Excel |
Cell Comments |
Share Workbooks |
Protect a Worksheet |
Protect Workbook Structure |
Manage Workbook Versions |
Password Protection |
PivotTables |
Create PivotTables |
Add Multiple PivotTable Fields |
Change a PivotTable's Calculation |
Add Calculated Fields |
The GETPIVOTDATA Function |
Filter PivotTables |
Timelines |
PivotTable Layout |
Group Values |
Refresh a PivotTable |
Format a PivotTable |
PivotCharts |
Create PivotCharts |
PivotChart Options |
PivotChart Styles |
Drill-Down Data |
Troubleshoot Formulas |
Formula Errors |
The Watch Window |
Evaluate Formulas |
Advanced Formatting |
Customize Conditional Formatting |
Conditional Formatting with Formulas |
Manage Conditional Formatting |
International Currency and Formats |
Body and Heading Options |
Color Formats |
Custom Themes |
Form Controls |
Save Form Templates |
Advanced Formulas |
IF Function |
Nested Functions |
AND, OR, and NOT Functions |
SUMIF, AVERAGEIF, and COUNTIF Functions |
VLOOKUP |
HLOOKUP |
INDEX and MATCH |
UPPER, LOWER, and PROPER |
RIGHT, LEFT, and MID |
Formula Calculation Options |
Analyze Data |
Goal Seek |
Scenario Manager |
Consolidate Data |
Macros |
Enable Macros |
Create Macros |
Modify Macros |
Copy Macros |
Getting Started |
Understand the Excel Screen |
Create Workbooks |
Navigate Worksheets |
Open Workbooks |
Save Workbooks |
AutoRecover |
The Quick Access Toolbar |
Print |
Share a Workbook |
Help |
Close and Exit |
Edit a Workbook |
Select Cells and Ranges |
Edit Cell Data |
Cut, Copy, and Paste |
Undo, Redo, Repeat |
More Pasting Options |
Insert and Move Cells |
Delete Cells |
Check Spelling |
Find and Replace Text |
Hide Columns and Rows |
Workbook Properties |
Basic Formulas |
Formula Basics |
AutoFill |
Sums and Averages |
MIN and MAX |
COUNT |
Basic Formatting |
Format Text |
Align and Merge Cells |
Format Numbers and Dates |
Borders and Background Colors |
Copy Formatting |
Row Heights and Column Widths |
Insert Objects |
Images |
Shapes |
Hyperlinks |
Object Properties and Alt Text |
View and Manage Worksheets |
View Worksheets |
Multiple Windows |
Move and Copy Worksheets |
Insert, Rename, and Delete Worksheets |
Freeze Rows and Columns |
Hide Worksheets and Gridlines |
Charts |
Create Charts |
Move and Resize |
Chart Types |
Layout and Style |
Titles and Legends |
Gridlines, Labels, and Data Tables |
Chart Elements |
Modify Chart Data |
Filter Charts |
Trendlines |
Dual-Axis Charts |
Chart Templates |
Sparklines |
Print and Distribute |
Page Size and Scale |
Print Area and Page Breaks |
Print Titles, Gridlines, and Headings |
Headers and Footers |
Margins and Orientation |
Inspect for Issues |
Intermediate Formulas |
Reference External Worksheets |
Absolute and Relative References |
Order of Operations |
Cell and Range Names |
Insert Functions |
CONCATENATE Function |
PMT Function |
Display Formulas |
Date Formulas |
Manage Data |
Quick Analysis |
Outline and Subtotal |
Data Validation |
Flash Fill |
Import and Export Data |
Tables |
Insert a Table |
Sort Data |
Filter Data |
Add Rows and Columns |
Table Styles |
Remove Duplicates |
Slicers |
Structured References |
Intermediate Formatting |
Apply Conditional Formatting |
Apply and Remove Cell Styles |
Create and Modify Cell Styles |
Find and Replace Formatting |
Apply a Theme |
Collaborate with Excel |
Cell Comments |
Share Workbooks |
Protect a Worksheet |
Protect Workbook Structure |
Manage Workbook Versions |
Password Protection |
PivotTables |
Create PivotTables |
Add Multiple PivotTable Fields |
Change a PivotTable's Calculation |
Add Calculated Fields |
The GETPIVOTDATA Function |
Filter PivotTables |
Timelines |
PivotTable Layout |
Group Values |
Refresh a PivotTable |
Format a PivotTable |
PivotCharts |
Create PivotCharts |
PivotChart Options |
PivotChart Styles |
Drill-Down Data |
Troubleshoot Formulas |
Formula Errors |
The Watch Window |
Evaluate Formulas |
Advanced Formatting |
Customize Conditional Formatting |
Conditional Formatting with Formulas |
Manage Conditional Formatting |
International Currency and Formats |
Body and Heading Options |
Color Formats |
Custom Themes |
Form Controls |
Save Form Templates |
Advanced Formulas |
IF Function |
Nested Functions |
AND, OR, and NOT Functions |
SUMIF, AVERAGEIF, and COUNTIF Functions |
VLOOKUP |
HLOOKUP |
INDEX and MATCH |
UPPER, LOWER, and PROPER |
RIGHT, LEFT, and MID |
Formula Calculation Options |
Analyze Data |
Goal Seek |
Scenario Manager |
Consolidate Data |
Macros |
Enable Macros |
Create Macros |
Modify Macros |
Copy Macros |