Microsoft Excel
Foundation Training
Microsoft Excel is an extremely handy tool, whether you’re completing admin, financial or sales tasks. But without the right training, your team won’t be using Excel effectively.
From £199 per person
Discounts for groups of 6+
Discounts for groups of 6+
Onsite
Live online
1 Day
We offer a wide range of Microsoft Excel training courses to suit all skill levels, from introductory to advanced and specialist topics. Our courses are available online and on-demand, with options for group training. Whether you’re part of a small team or a larger group, our flexible onsite and live online sessions can accommodate anywhere from 2 to 20 participants.
What you will learn
Excel Table Mastery: Build and format tables, apply essential functions like AutoSum, AVERAGE, and MAX, and speed up tasks with AutoFill.
Data Management & Navigation: Effortlessly manage rows, columns, and sheets, sort and filter data, and freeze headings for smooth navigation.
Charting & Reporting: Create impactful reports, design stunning charts, and prepare your data for professional printing with custom page layouts.
Formula Precision: Master relative and absolute references, and lock formulas with the $ sign for flawless, accurate calculations.
7 lessons covers:
Creating Tables and Inserting Functions
Learn to create an Excel table from scratch, wrap text in cells, format content, speed up data entry with AutoFill, sort columns, and insert functions. This module covers using AutoSum and statistical functions like AVERAGE, MAX, and MIN.
Managing Rows and Columns, and Writing Formulas
Understand how to insert and delete table rows and columns, adjust column widths and row heights, and hide or unhide rows and columns. Participants will also learn the basics of writing formulas, using mathematical symbols, and troubleshooting calculation errors.
Managing Sheets, Content Formatting, Sorting and Filtering
Gain skills in inserting, renaming, moving, and deleting sheets, as well as copying sheets and tables to other files. This section includes applying content formatting, using the Format Painter, sorting and filtering tables, and using Freeze Panes to lock headings.
Using Filters to Extract Table Information
Discover how to use filters to extract specific information from tables, making data analysis more efficient and targeted.
Table Reports, Charts, and Printing
Learn to use the Table tool to run reports, include totals, and create Pie and Column charts. Participants will explore chart titles, labels, formats, and types, along with previewing and printing tables and charts.
Modifying Page Orientation and Margins
Understand how to modify page orientation and adjust margins for optimal printing of tables and charts, ensuring a professional presentation of data.
Relative and Absolute References
Delve into the difference between relative and absolute formulas, including how to use the $ sign to lock formulas to specific cells when copying.
