Multitask Training
Multitask Training

Microsoft Excel Courses

Course outlines are for guidance and can be adjusted to suit your requirements.

Excel Foundation - 1 day

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 Intermediate - 1 day

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

 

Charts

• Further charting functionality

• Multiple axis

• Tricks and ideas

Excel Advanced - 1 day

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

• Summarising multiple worksheets
 

Text & Date Functions

• Using the text and date functions

 

Macros

• Recording • Saving • Using

 

Further Features (subject to time)

• Goal seek
• Auditing tools
• Templates
• Scenarios
• Data tables

Get in Touch

Discuss your project or pricing with us:

View paula wheeler's profile on LinkedIn
Google+
Print Print | Sitemap Recommend this page Recommend this page
Multitask Training copyright 2017