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
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
Find out how to further utilise nested formulas to extract data base on multiple criteria.
Get results to complex questions.
Further user’s knowledge of Pivot Tables by incorporating groupings and calculations.
Use what-if analyses to meet targets and generate forecasts.
Learn how to quickly automate repetitive or tedious tasks by using macros.
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.
