€54.60 – €130.20

MS Office Excel Intermediate

Event Information

Share this event

Date and Time

Location

Location

The Mill Enterprise Centre

New Road Link

Greenhills

Drogheda

Ireland

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Programme Overview

This course is designed for learners who have used Excel before and want to expand their knowledge, improving formatting, organising data, highlighting key information and creating formulas/links between sheets. The course will introduce new concepts for sorting data, and building conditional formulae. If you think you know Excel, this course will show you what you've been missing. Learners will leave feeling a new confidence in their Excel expertise and ready to take on new challenges with data. During the training session, each learner will work through exercises and practice using the various Excel features covered during the course.

Learning Outcomes

By the end of the session you will be able to:

• Quickly summarise multiple sheets of data into one

• Turn long lists and reports into easy to read tables

• Formulas to check whether cells pass or fail your rules

• Create links between cells so that they all update automatically

• Highlight targets, trends, duplicates and errors with Conditional Formatting

• Formatting and layout consistency by saving as a Template

Who is the course for

Anyone with a basic knowledge of Excel who has a laptop available to bring to the training course

Modules

Module 1: WORKING WITH LARGE SHEETS

Hiding Rows and Columns

Worksheet Panes

Grouping and Ungrouping

Naming Ranges

Module 2: WORKING WITH DATA LISTS

Sorting Lists

Forms in Excel

Filtering Lists

Custom Filters

Setting up lists

Module 3: REPORTING

Summary Reports - Sub Totaling Data

Multiple Subtotals & Removing Subtotal

Summary Report Outlining

Module 4: DATA ANALYSIS

Analysing Data with Pivot Tables

Creating & Modifying a Pivot Table

Changing Pivot, Table Summary and Functions

Module 5: PROBLEM SOLVING

Goal Seek

The Scenario Manager

Scenario Summaries

IF Functions and Nested Ifs

Trainer Profile

Padraig 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

New Road Link

Greenhills

Drogheda

Ireland

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved