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

Outlines

  • Create an Outline
  • Work With an Outline

Objects

  • 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

Styles

  • Understand Styles
  • Create, Use & Delete Styles

Data Consolidation

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

Macros

  • 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

Auditing

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

Forms

  • 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

To book your place or for more information, call us on 0131 625 7142, or complete the form below:

Course Enquire

We’ll only use these details to contact you about your Course enquiry. Privacy Policy

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 ?
Connecting...
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