Microsoft Excel Level 3

Course Aims

This course will give learners a solid understanding of advanced Excel tools and concepts in order to increase their knowledge and productivity in the shortest possible time.
This practical course is intended for existing users of Microsoft Excel and will allow learners to appreciate the full potential of this software.

By the end of the course, the user will be competent with the following skills:

Course Content

Advanced Functions

  • Logical Functions
  • Date & Time Functions
  • Lookup Functions
  • Maths & Trig Functions
  • Statistical Functions
  • Text Functions
  • Financial Functions
  • Database Functions
  • Nested Functions

Advanced Charts

  • Use Chart Options
  • Add Moving Averages to Charts
  • Change a 3D Chart View
  • Use Data Labels & Markers
  • Create Stacked Bar Charts


  • Create an Outline
  • Work With an Outline


  • Use Drawing Tools
  • Create & Delete Drawing Objects
  • Format Drawing Objects
  • Align, Group & Rotate Drawing Objects
  • Insert WordArt
  • Insert Objects
  • Use the Clip Gallery

Data Tables

  • Create a One Input Data Table
  • Create a Two Input Data Table

Analyse Data Using:

  • Descriptive Statistics
  • Correlation
  • Histograms
  • Moving Averages
  • The Random Number Generator
  • Sampling


  • Understand Styles
  • Create, Use & Delete Styles

Data Consolidation

  • Consolidate Data by Position
  • Consolidate Data by Categor
  • Edit Reference Areas


  • Understand Macros
  • Control Marco Security
  • Record a Macro
  • Add a Macro to a Menu
  • Assign a Macro to the Quick Access Toolbar
  • Assign a Macro to a Button on a Worksheet
  • Edit a Macro
  • Edit a Macro Button


  • Use Auditing Tools
  • Trace Precedents & Dependents
  • Add & Remove Tracer Arrows
  • Trace Errors
  • Use Data Validation
  • Use Watch Window
  • Evaluate Formulas


  • Create & Format Paper Forms
  • Use the Forms Tools
  • Create & Use Online Forms

Sharing Workbooks

  • Share Workbooks
  • Track Changes
  • Accept or Reject Changes

Importing Data

  • Import External Data
  • Import Text Files
  • Import Data from Access
  • Convert to Access
  • Import from Another Excel File
  • Refresh Data

Who Should Attend?

Anyone wishing to investigate the more powerful and advanced features of Excel. Learners should have
a good working knowledge and understanding of the concepts covered in the Level 1 and Level 2
courses. A good working knowledge of the Microsoft Windows operating system is also required.

Follow on Course
Other Microsoft Office courses

Other Courses



Call James now on 0131 625 7151 to get a full detailed course description and next available dates.

Course Location

This course will be run at the Edinburgh Training and Conference Venue, which is situated in the centre of Edinburgh, just 5 minutes walk from Waverley Station and close to major bus routes, including the airport bus. Discounted parking is available at the St John’s Hill NCP Car Park. Our training rooms are light and spacious, all are air conditioned with natural daylight.

Complimentary breakfast and lunch will provided, as well as tea and coffee throughout the day. If you’ve got any special dietary requirements just let us know, ideally in advance, and we will be pleased to cater for them. Our team will be there on the day to make sure everything goes smoothly. If there’s anything you need please ask, because “If we Can we Will”.

Chat with us
Chat with us
Hello, how can we help you?
We are offline, but if you leave your message and contact details, we will get to to you as quickly as we can.
All of our operators are busy. Please try again later..
How can we help?
This chat session has ended
Was this conversation useful? Vote this chat session.
Good Bad