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.
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.,
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
DCM have designed this course to be in line with the Microsoft Certified Professional courses and, trainers are Microsoft Certified Instructors.