Excel Fundamentals Course duration: 1 day

Excel Basics
Spreadsheet terminology.
Exploring the Excel window.
Navigating Worksheet
Selecting Cells

Entering and Editing Data
Creating a new Excel workbook.
Entering and editing labels and values.
Saving and updating a workbook.

Printing
Preparing to print.
Page set up options.
Page Layout Tab.
Page Layout View.

Modifying a Worksheet
Moving and copying data.
Moving and copying formulas.
Using absolute references.
Inserting and deleting Rows.

Using Functions
Entering Functions.
Using Autosum.
Using AVERAGE, MIN, MAX, and COUNT.

Creating Formulas
Add.
Multiply.
Divide.
Subtract.
Order of Precedence.
Absolute References.

Formatting Worksheets
Formatting text.
Formatting rows and columns.
Number formatting.
Other formatting features.

Hints and Tips
Quick Analysis
Filling a series