SAVE – Special Offers – Click Here...
Latest News

Hot Course - 2 Day Advanced Microsoft Excel Course Training in Belfast Northern Ireland OR On your Own Premises - CALL NOW TO BOOK

17 December 2018

Our 2 day Microsoft Excel Intermediate / Advanced course is suitable for those with a sound working knowledge of Excel 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.

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, Modify
  • Include Hidden Rows, Columns, Filter Settings

Report Manager

  • Create, Modify,
  • Add Sections
  • Specify Page Numbering

Discounts on Public Courses

  • held at Mullan Training suites ?€? opposite Europa hotel
  • full price for 1st delegate
  • 10% reduction 2nd delegate
  • 20% for 3rd and subsequent delegates
Latest News