This engaging online course, delivered over three sessions, is perfect for those who have mastered the basics of Excel and are keen to advance their skills. You will learn to present, manipulate, and analyse data more effectively, enhancing your workplace efficiency and productivity. You will also develop valuable analytical and reporting techniques that will benefit you personally, as well as current and future employers.
Course Dates:
- Session 1 - Thursday 14th August, 10am-12pm (GMT)
- Session 2 - Tuesday 19th August , 10am-12pm (GMT)
- Session 3 - Thursday 21st August, 10am-12pm (GMT)
Course Structure:
Format: Online using MS Teams, trainer-led
Duration: 3 sessions each lasting 2 hours (total of 6 hours). A 30 minute Excel Q&A on course content will also be offered immediately after each session finishes.
August offer: £125 per delegate (Standard price £250)
Course Overview*:
A.Formatting and Selection Techniques:
- Home menu formatting
- Conditional formatting
- Format painter and merge tools
- Number formatting
- Time Saving Shortcuts
B.Data Management:
- Cell referencing (Relative, Absolute, Mixed)
- Sorting and filtering data
- Flashfill
- Text concatenation
C.Working with Functions & Formulas:
- SUM, AVERAGE, MIN, MAX
- COUNT, COUNTA
- SUMIFS, COUNTIFS
- IF and IFS
- DATE and TIME functions
D.Also:
- Introduction to pivot tables
- Charts and data visualisation
- Page setup and printing
- Productivity tricks and shortcuts
*Content may vary depending on specific group level
Prerequisites:
- A computer with Microsoft Excel installed and a stable internet connection for live online sessions.
- Computer literacy: Learners should be comfortable with general computer operations. This includes navigating the operating system, launching applications, opening and saving files from emails and using Microsoft Teams.
In Excel, learners should understand the following:
- Creating and saving workbooks, and navigating worksheets
- Basic Data Entry Skills: Learners must be comfortable at entering, editing, and deleting data within worksheets. This includes knowledge of cell selection, copying, pasting, cutting, and using undo/redo features.
- Formatting Basics: Participants should be able to apply basic formatting to cells, columns, and rows. This encompasses changing font styles, sizes, and colours; adjusting cell alignment; applying borders and shading;
- Basic Formula Knowledge: Users should understand how to create and edit simple maths calculations in Excel. Familiarity with basic functions such as SUM is beneficial but not essential.
