Learn the 20% of Excel that delivers 80% of the value in today's workplace. Build practical Microsoft Excel skills and learn how to work smarter, faster and more confidently with spreadsheets in this hands-on Excel masterclass. Designed to focus on the Excel skills that deliver, this practical course will help you save time, reduce errors and improve productivity. You'll discover how to use formulas and functions to automate calculations, analyse information and improve accuracy, helping you achieve more with less effort. Perfect for office workers, small business owners, job seekers and anyone looking to strengthen their digital skills, this hands on course focuses on the Excel skills that make a real difference in work, business and everyday life. By the end of the session, you'll be equipped with practical techniques that boost productivity.

DELIVERY MODE

Face to face

COURSE RESOURCES

• Experience using a computer, including opening, editing and saving files to folders and downloading, uploading and locating files, plus basic keyboard and mouse skills.
• Your own Windows laptop (please advise if you use a Mac) with the Microsoft Excel desktop application installed, signed in to your Microsoft account
• This course is proprietary intellectual property developed by Trainers Direct. Participants receive a PDF reference guide to support their learning after the workshop.

COURSE OUTLINE

Get started with Excel

• Create and work confidently with new Excel workbooks and worksheets
• Enter, edit and format numbers, dates and text professionally
• Use keyboard and mouse shortcuts to work faster and more efficiently
• Apply practical formatting techniques to improve the appearance and readability of spreadsheets

Use formulas and functions

• Create formulas to perform calculations
• Use essential functions including SUM, AVERAGE, MIN, MAX and COUNT
• Work with AutoSum and AutoFill to save time and reduce repetitive tasks
• Edit and troubleshoot formulas
• Understand the difference between relative and absolute cell references

Analyse data

• Organise and manage data using Excel Tables
• Keep key rows and columns visible using Freeze Panes
• Sort, filter and search data to quickly find the information you need
• Summarise data using subtotals
• Get an introduction to Pivot Tables and how they can be used to create powerful summary reports

Configure page setup options

• Prepare spreadsheets for printing
• Use Print Preview to check and refine worksheet layouts
• Add professional headers, footers and page numbering
• Adjust page orientation, scaling and sizing for better presentation
• Control printed output using page breaks and page setup options

LEARNING OUTCOMES

By the end of this course, students should be able to:

• Create and format professional spreadsheets with confidence, using time-saving shortcuts.
• Use formulas and essential functions to perform calculations and analyse information.
• Organise, sort, filter and summarise data, and prepare spreadsheets for printing and sharing.