Try Excel exercises

Introduction - Intermediate - Advanced

Microsoft Excel is a very comprehensive spreadsheet software package that can be used to maintain business accounts, contact databases and many other features.  Training starts at basic data input, data formatting and simple maths, progressing to data analysis and manipulation.

 

These outlines are guides only.  Any course can be customised to suit

 

You will learn how to:

Introduction
Use the Excel Default Screen
Understanding Excel Worksheets/Workbooks
How to Navigating an Excel Workbook
How to Entering Data in to an Excel worksheet
How to Selecting Cells within and Excel worksheet
How to Editing Data in an Excel worksheet
How to Format Excel Cells to display Dates, Percentages, Currency etc
How to use the AutoSum/Average/Max/Min functions in Microsoft Excel
Understand how to use Basic Sums in Microsoft Excel
Understanding Mathematical Precedence
How to Copy and Paste Data in Microsoft Excel
Using the Auto Fill Feature in Microsoft Excel
Saving a Workbook in Microsoft Excel
How to format a spreadsheet using the Borders Feature and format Cells in Microsoft Excel
How to create Charts using the wizard in Microsoft Excel
How to Format Charts in Microsoft Excel
Hiding Columns in Microsoft Excel
Moving Columns/Inserting Columns in Microsoft Excel
Using Database Filters in Microsoft Excel
How to use Excel Database Sorts/Forms

Intermediate
Use the Average function in Microsoft Excel
Use the Maximum function in Microsoft Excel
Use the Minimum function in Microsoft Excel
How to use Basic Scenarios in Microsoft Excel
Learn how to use Sheet Layout and design in Microsoft Excel
Learn how to Named Cells/Ranges in Microsoft Excel
Understand how Absolute Referencing works in Microsoft Excel
Learn how to use Basic Pivot Tables in Microsoft Excel
Learn how to Linking Excel worksheets and workbooks
Learn how to use Goal Seek in Microsoft Excel
Learn how to Data Tables in Microsoft Excel
Learn how to apply Password Protection in Microsoft Excel
Learn how to use Array Formulae in Microsoft Excel
How to attach Comments to a Cell in Microsoft Excel
How to use the Excel Outline feature in Microsoft Excel
Learn how to Name Worksheets in Microsoft Excel
Learn how to use the Subtotals Feature in Microsoft Excel
Understand how basic templates work in Microsoft Excel
Learn how to use Basic Lookups in Microsoft Excel

Advanced
Learn how to use Solver in Microsoft Excel
Learn how to use basic IF Statements in Microsoft Excel
Learn how to use Advanced VlookUp and SUMIF functions in Microsoft Excel
How to use nesting functions IF And Match in Microsoft Excel
Using Functions to create Logical Tests, Error Trapping in Microsoft Excel
Using Form Tools in Microsoft Excel
How to use Data Validation in Microsoft Excel
Using Advanced Pivot Tables Formulae in Microsoft Excel
How to record basic Excel Basic Macros in Microsoft Excel
Importing External Data in Microsoft Excel
Using Named Ranges in a Formula in Microsoft Excel
Using Advanced Database Filters and functions in Microsoft Excel
How to use Excel Advanced Scenarios in Microsoft Excel
How to use Excel Investment Rate of Return Functions in Microsoft Excel
Using Text Functions, Left, Right, Mid, Large, Small and Replace in Microsoft Excel
Using Forecast and Frequency functions in Microsoft Excel

Session Plan

Introduction

Default screen

Basic data entry

Inserting Rows/Columns

Basic Maths

Basic formulae

Open file called Exercise – Exercise One

Basic formatting toolbars

Basic formatting format menu

Formatting Exercise

Page Setup

Print Preview

Header and Footer

Set print Area

Row to repeat at the top

Open the file called Database

Database Sort

Sort Menu

Copy and Paste

Cut and Paste

Open the file called Filter

Database filters

Exercise Auto Filter

Open the file called charting

Using the F11 key

Using the Wizard

Chart formatting

Line graphs

Consolidation Exercise One

Intermediate

Revision

Basic maths

Basic functions

Open the file called 3dref

3D referencing using examples

Linking workbooks

Open the file called 3D Test

Open the file called name

Absolute referencing

Using the F4 key

Naming cells

Navigation using named cells

Deleting named cells

Naming ranges

Using named cells in formulae

Naming exercise

Open the file called Array

Using array formulae

Open the file called Pivot --------File layouts split screen -- Arranging worksheets

Using the examples

Open the file called Sub

Using the examples

Open the file called Outline

Using the examples

Open the file called Goal seek

Using the examples

Open the file called Tables

Using the examples

Open the file called Scenarios

Using the exercises

Open the file called Function

Using a basic IF statement

Using Vlookup and Hlookup

Open the file called Filter

Using advance filters

Using database functions

Consolidation Exercise Two

ADVANCED

Revision

Basic maths

Basic functions

Open the file called function

Basic IF

Nested IF

IF AND

IF OR

Error Trapping

SUMIF

Vlookup – External Data – Using the Vlookup Bonus file – switching Vlookup

Hlookup

Combo box

Concatenation

IRR Function NPV function

Database functions

Deviation functions

Open the file called macroupdate

Create a simple macro

Create a macro button on the toolbar

Create a macro to copy and paste data

Creating a toolbar and Customising toolbars

Open the file validation

Using the examples

Open the file called Solprac

Using Solver

Using the examples

Changing Constraints

Open the file called Scenario

Using formulae in Scenarios

Open the file called Pivot

Using Pivot table to fetch external data, consolidation ranges, formulae

Open the file called Consolidation Three