Microsoft Excel – Level 1

1 Day Course

Lesson 1: Getting Started

Creating, Opening and Saving a New Workbook
About Excel File Types
Understanding Cells
Getting Help

Lesson 2: Formulas

Entering and Deleting Data
The Syntax of a Formula
Adding, Subtracting, Dividing and Multiplying
BEDMAS
AutoFill

Lesson 3: Basic Functions

The Syntax of a Function
The Insert Function Dialog Box
AutoSum
AVERAGE, MIX, MAX, COUNT Functions

Lesson 4: Copy, Pasting and Moving Data in Excel

Dragging and Dropping Cells
Copy Data
Paste Special
Paste Functions, Values and Links

Lesson 5: Sorting and Filtering Data

Sorting Alphabetically, Numerically and Chronologically
Creating a Custom Sort
Using AutoFilters
Filtering Text, Numbers and Dates
Flash Fill

Lesson 6: Workbook and Worksheet Formatting

Adding, Deleting and Renaming Worksheets
Changing the Size of Rows or Columns
Inserting Rows and Columns
Adjusting Cell Alignment
Rotating Text

Lesson 7: Cell Formatting

Conditional Formatting
The Format Painter
Cell Merging and AutoFit

Lesson 8: Charts

Creating a Chart
Styling and Modifying Charts
Changing the Type of Chart
Changing the Source Data
Working with the Chart Axes and Data Series

Lesson 9: Printing and Viewing Your Workbook

Excel Views
Inserting Comments
Freeze Panes
Print Commands
Print Preview