Excel | Word | PowerPoint | Outlook | Milton Keynes | Rugby | Northampton

Excel level 3 – Advanced


  • Creating, Maintaining, Filtering and using Subtotals in a List
  • Recording, Assigning and Using Macros
  • Creating and Using User Defined Functions
  • Performing “What If” Analyses
  • Working with Scenarios
  • Querying a Database
  • Importing Files and Data

1: Who is the Course for?

This course is designed for users who have a good knowledge and understanding of spreadsheets and wish to use more advanced features of the programme.

2: The Course

Courses delivered by InIT Learning are tutor led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment the tutor will give one to one support as required.

3: Certificates

Each delegate will receive a manual and a certificate of attendance

4: Course Content

Naming Cells & Ranges
V & H Lookup
Index & Match
Logic – AND OR NOT
Excel Forms
Scenario Manager
Goal Seek
Installing Solver
Data Validation
Grouping & Outlining
Index & Match
Pivot Tables
Pivot Charts
Excel Macros
Macro Security
Saving a Macro Workbook
Recording & Running a Macro
Relative Cell References (Macros)
Viewing & Editing a Macro
Assigning Macros
Global Macros
Object to run Macros


Download Content>>>

Available In-House Courses

Microsoft Excel Microsoft Word Microsoft PowerPoint Microsoft Outlook
Excel Introduction Word Introduction PowerPoint in a Day (All Levels) Microsoft Outlook in a Day
Excel Intermediate Word Intermediate
Excel Advanced

Achieve for Success – Learning for Success – Progress for Success – Training for Success – Planning for Success – Develop for Success

Milton Keynes Chamber Member

InIT Learning Computer Courses Milton Keynes

0330 32 100 58


Simple Pricing Structureslidecbc63a156cc04de8813a463a020004cc1Courses @ Yours
£640.00 per course of 3-8
£428.00 per course of 2
£258.00 One to One
(Plus Travel @ 45p/mile)

Scheduled Courses
@ Ours
£129.00 per delegate

1 to 1 Courses
@ Ours
£258.00 per delegate

InIT Learning
Harben House Business Centre
Tickford Street
Newport Pagnell
MK16 9EY

01908 92 50 58

0330 32 100 58