Basic Excel – Below is the standard Basic course. This is covered in 1 day and handout notes and an example spreadsheet are provided.

 

 

1.       Introduction

• a.       Creating a new spreadsheet

• b.       Opening an existing spreadsheet

• c.       Renaming a spreadsheet

• d.       Entering text into cells

• e.       Deleting text in cells

• f.        Saving a spreadsheet

 

2.       Ranges

• a.       Inserting columns and Rows

• b.       Undo Command

• c.       Copy and Pasting

• d.       Changing Width of rows and columns

• e.       Applying and using Filters

• f.        AutoFill and Flashfill

• g.       Freeze panes

 

3.       Tables

• a.       Creating a table

• b.       Adding / deleting rows and columns to a table

• c.       Formatting a table

 

4.       Formatting

• a.       Format Function

• b.       Merging Cells

• c.       Text Wrap

• d.       Set Print Area

 

5.       Simple Formaulae

• a.       Adding, multiplying, subtracting or dividing 2 cells

• b.       Autosum

• c.       Percentages

 

6.       Charts

• a.       Creating and formatting a bar chart

• b.       Creating and formatting a line chart

• c.       Creating and formatting a pie chart