Microsoft Excel Courses

Excel Basics

• Exploring the screen

• Understanding the concepts

• Entering & editing data

• Moving & copying

• Selecting techniques

• Autofill

• Saving & opening

Formats

• Cell formatting

• Row & column options

Formula

• Calculations (+-*/)

• Autosum

• Functions (i.e. average)

• Percentages

• Relative & absolute

Further Formats

• Text wrap

• Merging cells

• Borders / shading

• Conditional formatting

Worksheets

• Inserting / deleting / renaming sheets

• Moving and copying sheets

Printing and Viewing your Workbook

• Setting up your printing options

• Freezing the headings & view options

Introduction to Charts

• Creating a simple chart

• Formatting chart elements

Excel Basics - Review

• Revisiting simple formula • Autosum

• Percentages • Autofill

Other Features

• Comments & hyperlinks

• Range names

• Absolute cell referencing

• More on conditional formatting

Functions

• Counta, Count blank, Countif, Sumif

• If statements

• Date calculations

• Tracing elements & the watch window

Linking

• Linking across sheets and workbooks

• Grouping sheets

Data Options

• Sorting and filtering

• Data form

• Subtotals

• Outline and grouping

Protection & Control

• Protecting your worksheets & workbooks

• Data validation

Further Formula & Lookups

• Nesting formula

• Logical functions (i.e. and, or, not)

• Error handling

• VLookups

Pivot Tables

• Creating and control pivot tables

• Creating pivot charts

• Slicers

Data Consolidation

Text & Date Functions

Macros

Further Features (subject to time)