€104.28 – €130.20

MS Excel Advanced Training Course

Event Information

Share this event

Date and Time

Location

Location

The Mill Enterprise Centre

Drogheda

Ireland

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Programme Overview

This advanced course is aimed at learners who have a good grounding in Excel either from experience or from attending our Intermediate Microsoft Excel training course. If your job involves manipulating and analysing data in Excel, you will find this course very useful.

This advanced course focuses on the vast array of functionality of Microsoft Excel and will allow learners to enhance their skills. The course also goes into detail on how to normalise data and analyse it with Pivot Tables.

Learning Outcomes

  • Import data into Excel, prepare it and set up pivot tables to analyse it

  • Record macros and create icons on the toolbars to run them

  • Understand how to locate errors in formulas and evaluate them

  • Use analysis tools to forecast figures based on a range of scenarios

  • Ensure important data is highlighted by summarising large workbooks and sorting data into key element

Who is the course for

This advanced course is aimed at learners who have a good grounding in Excel either from experience or attending our Intermediate Microsoft Excel training course. If their job involves manipulating and analysing data in Excel, they will find this course very useful. They will also find it helpful if they spend most of their working day using Excel and would like to fill in gaps in their knowledge.

Modules

Module 1: WORKING WITH MULTIPLE SHEETS

Opening a Second Workbook

Worksheet Linking; Update Links

Linking Calculations and Using Paste Special

Object Linking and Embedding

Module 2: ADVANCED FUNCTIONS

Data Tables and Goal Seeker

Solver;

IF, Nested IF;

LOOKUP; HLOOKUP; VLOOKUP

Text Functions; Date & Time Functions

Module 3: ADVANCED FILTERS

Data Consolidation;

Pivot tables and charts

Module 4: MACROS

Simple Macro editing with Visual Basic

Creating and Running Macros and Assigning Macros to a toolbar

Module 5: WORKING WITH SCENARIOS

Creating and viewing scenarios

  • Creating and editing templates

Trainer ProfilePadraig from DCM Learning is a highly experienced, knowledgeable, and highly accomplished training and coaching Professional. Padraig's training delivery approach is highly engaging and structured yet dynamic; affording the participant an opportunity to learn at every possible juncture that accumulates into a top-class learning experience.Padraig's areas of expertise include MS Excel at Introductory, Intermediate and Advanced, MS PowerPoint and Excel Financial

Share with friends

Date and Time

Location

The Mill Enterprise Centre

Drogheda

Ireland

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved