Microsoft Excel Training
Please note that load times may lag on your first visit to this page, but as long as you don’t clear your browser cache, subsequent visits will load speedily. Happy viewing!
Jump to other Microsoft Office Applications
Microsoft Excel Application
Microsoft Excel is the industry leading spreadsheet program, a powerful data visualization and analysis tool. It features calculation, graphing tools, pivot tables, and a macro programming language that allows users to manipulate data in power ways as well as collaborate, share, present, and integrate with other Microsoft 365 applications, such as Word and PowerPoint.
Building Foundations
Select Cells
Copy Cells
Import Data from a Web Page
Formatting
Format Numbers in Cells
Copy Cell Formatting
Conditional Formatting
Merge and Unmerge Cells
Split Data into Different Columns
Hide and Unhide Columns
Freeze Columns or Rows
Promote a Row to a Column Header
How to Add an Index Column
Insert or Delete a Worksheet
Move or Copy Worksheets
Apply Styles
Functions and Formulas
Create Formulas and Functions
Quick Subtraction
Use VLOOKUP
Use the IF Function
Use the IFS Function
Use the SUM Function
Use the SUMIF Function
Use the SUMIFS Function
Quick Multiplication
Add a Column from an Example
Add a Conditional Column
Use the SUMIFS Function
Name Cells and Ranges