Microsoft Excel

Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions.

The following links will provide you with information to familiarize and get you started with Microsoft Word.

Get Started with Excel

• What is Excel?
• Create a workbook
• Add, delete, or rename sheets

Design workbooks

• Hide or unhide columns
• Freeze top and left panes
• Move or copy worksheets
• Apply themes to change the look of a workbook

Add and edit data

• Add and edit data
• Resize and merge cells and align data
• Format numbers in cells
• Change the look of cells
• Copy cell formatting
• Select cell contents
• Move or copy cell contents
• Insert or delete rows or columns
• Resize rows and columns
• AutoFill time spans
• Split and combine data
• Build custom numeric formats
• Validate cell data
• Create reusable lists

Use formulas and functions

• Create formulas
• Name cells and ranges
• Use Trace to fix formula errors
• Locate functions
• Calculations using functions

Add and format tables

• Create and format tables
• Sort data in a table
• Filter data in a table
• Add a Total row to a table
• Filter data with slicers

Add and format charts

• Create charts
• Format charts
• Add sparkline charts
• Add trendlines and drop lines

Analyze and chart data

• Quick Analysis of data

Create and format PivotTables and PivotCharts

• Create PivotTables
• Work with PivotTables
• Group data in PivotTables
• Filter data with Slicers in PivotTables
• Create PivotCharts

Collaborate with others

• Share workbooks
• Add and review comments

Password-protect workbooks

• Password-protect workbooks