Introduction

1. Curriculum

10:00

Level 1, Section 1 - An introduction to Excel

1. Creating new blank workbooks

3:00

2. Entering data

9:00

3. An introduction to fonts and highlighting

6:00

4. Saving and closing your workbook

5:00

5. Practice Activity Number 1 - The Solution

3:00

Level 1, Section 2 - Create worksheets and workbooks

1. Creating new workbooks using templates

6:00

2. Menus and toolbars

7:00

3. Managing multiple workbooks

4:00

4. Importing files and Opening non-native files directly in Excel

10:00

5. Adding worksheets to existing workbooks

3:00

6. Copying and moving worksheets, and changing spreadsheet order

6:00

Level 1, Section 3 - Configure worksheets and workbooks to save

1. Saving workbooks in alternate file formats

9:00

2. Maintaining backward compatibility

5:00

3. Saving files to remote locations

2:00

Level 1, Section 4 - Basic formulas

1. Using basic operators

6:00

2. Order of operations

6:00

3. How to enter numbers and dates in Excel

4:00

4. Referencing cell ranges in formulas

11:00

5. Solution to the above exercise

2:00

6. Practice Activity Number 2 - Solution

5:00

Level 2, Section 1 - Navigate through Excel worksheets and workbooks

1. Searching for data within a workbook

5:00

2. Hyperlinks

4:00

3. Using Go To and Using Name Box

5:00

4. Hot Keys

3:00

Level 2, Section 2 - Format worksheets and workbooks

1. Changing worksheet tab colour

3:00

2. Inserting and deleting columns and rows

6:00

3. Undo and Redo

4:00

4. File Management tips

5:00

5. Adjusting row height and column width

4:00

6. Hiding columns and rows

3:00

7. Selecting multiple ranges

3:00

8. Practice Activity Number 3 - Solution

3:00

Level 2, Section 3 - Customise options and views for worksheets and workbooks

1. Hiding worksheets

3:00

2. Customising the Quick Access toolbar

3:00

3. Customising the Ribbon

5:00

4. Assigning shortcut keys

2:00

5. Recording simple macros

5:00

6. Managing macro security

8:00

7. Changing workbook views

3:00

8. Using zoom

2:00

9. Adding values to workbook properties

3:00

10. Displaying formulas

2:00

11. Freezing panes

4:00

12. Splitting the window

2:00

13. Practice Activity Number 4 - The Solution

3:00

Level 2, Section 4 - Configure Excel worksheets and workbooks to print

1. Printing individual worksheets

3:00

2. Printing an entire workbook and printing a selection

2:00

3. Setting a print area

3:00

4. Page setup, Part 1 (first two tabs)

4:00

5. Page setup, Part 2 (Repeating headers and footers)

2:00

6. Adding dynamic text to headers and footers

3:00

7. Inserting watermarks

4:00

8. Page setup, Part 3 (Headings etc.)

5:00

9. Configuring workbooks to print

2:00

10. Inspecting your workbook prior to distribution

4:00

11. Practice Activity Number 5 - The Solution

2:00

Level 2, Section 5- Utilise cell ranges and references informulas and functions

1. Copying and pasting basics, and Utilising references (relative, mixed, absolute)

8:00

2. Practice Activity - multiplication table

2:00

3. Answer - multiplication table

4:00

Level 3, Section 1 - Insert data in cells and ranges

1. Appending data to Excel worksheets

3:00

2. Setting data validation

11:00

3. Finding and replacing data

7:00

4. Copying and pasting data, including Paste Special

6:00

5. Cutting and moving cell data

4:00

6. Using AutoFill tool, and Expanding data across columns

7:00

7. Practice Activity Number 6 - The Solution

3:00

Level 3, Section 2 - Format cells and ranges

1. Modifying cell alignment and indentation

5:00

2. Wrapping text within cells

4:00

3. Merging cells and Shrink to Fit

5:00

4. Changing font and font styles

5:00

5. Applying highlighting

3:00

6. Applying Number format

10:00

7. Applying borders

4:00

8. Applying cell styles

2:00

9. Using Format Painter

2:00

10. Changing text to WordArt

1:00

11. Practice Activity Number 7 - The Solution

2:00

Level 3, Section 3 - Highlight and filter cells and ranges in Excel

1. Applying conditional formatting - highlighting

11:00

2. Applying conditional formatting - Bars, Scales and Sets

7:00

3. Transposing columns and rows, and #####s

3:00

4. Inserting sparklines, and how to define a range

4:00

5. Customising Sparklines

6:00

6. Practice Activity Number 8 - The Solution

2:00

Level 3, Section 4 - Summarise data with Excel functions

1. Doing calculations without formulas

2:00

2. Utilising the SUM function

3:00

3. Formula syntax - SUM function

5:00

4. Utilising the COUNT function

5:00

5. Utilising the AVERAGE and other averaging functions

5:00

6. Utilising the MIN and MAX functions

2:00

7. Creating named ranges

5:00

8. Getting help with functions

3:00

9. Practice Activity Number 9 - The Solution

3:00

Level 4, Section 1 - Create a table

1. Moving between tables and ranges

4:00

2. Adding and removing cells within tables

3:00

3. Formulas in tables

7:00

4. Defining titles

5:00

Level 4, Section 2 - Modify a table

1. Inserting total rows

6:00

2. Adding and removing styles and Banding rows and columns

6:00

3. Practice Activity Number 10 - The Solution

2:00

Level 4, Section 3 - Filtering, Sorting and Grouping

1. Setting up a filter and Filtering records

7:00

2. More advanced filtering options

13:00

3. Using sort options

6:00

4. Sorting data on multiple columns; changing sort order

5:00

5. Removing duplicates

6:00

6. Inserting subtotals

5:00

7. Creating outlines; collapsing groups of data in outlines

9:00

8. Utilising the SUBTOTAL function

8:00

9. Practice Activity Number 11 - The Solution

5:00

Level 4, Section 4 - Utilise conditional logic in functions

1. Utilising the IF function

15:00

2. Utilising the SUMIF function

5:00

3. Utilising the COUNTIF function

4:00

4. Utilising the AVERAGEIF function

3:00

5. Evaluate Formulas

7:00

6. Nested IFs

8:00

7. The CHOOSE function

4:00

8. Practice Activity Number 12 - The Solution

3:00

Level 5, Section 1 - Create a chart in Excel

1. Creating charts and graphs

4:00

2. Adding and removing additional data series

3:00

3. Exploring the Column charts

4:00

4. Line, bar and area charts

4:00

5. Pie charts

3:00

6. Other graph types

5:00

7. Switching between rows and columns in source data

2:00

Level 5, Section 2 - Format a chart in Excel

1. Adding legends

6:00

2. Positioning and Resizing charts and graphs, inc. moving charts into chart sheets

5:00

3. Modifying chart and graph parameters

8:00

4. Applying chart layouts and styles

2:00

Level 5, Section 3 - Insert and format an object

1. Inserting text boxes and positioning objects

3:00

2. Inserting SmartArt

4:00

3. Inserting ClipArt and images

3:00

4. Inserting Screenshots

2:00

5. Adding borders to objects

4:00

6. Inserting shapes

4:00

7. Adding styles and effects to objects

3:00

8. Changing workbook themes

3:00

9. Modifying object size and properties, including adding alternate text

5:00

Level 5, Section 4 - create and modify images by using the Image Editor

1. Making corrections to an image

3:00

2. Using picture colour tools

2:00

3. Send to front and back, and transparent colour

4:00

4. Changing artistic effects on an image

2:00

5. Crop picture

4:00

Level 5, Section 5 - Format and modify text with functions

1. Utilising the CONCATENATE function

5:00

2. Utilising the RIGHT, LEFT and MID functions

6:00

3. Utilising the LEN function

3:00

4. Utilising the UPPER and LOWER functions

3:00