MS Excel Intermediate – New date added

Start date: 10 June 2021

Duration: One Day (09:00 - 3:30)

Location: ONLINE

Cost: Member €55 | Non-Member €65

Course code: ITExcelL2

Programme overview

Third Date added due to demand, Book early to secure your place.

If you think you know Excel, this course will show you what you've been missing.

Excel is the most in commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light

During the very practical and interactive session, each learner will work through exercises and practice using the various Excel features covered during the course.

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 26th April 2021