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.
6 lessons covers:
Nesting Formulas and Conditional Formatting
Learn to nest multiple formulas, using AND and OR functions within IF statements. This module includes applying Conditional Formatting to format table rows based on criteria and dates using the TODAY function.
Advanced Pivot Tables
Explore advanced Pivot Table reporting tools, including grouping numeric and date fields, running percentage analyses, and writing field calculations. Learn how to create Pivot Tables from multiple tables.
Array Formulas and LOOKUP Functions
Discover the advantages of array formulas for formula protection, and use LOOKUP functions like INDEX and MATCH for versatile data retrieval. Participants will also learn to write SUMIFS, AVERAGEIFS, and COUNTIFS for calculations based on multiple criteria.
What-If Analysis and Macros
Utilise Goal Seek and Scenario Manager for forecasting reports. This module covers macro security, recording, running, and editing macros, as well as managing the Personal Workbook and an introduction to VBA code editing.
Customising the Quick Access Toolbar and Ribbon
Learn to add macro buttons to the Quick Access Toolbar (QAT) and customise the Ribbon by adding groups and buttons to enhance your Excel experience.
Text Functions and Data Integration
Gain proficiency in text functions such as CONCATENATE, UPPER, LOWER, and PROPER, along with MID, LEFT, RIGHT, REPT, and FIND. Learn to integrate various Excel features effectively for streamlined workflows and improved data management.
