Mullan Technology
Home Links Contact Us
About Us Tech Used Samples Support Training
Mullan Technology


News
 
1 day Adv Microsoft Excel CourseTraining in Belfast Northern Ireland OR On your Own Premises - Places Available - Call Now to Book !

18 February 2014
 

Our 1  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 & Select 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, Delete

§          Include Hidden Rows, Columns, Filter Settings

 

 

Report Manager

§          Create, Modify, Delete

§          Create Sections (Sheet, View1, Scenario)

§          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

 
 
Related Links

www.mullantraining.com/courseoutlines/viewdetails.asp?CatID=6&SubCatID=15&CourseID=24