Microsoft Excel Training

Free Excel Training and Excel Cheat Sheet

10,973 users

Course Includes

Interactive Tutorials
Step-by-step Instructions
Excel Cheat Sheet

Free Microsoft Excel training to use and share with our compliments!

What you'll learn:

Master Microsoft Excel basic, intermediate, and advanced skills
Build formulas to calculate SUM, COUNT, AVERAGE, MIN, and MAX
Create PivotTables & PivotCharts to summarize large amounts of data
Use SUMIF, VLOOKUP, HLOOKUP, MATCH, and INDEX functions

Download Free Excel Cheat Sheet!

Please consider our paid training products:

	Free Courses	Paid Courses
Interactive tutorials
Progress tracking
Skills assessments
Courseware manuals
Certificate + CE credits

Excel Fundamentals
Understand the Excel Screen Understand the Excel Screen
Create Workbooks How to create blank & template-based workbooks in Excel
Navigate Worksheets How to Navigate Worksheets in Excel
Open Workbooks How to Open Workbooks in Excel
Save Workbooks How to Save Workbooks in Excel
AutoRecover How to AutoRecover Excel Files
The Quick Access Toolbar How to Use The Quick Access Toolbar in Excel
Print How to Print in Excel
Help How to Get Help in Excel
Close and Exit How to Close and Exit from Excel
Edit a Workbook
Select Cells and Ranges How to Select Cells and Ranges in Excel
Edit Cell Data How to Edit Cell Data in Excel
Cut, Copy, and Paste How to Cut, Copy, and Paste in Excel
Undo, Redo, Repeat How to Use Undo, Redo, Repeat Commands in Excel
More Pasting Options How to Use Special Paste Options in Excel
Insert and Move Cells How to Insert and Move Cells in Excel
Delete Cells How to Delete Cells in Excel
Check Spelling Learn how you use Excel's spell check to proof your worksheets for spelling errors.
Hide Columns and Rows How to Hide Columns and Rows in Excel
Document Properties How to View and Edit Document Properties in Excel
Basic Formulas
Formula Basics How to Create Basic Formulas in Excel
AutoFill How to Use AutoFill in Excel
Sums and Averages How to Use Sum and Average Formulas in Excel
MIN and MAX How to Use MIN and MAX Functions in Microsoft Excel
COUNT How to Use the COUNT Function in Excel
Basic Formatting
Format Text How to Apply Formatting to Text in Excel
Align and Merge Cells To merge cells in Excel, select the cells you want to merge, click the Merge list arrow and select a merge option.
Format Numbers and Dates How to Format Numbers and Dates in Excel
Borders and Background Colors How to Add Cell Borders and Background Colors in Excel
Copy Formatting How to Copy Formatting in Excel
Row Heights and Column Widths How to Adjust Row Heights and Column Widths in Excel
Insert Objects
Images How to Insert Images in Excel
Shapes How to Insert and Format Shapes in Excel
Hyperlinks How to Insert Hyperlinks in Excel
Object Properties and Alt Text How to Adjust Object Properties and Alt Text in Excel
Manage Worksheets
View Worksheets How to Change Worksheet Views in Excel
Multiple Windows How to Work with Multiple Windows in Excel
Move and Copy Worksheets How to Move and Copy Worksheets in Excel
Insert, Rename, and Delete Worksheets How to Insert, Rename, and Delete Worksheets in Excel
Freeze Rows and Columns How to Freeze and Unfreeze Rows and Columns in Excel
Hide Worksheets and Gridlines How to Hide Worksheets and Gridlines in Excel
Excel Fundamentals
Understand the Excel Screen Understand the Excel Screen
Create Workbooks How to create blank & template-based workbooks in Excel
Navigate Worksheets How to Navigate Worksheets in Excel
Open Workbooks How to Open Workbooks in Excel
Save Workbooks How to Save Workbooks in Excel
AutoRecover How to AutoRecover Excel Files
The Quick Access Toolbar How to Use The Quick Access Toolbar in Excel
Print How to Print in Excel
Edit a Workbook
Select Cells and Ranges How to Select Cells and Ranges in Excel
Cut, Copy, and Paste How to Cut, Copy, and Paste in Excel
Undo, Redo, Repeat How to Use Undo, Redo, Repeat Commands in Excel
More Pasting Options How to Use Special Paste Options in Excel
Insert and Move Cells How to Insert and Move Cells in Excel
Delete Cells How to Delete Cells in Excel
Check Spelling Learn how you use Excel's spell check to proof your worksheets for spelling errors.
Find and Replace Text How to Use Find and Replace in Excel
Hide Columns and Rows How to Hide Columns and Rows in Excel
Basic Formulas
Formula Basics How to Create Basic Formulas in Excel
AutoFill How to Use AutoFill in Excel
Sums and Averages How to Use Sum and Average Formulas in Excel
MIN and MAX How to Use MIN and MAX Functions in Microsoft Excel
COUNT How to Use the COUNT Function in Excel
Basic Formatting
Format Text How to Apply Formatting to Text in Excel
Align and Merge Cells To merge cells in Excel, select the cells you want to merge, click the Merge list arrow and select a merge option.
Format Numbers and Dates How to Format Numbers and Dates in Excel
Borders and Background Colors How to Add Cell Borders and Background Colors in Excel
Copy Formatting How to Copy Formatting in Excel
Row Heights and Column Widths How to Adjust Row Heights and Column Widths in Excel
Insert Objects
Images How to Insert Images in Excel
Hyperlinks How to Insert Hyperlinks in Excel
Manage Worksheets
View Worksheets How to Change Worksheet Views in Excel
Move and Copy Worksheets How to Move and Copy Worksheets in Excel
Insert, Rename, and Delete Worksheets How to Insert, Rename, and Delete Worksheets in Excel
Freeze Rows and Columns How to Freeze and Unfreeze Rows and Columns in Excel
Hide Worksheets and Gridlines How to Hide Worksheets and Gridlines in Excel
Charts
Move and Resize How to Move and Resize a Chart in Excel
Chart Types How to Change Chart Types in Excel
Layout and Style How to Apply Chart Layouts and Styles in Excel
Titles and Legends How to Customize Chart Titles and Legends in Excel
Gridlines, Labels, and Data Tables How to Display Chart Gridlines, Labels, and Data Tables in Excel
Chart Elements How to Format Chart Data in Excel
Modify Chart Data How to Modify Chart Data in Excel
Trendlines How to Add Trendlines in Excel
Dual-Axis Charts How to Create Dual-Axis Charts in Excel
Chart Templates How to Create Chart Templates in Excel
Sparklines How to Add Sparklines in Excel
Print and Distribute
Page Size and Scale How to Adjust Page Size and Scale in Excel
Print Area and Page Breaks How to Set Print Area and Page Breaks in Excel
Print Titles, Gridlines, and Headings How to Print Titles, Gridlines, and Headings in Excel
Headers and Footers How to Add Headers and Footers in Excel
Intermediate Formulas
Reference External Worksheets How to Reference External Worksheets in Excel
Absolute and Relative References How to use Absolute and Relative Cell References in Excel
Order of Operations Order of Operations in Excel
Cell and Range Names How to Add Cell and Range Names in Excel
Insert Functions How to Insert Functions in Excel
CONCAT Function How to use the Concatenate Text Function in Excel
PMT and NPER Functions How to Use the PMT Function in Excel
Display Formulas How to Display Formulas in Excel
Date Formulas How to Use Date Formulas in Excel
Manage Data
Quick Analysis The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline.
Outline and Subtotal How to Use the Outline and Subtotal Features in Excel
Data Validation How to Use Data Validation Rules in Excel
Flash Fill How to Use Flash Fill in Excel
Import and Export Data How to Import and Export Excel Data
Tables
Insert a Table How to Insert a Table in Excel
Sort Data How to Sort Data in Excel
Filter Data How to Filter Data in Excel
Remove Duplicates How to Remove Duplicates in Excel
Slicers How to Use Slicers in Excel
Structured References How to Use Structured References in Excel
Intermediate Formatting
Apply Conditional Formatting How to Apply Conditional Formatting in Excel
Collaboration
Cell Comments How to Add, Edit, and Delete Cell Comments in Excel
Share Workbooks How to Share Workbooks in Excel
Version History How to Use Version History in Excel
Protect a Worksheet How to Protect a Worksheet in Excel
Protect Workbook Structure How to Protect a Workbook's Structure in Excel
Password Protection How to Add Password Protection in Excel
PivotTables
Create PivotTables How to Create PivotTables in Excel
Add Multiple PivotTable Fields How to Add Multiple PivotTable Fields to a PivotTable in Excel
Add Calculated Fields How to Add and Remove Calculated Fields in Excel PivotTables
The GETPIVOTDATA Function How to Use the GETPIVOTDATA Function in Excel
Filter PivotTables How to Filter PivotTables in Excel
Group Values How to Group Values in Excel
Refresh a PivotTable How to Refresh a PivotTable in Excel
Format a PivotTable How to Format a PivotTable in Excel
PivotCharts
Create PivotCharts How to Create PivotCharts in Excel
Troubleshoot Formulas
Formula Errors How to Fix Formula Errors in Excel
The Watch Window How to The Watch Window in Excel
Evaluate Formulas How to Evaluate Formulas in Excel
Advanced Formatting
Customize Conditional Formatting How to Customize Conditional Formatting in Excel
Conditional Formatting with Formulas How to Use Conditional Formatting with Formulas in Excel
International Currency and Formats How to Use International Currency and Formats in Excel
Color Formats How to Create and Apply Color Schemes in Excel
Custom Themes How to Create and Apply Custom Themes in Excel
Form Controls How to Form Controls in Excel
Advanced Formulas
IF Function How to Use the IF Function in Excel
Nested Functions How to Insert Nested Functions in Excel
AND, OR, and NOT Functions How to use AND, OR, and NOT Functions in Excel
SUMIF, AVERAGEIF, and COUNTIF Functions How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel
VLOOKUP How to Use the VLOOKUP Function in Excel
HLOOKUP How to Use HLOOKUP in Excel
INDEX and MATCH How to Use the INDEX and MATCH Functions in Excel
UPPER, LOWER, and PROPER How to Use UPPER, LOWER, and PROPER Functions in Excel
RIGHT, LEFT, and MID How to Use RIGHT, LEFT, and MID Functions in Excel
Formula Calculation Options How to Change Formula Calculation Options in Excel
Analyze Data
Goal Seek How to use Goal Seek feature in Excel
Scenario Manager How Use to Scenario Manager in Excel
Consolidate Data How to Consolidate Data in Excel
Macros
Enable Macros How to Enable Macros in Excel
Create Macros How to Create Macros in Excel
Modify Macros How to Modify Macros in Excel
Getting Started
Understand the Excel Screen Understand the Excel Screen
Create Workbooks How to create blank & template-based workbooks in Excel
Navigate Worksheets How to Navigate Worksheets in Excel
Open Workbooks How to Open Workbooks in Excel
Save Workbooks How to Save Workbooks in Excel
AutoRecover How to AutoRecover Excel Files
The Quick Access Toolbar How to Use The Quick Access Toolbar in Excel
Print How to Print in Excel
Share a Workbook How to Share Workbooks in Excel
Help How to Get Help in Excel
Close and Exit How to Close and Exit from Excel
Edit a Workbook
Select Cells and Ranges How to Select Cells and Ranges in Excel
Edit Cell Data How to Edit Cell Data in Excel
Cut, Copy, and Paste How to Cut, Copy, and Paste in Excel
Undo, Redo, Repeat How to Use Undo, Redo, Repeat Commands in Excel
More Pasting Options How to Use Special Paste Options in Excel
Insert and Move Cells How to Insert and Move Cells in Excel
Delete Cells How to Delete Cells in Excel
Check Spelling Learn how you use Excel's spell check to proof your worksheets for spelling errors.
Find and Replace Text How to Use Find and Replace in Excel
Hide Columns and Rows How to Hide Columns and Rows in Excel
Document Properties How to View and Edit Document Properties in Excel
Basic Formulas
Formula Basics How to Create Basic Formulas in Excel
AutoFill How to Use AutoFill in Excel
Sums and Averages How to Use Sum and Average Formulas in Excel
MIN and MAX How to Use MIN and MAX Functions in Microsoft Excel
COUNT How to Use the COUNT Function in Excel
Basic Formatting
Format Text How to Apply Formatting to Text in Excel
Align and Merge Cells To merge cells in Excel, select the cells you want to merge, click the Merge list arrow and select a merge option.
Format Numbers and Dates How to Format Numbers and Dates in Excel
Borders and Background Colors How to Add Cell Borders and Background Colors in Excel
Copy Formatting How to Copy Formatting in Excel
Row Heights and Column Widths How to Adjust Row Heights and Column Widths in Excel
Insert Objects
Images How to Insert Images in Excel
Shapes How to Insert and Format Shapes in Excel
Hyperlinks How to Insert Hyperlinks in Excel
Object Properties and Alt Text How to Adjust Object Properties and Alt Text in Excel
View and Manage Worksheets
View Worksheets How to Change Worksheet Views in Excel
Multiple Windows How to Work with Multiple Windows in Excel
Move and Copy Worksheets How to Move and Copy Worksheets in Excel
Insert, Rename, and Delete Worksheets How to Insert, Rename, and Delete Worksheets in Excel
Freeze Rows and Columns How to Freeze and Unfreeze Rows and Columns in Excel
Hide Worksheets and Gridlines How to Hide Worksheets and Gridlines in Excel
Charts
Create Charts How to Create Charts in Excel
Move and Resize How to Move and Resize a Chart in Excel
Chart Types How to Change Chart Types in Excel
Layout and Style How to Apply Chart Layouts and Styles in Excel
Titles and Legends How to Customize Chart Titles and Legends in Excel
Gridlines, Labels, and Data Tables How to Display Chart Gridlines, Labels, and Data Tables in Excel
Chart Elements How to Format Chart Data in Excel
Modify Chart Data How to Modify Chart Data in Excel
Filter Charts How to Filter Charts in Excel
Trendlines How to Add Trendlines in Excel
Dual-Axis Charts How to Create Dual-Axis Charts in Excel
Chart Templates How to Create Chart Templates in Excel
Sparklines How to Add Sparklines in Excel
Print and Distribute
Page Size and Scale How to Adjust Page Size and Scale in Excel
Print Area and Page Breaks How to Set Print Area and Page Breaks in Excel
Print Titles, Gridlines, and Headings How to Print Titles, Gridlines, and Headings in Excel
Headers and Footers How to Add Headers and Footers in Excel
Margins and Orientation How to Adjust Margins and Orientation in Excel
Inspect for Issues How to Inspect for Issues in Excel
Intermediate Formulas
Reference External Worksheets How to Reference External Worksheets in Excel
Absolute and Relative References How to use Absolute and Relative Cell References in Excel
Order of Operations Order of Operations in Excel
Cell and Range Names How to Add Cell and Range Names in Excel
Insert Functions How to Insert Functions in Excel
CONCATENATE Function How to use the Concatenate Text Function in Excel
PMT Function How to Use the PMT Function in Excel
Display Formulas How to Display Formulas in Excel
Date Formulas How to Use Date Formulas in Excel
Manage Data
Quick Analysis The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline.
Outline and Subtotal How to Use the Outline and Subtotal Features in Excel
Data Validation How to Use Data Validation Rules in Excel
Flash Fill How to Use Flash Fill in Excel
Import and Export Data How to Import and Export Excel Data
Tables
Insert a Table How to Insert a Table in Excel
Sort Data How to Sort Data in Excel
Filter Data How to Filter Data in Excel
Add Rows and Columns How to Add Rows and Columns to Excel Tables
Table Styles How to Apply Table Styles in Excel
Remove Duplicates How to Remove Duplicates in Excel
Slicers How to Use Slicers in Excel
Structured References How to Use Structured References in Excel
Intermediate Formatting
Apply Conditional Formatting How to Apply Conditional Formatting in Excel
Apply and Remove Cell Styles How to Apply and Remove Cell Styles in Excel
Create and Modify Cell Styles How to Create and Modify Cell Styles in Excel
Find and Replace Formatting How to Find and Replace Formatting in Excel
Apply a Theme How to Apply a Theme in Excel
Collaborate with Excel
Cell Comments How to Add, Edit, and Delete Cell Comments in Excel
Share Workbooks How to Share Workbooks in Excel
Track Changes
Protect a Worksheet How to Protect a Worksheet in Excel
Protect Workbook Structure How to Protect a Workbook's Structure in Excel
Manage Workbook Versions How to Use Version History in Excel
Password Protection How to Add Password Protection in Excel
PivotTables
Create PivotTables How to Create PivotTables in Excel
Add Multiple PivotTable Fields How to Add Multiple PivotTable Fields to a PivotTable in Excel
Change a PivotTable's Calculation How to Change a PivotTable's Calculation in Excel
Add Calculated Fields How to Add and Remove Calculated Fields in Excel PivotTables
The GETPIVOTDATA Function How to Use the GETPIVOTDATA Function in Excel
Filter PivotTables How to Filter PivotTables in Excel
Timelines How to Add a Timeline in Excel
PivotTable Layout Adjust a PivotTable's Layout in Excel
Group Values How to Group Values in Excel
Refresh a PivotTable How to Refresh a PivotTable in Excel
Format a PivotTable How to Format a PivotTable in Excel
PivotCharts
Create PivotCharts How to Create PivotCharts in Excel
PivotChart Options PivotChart Options in Excel
PivotChart Styles How to Apply PivotChart Styles in Excel
Drill-Down Data How to Drill-Down Chart Data in Excel
Troubleshoot Formulas
Formula Errors How to Fix Formula Errors in Excel
The Watch Window How to The Watch Window in Excel
Evaluate Formulas How to Evaluate Formulas in Excel
Advanced Formatting
Customize Conditional Formatting How to Customize Conditional Formatting in Excel
Conditional Formatting with Formulas How to Use Conditional Formatting with Formulas in Excel
Manage Conditional Formatting How to Manage Conditional Formatting in Excel
International Currency and Formats How to Use International Currency and Formats in Excel
Body and Heading Options How to Apply Body and Heading Font Options in Excel
Color Formats How to Create and Apply Color Schemes in Excel
Custom Themes How to Create and Apply Custom Themes in Excel
Form Controls How to Form Controls in Excel
Save Form Templates How to Save a Form as a Template in Excel
Advanced Formulas
IF Function How to Use the IF Function in Excel
Nested Functions How to Insert Nested Functions in Excel
AND, OR, and NOT Functions How to use AND, OR, and NOT Functions in Excel
SUMIF, AVERAGEIF, and COUNTIF Functions How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel
VLOOKUP How to Use the VLOOKUP Function in Excel
HLOOKUP How to Use HLOOKUP in Excel
INDEX and MATCH How to Use the INDEX and MATCH Functions in Excel
UPPER, LOWER, and PROPER How to Use UPPER, LOWER, and PROPER Functions in Excel
RIGHT, LEFT, and MID How to Use RIGHT, LEFT, and MID Functions in Excel
Formula Calculation Options How to Change Formula Calculation Options in Excel
Analyze Data
Goal Seek How to use Goal Seek feature in Excel
Scenario Manager How Use to Scenario Manager in Excel
Consolidate Data How to Consolidate Data in Excel
Macros
Enable Macros How to Enable Macros in Excel
Create Macros How to Create Macros in Excel
Modify Macros How to Modify Macros in Excel
Copy Macros How to Copy Macros in Excel
Getting Started
Understand the Excel Screen Understand the Excel Screen
Create Workbooks How to create blank & template-based workbooks in Excel
Navigate Worksheets How to Navigate Worksheets in Excel
Open Workbooks How to Open Workbooks in Excel
Save Workbooks How to Save Workbooks in Excel
AutoRecover How to AutoRecover Excel Files
The Quick Access Toolbar How to Use The Quick Access Toolbar in Excel
Print How to Print in Excel
Share a Workbook How to Share Workbooks in Excel
Help How to Get Help in Excel
Close and Exit How to Close and Exit from Excel
Edit a Workbook
Select Cells and Ranges How to Select Cells and Ranges in Excel
Edit Cell Data How to Edit Cell Data in Excel
Cut, Copy, and Paste How to Cut, Copy, and Paste in Excel
Undo, Redo, Repeat How to Use Undo, Redo, Repeat Commands in Excel
More Pasting Options How to Use Special Paste Options in Excel
Insert and Move Cells How to Insert and Move Cells in Excel
Delete Cells How to Delete Cells in Excel
Check Spelling Learn how you use Excel's spell check to proof your worksheets for spelling errors.
Find and Replace Text How to Use Find and Replace in Excel
Hide Columns and Rows How to Hide Columns and Rows in Excel
Workbook Properties How to View and Edit Document Properties in Excel
Basic Formulas
Formula Basics How to Create Basic Formulas in Excel
AutoFill How to Use AutoFill in Excel
Sums and Averages How to Use Sum and Average Formulas in Excel
MIN and MAX How to Use MIN and MAX Functions in Microsoft Excel
COUNT How to Use the COUNT Function in Excel
Basic Formatting
Format Text How to Apply Formatting to Text in Excel
Align and Merge Cells To merge cells in Excel, select the cells you want to merge, click the Merge list arrow and select a merge option.
Format Numbers and Dates How to Format Numbers and Dates in Excel
Borders and Background Colors How to Add Cell Borders and Background Colors in Excel
Copy Formatting How to Copy Formatting in Excel
Row Heights and Column Widths How to Adjust Row Heights and Column Widths in Excel
Insert Objects
Images How to Insert Images in Excel
Shapes How to Insert and Format Shapes in Excel
Hyperlinks How to Insert Hyperlinks in Excel
Object Properties and Alt Text How to Adjust Object Properties and Alt Text in Excel
View and Manage Worksheets
View Worksheets How to Change Worksheet Views in Excel
Multiple Windows How to Work with Multiple Windows in Excel
Move and Copy Worksheets How to Move and Copy Worksheets in Excel
Insert, Rename, and Delete Worksheets How to Insert, Rename, and Delete Worksheets in Excel
Freeze Rows and Columns How to Freeze and Unfreeze Rows and Columns in Excel
Hide Worksheets and Gridlines How to Hide Worksheets and Gridlines in Excel
Charts
Create Charts How to Create Charts in Excel
Move and Resize How to Move and Resize a Chart in Excel
Chart Types How to Change Chart Types in Excel
Layout and Style How to Apply Chart Layouts and Styles in Excel
Titles and Legends How to Customize Chart Titles and Legends in Excel
Gridlines, Labels, and Data Tables How to Display Chart Gridlines, Labels, and Data Tables in Excel
Chart Elements How to Format Chart Data in Excel
Modify Chart Data How to Modify Chart Data in Excel
Filter Charts How to Filter Charts in Excel
Trendlines How to Add Trendlines in Excel
Dual-Axis Charts How to Create Dual-Axis Charts in Excel
Chart Templates How to Create Chart Templates in Excel
Sparklines How to Add Sparklines in Excel
Print and Distribute
Page Size and Scale How to Adjust Page Size and Scale in Excel
Print Area and Page Breaks How to Set Print Area and Page Breaks in Excel
Print Titles, Gridlines, and Headings How to Print Titles, Gridlines, and Headings in Excel
Headers and Footers How to Add Headers and Footers in Excel
Margins and Orientation How to Adjust Margins and Orientation in Excel
Inspect for Issues How to Inspect for Issues in Excel
Intermediate Formulas
Reference External Worksheets How to Reference External Worksheets in Excel
Absolute and Relative References How to use Absolute and Relative Cell References in Excel
Order of Operations Order of Operations in Excel
Cell and Range Names How to Add Cell and Range Names in Excel
Insert Functions How to Insert Functions in Excel
CONCATENATE Function How to use the Concatenate Text Function in Excel
PMT Function How to Use the PMT Function in Excel
Display Formulas How to Display Formulas in Excel
Date Formulas How to Use Date Formulas in Excel
Manage Data
Quick Analysis The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline.
Outline and Subtotal How to Use the Outline and Subtotal Features in Excel
Data Validation How to Use Data Validation Rules in Excel
Flash Fill How to Use Flash Fill in Excel
Import and Export Data How to Import and Export Excel Data
Tables
Insert a Table How to Insert a Table in Excel
Sort Data How to Sort Data in Excel
Filter Data How to Filter Data in Excel
Add Rows and Columns How to Add Rows and Columns to Excel Tables
Table Styles How to Apply Table Styles in Excel
Remove Duplicates How to Remove Duplicates in Excel
Slicers How to Use Slicers in Excel
Structured References How to Use Structured References in Excel
Intermediate Formatting
Apply Conditional Formatting How to Apply Conditional Formatting in Excel
Apply and Remove Cell Styles How to Apply and Remove Cell Styles in Excel
Create and Modify Cell Styles How to Create and Modify Cell Styles in Excel
Find and Replace Formatting How to Find and Replace Formatting in Excel
Apply a Theme How to Apply a Theme in Excel
Collaborate with Excel
Cell Comments How to Add, Edit, and Delete Cell Comments in Excel
Share Workbooks How to Share Workbooks in Excel
Track Changes
Protect a Worksheet How to Protect a Worksheet in Excel
Protect Workbook Structure How to Protect a Workbook's Structure in Excel
Manage Workbook Versions How to Use Version History in Excel
Password Protection How to Add Password Protection in Excel
PivotTables
Create PivotTables How to Create PivotTables in Excel
Add Multiple PivotTable Fields How to Add Multiple PivotTable Fields to a PivotTable in Excel
Change a PivotTable's Calculation How to Change a PivotTable's Calculation in Excel
Add Calculated Fields How to Add and Remove Calculated Fields in Excel PivotTables
The GETPIVOTDATA Function How to Use the GETPIVOTDATA Function in Excel
Filter PivotTables How to Filter PivotTables in Excel
Timelines How to Add a Timeline in Excel
PivotTable Layout Adjust a PivotTable's Layout in Excel
Group Values How to Group Values in Excel
Refresh a PivotTable How to Refresh a PivotTable in Excel
Format a PivotTable How to Format a PivotTable in Excel
PivotCharts
Create PivotCharts How to Create PivotCharts in Excel
PivotChart Options PivotChart Options in Excel
PivotChart Styles How to Apply PivotChart Styles in Excel
Drill-Down Data How to Drill-Down Chart Data in Excel
Troubleshoot Formulas
Formula Errors How to Fix Formula Errors in Excel
The Watch Window How to The Watch Window in Excel
Evaluate Formulas How to Evaluate Formulas in Excel
Advanced Formatting
Customize Conditional Formatting How to Customize Conditional Formatting in Excel
Conditional Formatting with Formulas How to Use Conditional Formatting with Formulas in Excel
Manage Conditional Formatting How to Manage Conditional Formatting in Excel
International Currency and Formats How to Use International Currency and Formats in Excel
Body and Heading Options How to Apply Body and Heading Font Options in Excel
Color Formats How to Create and Apply Color Schemes in Excel
Custom Themes How to Create and Apply Custom Themes in Excel
Form Controls How to Form Controls in Excel
Save Form Templates How to Save a Form as a Template in Excel
Advanced Formulas
IF Function How to Use the IF Function in Excel
Nested Functions How to Insert Nested Functions in Excel
AND, OR, and NOT Functions How to use AND, OR, and NOT Functions in Excel
SUMIF, AVERAGEIF, and COUNTIF Functions How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel
VLOOKUP How to Use the VLOOKUP Function in Excel
HLOOKUP How to Use HLOOKUP in Excel
INDEX and MATCH How to Use the INDEX and MATCH Functions in Excel
UPPER, LOWER, and PROPER How to Use UPPER, LOWER, and PROPER Functions in Excel
RIGHT, LEFT, and MID How to Use RIGHT, LEFT, and MID Functions in Excel
Formula Calculation Options How to Change Formula Calculation Options in Excel
Analyze Data
Goal Seek How to use Goal Seek feature in Excel
Scenario Manager How Use to Scenario Manager in Excel
Consolidate Data How to Consolidate Data in Excel
Macros
Enable Macros How to Enable Macros in Excel
Create Macros How to Create Macros in Excel
Modify Macros How to Modify Macros in Excel
Copy Macros How to Copy Macros in Excel