MS Excel Advanced

Start date: 22 June 2021

Duration: 1 Day

Location: ONLINE

Cost: Member €60 | Non-Member €80

Course code: ITExcelL3

Programme overview

In line with Government guidelines, this session will be delivered online.

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

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.,

Modules

TOPIC 1: WORKING WITH LARGE SHEETS

Hiding Rows and Columns  |  Worksheet Panes  |  Grouping and Ungrouping  |  Naming Ranges

TOPIC 2: WORKING WITH DATA LISTS

Sorting Lists  |  Forms in Excel  |  Filtering Lists  |  Custom Filters  |  Setting up lists

TOPIC 3: REPORTING

Summary Reports – Sub Totaling Data  |  Multiple Subtotals & Removing Subtotals  |  Summary Report Outlining

TOPIC 4: DATA ANALYSIS

Analysing Data with PivotTables  |  Creating & Modifying a PivotTable  |  Changing a PivotTable Summary  |  Functions

TOPIC 5: PROBLEM SOLVING

Goal Seek  |  The Scenario Manager  |  Scenario Summaries  |  IF Functions  |  Nested IFs

Trainer Profile

DCM  have designed this course to be in line with the Microsoft Certified Professional courses and, trainers are Microsoft Certified Instructors.

Applications Closing on 09th June 2021