Discover how to work smarter with Excel in our Intermediate course. From connecting spreadsheets and using advanced lookup features to mastering conditional functions and templates, this course equips you with practical tools to manage and analyse data effectively.
1e575a78-94c7-48e5-9f60-5eb46f98497e
Intermediate Excel
Select your learning method:
Quote request
Please complete the form to ensure your quote is accurate and we will contact you soon.
Learn essential skills
Course overview
Advance your Excel proficiency
This one-day classroom course focuses on intermediate Excel skills, including data analysis and management tools. Develop your knowledge and understanding of this vital analytics platform tool to make the most of your data insights.
Learning objectives
- Understand and be able to use the Excel IF function
- Apply conditional formatting to highlight certain data
- Use Lookup functions for range and exact matches
- Use the Quick Analysis tools and sparklines
- Apply filters and sort larger data sets
- Work with tables and understand how useful they can be
What you'll learn
Take your Microsoft Excel skills to the next level with this Intermediate course and unlock the full potential of your data. Suitable for those with knowledge of the Excel basics, learning these functions will elevate your efficiency at producing insights.
Connecting spreadsheets together
Learn formulas that link worksheets and workbooks together to simplify and streamline data storage.
Conditional functions
Master using the IF function and adding conditional formatting to highlight certain data.
Templating and security
Learn how to create templates for commonly used worksheets and protect data using the security features.
Tables and Lookups
Understand the functionality of data tables and use Excel lookup features to automate worksheets.
Data visualisation
Create, build and customise graphs including plotting trend lines. Learn how to use the sparklines features and data bar enhancements.
What's included
One day of instructor-led training in a classroom setting
FAQs
Build on your existing knowledge of Microsoft Excel with this intermediary course. Become more confident using spreadsheet functions to arrange, analyse and visualise your data.
What is Microsoft Excel?
Microsoft Excel is a spreadsheet software used for organising, analysing, and visualising data. It supports tasks such as calculations, data management, and creating charts, making it essential for businesses and personal use.
What career paths is knowledge of Excel helpful for?
Excel is valuable for careers in data analysis, finance, accounting, project management, marketing, and operations, as it aids in handling data, generating reports, and performing calculations across various industries.
Do I need prior Excel knowledge?
Yes, basic Excel proficiency is necessary to benefit from this course.
How is the course delivered?
The course is delivered as a one-day, face-to-face classroom session.
What our customers say
"Great experience with the trainer and the ILX group. The course was insightful and delivered by a great teacher; his ability to put real world scenarios to every point really allows the course to be understood in detail."
Samuel Bryant, ILX learner
"Super fast help that relieved any worry!"
Kim Kerr, ILX learner
Why study with ILX
500,000+
learners
learners
Join the half a million learners developing their skills with our training
5,000+ businesses
A trusted partner to thousands of organisations worldwide
96% customer satisfaction
Our passionate team goes above and beyond to support customer needs
Similar courses
Desktop IT
Advanced Excel
Communication
Building and Managing Stakeholder Relationships
Communication
Difficult Conversations - Made Easy
Communication
Mastering Communication Skills
Communication
Win-win Negotiations