TRAINER: DCM Learning
DATE: Monday July 30th 2018
TIME: 9am – 4.30pm
VENUE: The Mill Enterprise, New Road Link, Greenhills, Drogheda, Co. Louth
COST: Non-Members €120/Members €96
PARKING: FREE Car Parking On Site
Overview
SUITABLE FOR
Anyone with a basic knowledge of Excel who has a laptop available to bring to the training course

COURSE 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

Full Listing of Training Options | M1 Skillnet 72
COURSE CONTENT:
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 Subtotal
• Summary Report Outlining

TOPIC 4: DATA ANALYSIS
• Analysing Data with Pivot Tables
• Creating & Modifying a Pivot Table
• Changing Pivot, Table Summary and Functions

TOPIC 5: PROBLEM SOLVING
• Goal Seek
• The Scenario Manager
• Scenario Summaries
• IF Functions and Nested Ifs

Overview
TRAINER PROFILE
Founded in Dublin, DCM Learning is fast becoming recognised as a leading training organisation. The organisation works closely with industry to define the skills and qualifications required to thrive. Our courses are taught by expert practitioners.

TO REGISTER FOR THIS EVENT
To register for this Event email M1skillnet@droghedachamber.com and we can invoice you and you may pay by card or eft alternatively go to this link on Eventbrite
https://www.eventbrite.ie/e/microsoft-excel-intermediate-course-tickets-47305813963

Comments are closed.