Microsoft Excel
Foundation Training
Microsoft Excel is essential for admin, finance, and sales tasks. This foundation-level training helps beginners build the core skills needed to work confidently and accurately with spreadsheets.
From £150 per person
Discounts for groups of 6+
Discounts for groups of 6+
From £150
Per person
Onsite
Live online
1 Day
Target Audience
Ideal for professionals who use Excel for data entry, reporting, or analysis across roles in admin, finance, sales, and operations. Suitable for teams ready to build on basic Excel skills.
Prerequisites
No prior Excel experience required.
Learn from Alan Gilbert , one of our leading Excel trainers, whose hands-on approach ensures participants leave with real-world skills and confidence.
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.
