Excel - Adv (2 Day) 2010/2013/365
Enquire About This Course
We are currently delivering Online & Classroom Excel training - Classroom Based Training is delivered at our Belfast City Centre Premises in Amelia Street (based just opposite the Europa Hotel):
Our 2 day Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Microsoft Excel 2010, Microsoft Excel 2013 and Microsoft Excel 365 and who wish to progress to the most complicated functions and features.

Prerequisites
A working knowledge of Excel or our Introduction to MS Excel course.
Benefits
- At the end of this course you will have a complete understanding of the higher functions of Excel.
- You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.
- You will then be qualified to progress to our Excel VBA course.
- As well as covering additional topics, attending the 2 day course (as opposed to the 1 day) provides delegates with the opportunity to work their way through more examples & benefit from the extra time to absorb information
Course Content
Advanced Functions
- IF Function & Nested IF Statements
- And & Or Functions
- Lookup Functions (Horizontal And Vertical Lookup)
- Index Function
- Array Function
- Subtotals
- Conditional Formatting
3D Ranges
- Create & Maintain (Within Worksheets In a Single File & Between External Files)
- Consolidate Data (via 3D Ranges & Using The Consolidate Tool)
Pivot Tables
- Create Pivot Table
- Work With Row/ Column Fields
- Data Fields
- Customise Table Display
Organising Workbooks
- Create Templates
- Styles
- Protect Ranges & Worksheets

Data
- Enter & Records Using The Input Form
- Sort Data Into Lists
- Filter Data - Autofilter, Advanced Filter
- DataBase Functions
- Validation Rules
Goal Seeking
- Solver
- Goal Seeking With Charts
- What-If
Scenarios
- Create Scenarios
- Create Summary Report
- Merge Scenarios
- Protect Scenarios
Macros
- Create Macros ?€? Record & Modify the VBA Code Generated
- Relative Referencing
- Assign To Toolbars/ Keyboard
- Make Available To All New Documents/ Current Document Only

Outlines
- Group Row/ Column Data To Create Outline Levels Based On Worksheet Formulae
- Display Summary Rows And Summary Styles
Custom Views
- Create and Modify
- Include Hidden Rows, Columns, Filter Settings
Click here to download our Course Outline:
Excel Advanced_2 Day
Unsure what course level suits you best? Please complete our Pre-Course Questionnaire, return to us and we will contact you with our recommendations as soon as we have reviewed:
ExcelPreCourseQuestionnaire_17
Enquire About This Course