Microsoft Excel Intermediate
From: £285.00 Plus VAT (per person)
Have more than 2 delegates? Talk to us about our closed group courses.
Delivery Method
Open Public Courses – Virtual Delivery Only Closed Group Courses – Face To Face and Virtual Delivery
Business Benefit
By completing this course, participants will gain the skills and knowledge necessary to efficiently work with complex data scenarios and optimise their use of Excel for various professional tasks.
On completion of this course you may be interested in our Excel Consultancy services
Who Should Attend
This course is designed for individuals who:
Want to display data dynamically in Excel worksheets based on specific conditions or criteria.
Seek to visually understand and follow the logical flow of formulas within worksheets, including addressing circular references.
Are responsible for managing and maintaining lists containing a moderate number of items, such as company assets, personnel records, product inventories, or invoices, often numbering up to a few thousand rows.
Learning Outcomes
Efficiently Query Spreadsheet Data: Learn how to retrieve specific values within a spreadsheet using various techniques and functions.
Advanced Data Analysis: Gain expertise in analysing data by employing advanced formulas and functions to extract valuable insights.
Data Management Mastery: Develop the skills to effectively manage and manipulate large volumes of data, making it more organised and accessible.
Pivot Table and Chart Proficiency: Learn to create, customise and manage pivot tables and charts to visualise data and uncover trends and patterns.
Course Content
The IF Function: Learn how to use the IF function to perform conditional calculations in Excel, allowing you to make decisions based on specified criteria.
Nested IF: Dive deeper into conditional logic by mastering nested IF statements, which enable you to create more complex decision trees.
The Lookup Function: Explore the Lookup functions (such as VLOOKUP and HLOOKUP) to search for and retrieve specific data from tables or ranges.
Date and Time Functions: Learn how to work with date and time functions in Excel to perform various date-related calculations and operations.
Advanced Filters: Explore techniques to efficiently filters lists and databases within Excel.
Subtotals & Outlines: Learn how to create subtotals and outlines to summarize and structure data within large datasets.
Database Statistical Functions: Discover statistical functions to analyse and interpret data, including functions like DAVERAGE, DCOUNT, and DSUM.
Data Validation: Use this powerful tool to validate user input within Excel to minimise user error.
Conditional Formatting: Use conditional formatting to create formulas to control cell formatting.
Pivot Tables & Pivot Charts: Delve into pivot tables and pivot charts to efficiently summarise, analyse, and visualise large datasets.
How to Book
Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking by Credit Card or via Invoice. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.
The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!
Post-course, to evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. This additional session lasts for 2.5 hours.
During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.
We compile this information into a report so that you have evidence of your return on investment.