Microsoft Excel Training Courses

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, and 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.

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.

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.

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.

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.

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.

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 modeling: installing Power Pivot, creating data models, performing advanced analysis, and presenting insights through reports.