COVID NOTIFICATION: We are still providing full-scale remote and onsite support for our clients. Our team, the equipment, and the HDCav Help Van are all operating in accordance by the strictest health protection guidelines. Help Desk Cavalry is committed to the safety of your team as well as ours.

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