Microsoft Excel Training Course

Microsoft Excel is an electronic spreadsheet and it is mainly used for manipulating numerical information. Among other things, spreadsheets enable you to produce budget reports, financial plans and profit and loss statements. 

They re-calculate automatically, providing huge savings in time, and their formatting tools allow you to present well laid out reports.

This is can be delivered as a half-day or full day course.

Skills gained:

  • Entering information into an existing spreadsheet
  • Creating and formatting a simple spreadsheet
  • Saving and opening a spreadsheet
  • Printing spreadsheets

Course Details

Duration: 1 day.
Dates: Contact us for availability.
Location: Our MS Excel training courses are held at 26 Palmerston Place, Edinburgh, Scotland
Fees: £279.00 + VAT

View the course content

We can provide bespoke training as a ½ day or full day session tailored to your needs - please call or email us for details.

Get in Touch

Book Now bade

Questions?

If you have any questions about our training courses or just want to discuss your requirements with a member of our training team then you can:

For more information about payment, please read our terms and conditions.

To express a register of interest for this MS Excel course fill in the form below:







Microsoft Excel Course Contents

The following represents a typical breakdown of our Microsoft Excel course, however we can tailor all our courses to specific requirements as required.

Introduction to Microsoft Excel
  • Get started with Excel
  • Enter, change and delete numbers and labels
  • Create and copy formulas
  • Move and copy ranges
  • Format cells to display decimals, currency and dates
  • Insert and delete rows and columns
  • Save and open spreadsheets
Advanced Microsoft Excel
Consolidation, Names and Protection
Consolidate using 3D references
Work with Names
Protect your Spreadsheet
Freezing Panes, Comments, Styles and Templates
Freeze Panes
Insert Comments
Save Styles and Templates
What-If Analysis
Track a What-If Analysis with Scenario Manager
Project figures using Data Tables
Use Goal Seek
Set up a complex What-If Analysis with Solver
Managing Data Lists
Plan a List
Create a List
Add, find and delete records
Sort a List
Filtering and Validating Data Lists
Retrieve records using AutoFilter
Create a Custom Filter
Use the Advanced Filter
Set up Subtotals
Validate Data.
PivotTable Reports
Create a PivotTable report
Change the summary function of a PivotTable report
Change the structure of a PivotTable report
Update a PivotTable report
Create a Chart from a PivotTable.
Functions
Logical Functions
Date & Time Functions
Statistical Functions
Text Functions
Database Functions
Nested Functions
Further Useful Tools
Import a text file
Audit your Worksheet