- All Courses
- Microsoft Office
- Microsoft Excel
Microsoft Excel Training Courses
Excel courses are designed to take beginners to an advanced level. You will learn formulas, charts, pivot tables, macros, VBA, data analysis and etc.
Microsoft Excel Introduction Course
Begin with the basics of Microsoft Excel by creating spreadsheets and workbooks to organise, calculate, analyse, revise, update, and present data.
- Navigate Excel: using commands efficiently.
- Use formulas and functions: to perform calculations swiftly and minimise work with reusable formulas.
- Modify worksheets: by adjusting cells, formatting data, and utilising proofing tools, as well as formatting worksheets professionally.
Microsoft Excel Intermediate Course
Build on from the basics of Microsoft Excel by creating advanced workbooks and worksheets to organise, analyse and filter data using formulas, tables and slicers.
- Master working with named ranges: use logical, date, and time functions for efficient data handling.
- Analyse data comprehensively: by creating and modifying tables and applying conditional formatting.
- Visualise data dynamically: with charts, and utilise PivotTables and PivotCharts for in-depth data analysis and presentation.
Microsoft Excel Advanced Course
Master and make the most of Excel by automating repetitive tasks and creating complex formulas with conditional logic to process large data sets efficiently.
- Utilise: links, external references, and data consolidation across multiple worksheets and workbooks.
- Automate workbook functionality: with data validation, error detection, and macro implementation.
- Enhance analysis capabilities: with lookup functions and dynamic arrays and create dynamic visualisations with sparklines and map data.
Microsoft Excel VBA Introduction Course
Master the programming language VBA to go beyond advanced Excel use by recording and running Macros, creating Modules, and writing Procedures.
- Acquire foundational skills in Visual Basic for Applications (VBA): including displaying the Developer tab, recording and running macros, understanding the development environment, and managing macro security.
- Master procedures, functions, and objects: by understanding modules, creating procedures, navigating the Excel object hierarchy, working with collections, properties, methods, and event procedures.
- Develop proficiency in VBA programming: through naming procedures, calling procedures, using the Immediate window, and working with the code editor effectively.
Microsoft Excel VBA Pro Course
Master the programming language VBA to go beyond advanced Excel use by writing Macros, using control structures, developing user forms, and debugging code errors.
- Master Visual Basic for Applications (VBA) fundamentals: including displaying the Developer tab, recording and editing macros, understanding the development environment, and managing macro security.
- Learn to work with procedures, functions, and objects: creating modules, procedures, and functions, navigating the Excel object hierarchy, working with expressions, variables, intrinsic functions, and controlling program execution.
- Develop proficiency in form and control management: understanding UserForms, working with controls, setting properties, populating controls, adding code, and working with PivotTable objects.
Data Analysis and Visualisation with Microsoft Excel Introduction Course
Start by learning the basics of Data Analysis with Excel, such as formulas, functions, and PivotTables. Then, explore how to effectively convey data insights through visual aids.
- Gain a foundational understanding of data analysis: covering introduction to data science, creating and modifying tables, sorting and filtering data.
- Learn to visualise data effectively in Excel: including creating and modifying charts, formatting charts, and applying best practices in chart design.
- Master data analysis techniques using formulas and functions: analysing data with formulas and named ranges, using functions, implementing data validation, forms, and controls, and creating conditional visualisations with lookup functions.
Data Analysis and Visualisation with Microsoft Excel Pro Course
Go from beginner to expert in Data Analysis and Visualisation with Excel to organise and manipulate large data sets and create visualisations and reports of insights and trends.
- Develop comprehensive data analysis skills: covering data science fundamentals, table manipulation, sorting/filtering, chart visualisation, and best practices in design.
- Master advanced Excel functionalities: including pivot tables for data analysis, creating dashboards, geospatial visualisations, statistical analysis tools, and data transformation techniques.
- Learn Power Pivot for advanced data modelling: installing Power Pivot, creating data models, performing advanced analysis, and presenting insights through reports.
Microsoft Excel One-to-One Bespoke Course
Learn Excel at your own pace with our One-to-One Excel course. Choose which level course you want to learn from Introduction to Advanced.
- Customise your Excel learning experience: from Introduction to Advanced levels, covering all aspects and differences across versions.
- Gain comprehensive Excel skills: tailored to your chosen level, with certification options available upon completion.
- Select from a range of course objectives and content: ensuring a personalised and intensive training experience suited to individual learning needs.
Don’t know which level you need?
Enquire Now for a free Microsoft Excel AssessmentWhat is Microsoft Excel?
Microsoft Excel is a leading spreadsheet application developed by Microsoft for Windows and Mac OS. Excel is used for storing, organising and manipulating data, and offers programming support via Microsoft Visual Basic for Applications (VBA).
Study Microsoft Excel with Infero Training
Our Microsoft Excel training programs are designed to help people learn how to manage and analyse data effectively. We cover everything from basic functions to advanced features like dynamic arrays, Power Query for bringing in data smoothly, and AI-powered Insights for smarter analysis. Our courses work on both Windows and Mac computers.
Whether you’re just starting out or already know your way around Excel, our CPD Accredited courses have something for everyone. We’ll teach you how to do calculations, create charts, use pivot tables, write macros, and even program in VBA. Each level—Introduction, Intermediate, and Advanced—lasts a day and gives you plenty of hands-on practice.
If you want to dive even deeper, we offer extra courses like Advanced, Visual Basic (with Intro or Pro options), PowerPivot, Pivot Tables, Dashboards, and transitioning from older versions of Excel. We’re also flexible and can create custom, bespoke courses, tailored to your specific needs.
Our training methodology emphasises hands-on learning, combining trainer demonstrations with interactive exercises to reinforce skills acquisition. All course participants receive a certificate upon completion. No matter which version of Excel you’re using—365, 2024, 2021, 2019, 2016, 2013, 2010, or 2007—our courses cover all everything you need. Let Excel do the work for you!
Excel Certification
On completion of any of our Excel courses: Introduction, Intermediate, Advanced or VBA (3 days), you can receive CPD Certificate and points.
In addition, our training and materials are designed so that you can take a Microsoft Certification exam to earn a Microsoft Office Specialist (MOS) certification and become MOS Associate and/or MOS Expert.
The certification is a proof of your expertise and proficiency to work with Microsoft Excel.
Benefits of learning Microsoft Excel with us
- Professional Certified Trainers
- CPD Accredited training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- 100% Money Back Guarantee & Price Match Guarantee
- High Feedback Rate
- Choice of 15 training locations, Virtually or Onsite
- Bespoke Courses & Group Discounts from £89 per person
Testimonials
Top Microsoft Excel FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm