BUILD YOUR EXCEL SKILLS
Microsoft Excel Level 1 & 2
Build practical Microsoft Excel skills from beginner to intermediate level. Learn formulas, functions, formatting, data organisation, sorting, filtering, and data analysis through hands-on exercises and downloadable working files.
Microsoft Excel Beginner to Intermediate Course
This online Excel course is designed for learners who want to build practical Microsoft Excel skills for study, work, and everyday professional tasks.
The training starts with Excel fundamentals and gradually introduces more advanced features and techniques suitable for users progressing towards an intermediate level.
You will practise working with formulas, functions, worksheets, tables, formatting, data sorting, filtering and data analysis through practical examples and downloadable Excel files.
Excel is widely used across finance, accounting, business, IT, healthcare and many other professional environments, making strong spreadsheet skills useful across a wide range of careers.
You Will Build Skills In
Excel fundamentals
Formulas and functions
Data organisation
Formatting and tables
Sorting and filtering
Data analysis and extraction
Data checks and criteria-based calculations
WHAT'S INCLUDED in MS Excel Level 1 & 2 Course
Everything You Need to Practise in MS Excel Level 1 & 2 Course
Your MS Excel Level 1 & 2 course package gives you complete access to all the resources, support, and tools you need to study effectively.
Detailed Tutor Explanations
Every topic in MS Excel Level 1& 2 is explained step by step by the tutor
Practical Exercises & Case Studies
Apply your learning in MS Excel Level 1 & 2 through hands-on exercises
One Year Access
Study at your own pace with 12 months of full access
Downloadable Excel Working Files
Available Downloadable Excel files to practise
Certificate of Completion
Earn a certificate when you finish the MS Excel Level 1 & 2 Course
Understand the Microsoft Excel Level 1 & 2 Syllabus
Your complete course covers Excel from first principles through to intermediate data skills — from writing formulas and formatting sheets through to lookups, dynamic data ranges and conditional analysis — with hands-on exercises and downloadable working files for every topic.
Excel fundamentals
Getting comfortable with the basics: opening and saving files, using templates, working with sheets and tabs, and navigating the interface.
Formatting
Making spreadsheets clear and professional through cell and sheet formatting, format painter, useful formatting tricks, and page layout for printing.
Formulas and functions
Writing formulas, using cell references, understanding how formulas work, and applying key functions used in everyday work.
Sorting and filtering data
Organising data by sorting and filtering, reordering columns, freezing panes, and finding and selecting specific information.
Data analysis and transformation
Analysing tables quickly, creating data series, splitting text into columns, transforming tables, listing unique data, and pulling data from other tables (lookups).
Data integrity and criteria-based calculations
Running dummy checks on inputs, ensuring Excel recognises new data, and summing or counting data based on set criteria.
MS Excel Level 1 & 2 Course Content
A Structured path through the MS Excel Level 1 & 2 Syllabus
Your tutor
Learn from a tutor who has taught thousands of students.
Liliya (FCCA) is a qualified accounting and finance professional who has spent over a decade using Excel daily in real finance roles — from audit and financial advisory at a Big Four firm to senior management as CFO of a multinational organisation, where she relied on Excel to analyse data, build reports and support decision-making. She brings that hands-on, real-world experience into every lesson, teaching Excel the way finance professionals actually use it.
Student reviews
What students say about their experience with Vertex
MS Excel Level 1 & 2 FAQs
Frequently Asked Questions for MS Excel Level 1 & 2
Do I need any prior Excel experience to take this course?
No. The course is designed for complete beginners and starts with the very basics — opening and saving files, working with sheets, and writing your first formulas — before building up to intermediate-level skills.
What's the difference between Level 1 and Level 2?
Level 1 covers the fundamentals: formulas, cell references, formatting, printing, sorting and filtering. Level 2 builds on this with faster workflows, lookups, dynamic data ranges, transforming tables, and criteria-based functions like SUMIF and COUNTIF — the skills used daily in finance and accounting roles.
How long do I get access to the course?
You get one year of full access, so you can study at your own pace and revisit lessons as needed
Is this course useful outside of finance and accounting?
Yes. Excel skills are valuable across almost every industry, including IT, healthcare, and business intelligence, wherever data needs to be organised, analysed, and presented clearly.
Does the course include practice exercises?
Yes. Every topic comes with downloadable Excel working files and hands-on exercises, so you apply each formula and function as you learn it rather than just watching.
Do I get a certificate after finishing the course?
Yes, you earn a Certificate of Completion once you finish all the Level 1 and Level 2 lessons.
Start Learning Microsoft Excel Today
Build Practical Excel Skills for Work and Study
Learn Microsoft Excel step by step, practise with working files, and build the confidence to use Excel more effectively.