Course overview.

Learn to create and format worksheets, perform basic calculations, and manage data efficiently. By the end of this course, you will have a solid foundation in using Microsoft Excel 365 for tasks such as budgeting, data tracking, and basic data analysis.

Upon completion, you will be able to:

Who it's for.

This course is perfect for individuals who are new to Microsoft Excel 365 or have limited experience with it. It's ideal for students, professionals, and anyone looking to enhance their proficiency in spreadsheet management and basic data analysis. If you are eager to explore the world of data manipulation and visualisation, this course is your ideal starting point.

Our Excel courses.

Our Microsoft Excel training is designed to support you at every stage of your learning journey. Whether you're completely new to Excel, already use it regularly and want to improve your skills, or you're looking to master advanced data analysis and reporting, we offer courses to suit your level.

Our Excel Beginner course is ideal for anyone who is new to Excel or has limited experience with spreadsheets. You'll learn the fundamentals of creating and formatting worksheets, entering and organising data, using basic formulas and functions, and creating simple charts. It's the perfect starting point for building confidence and developing essential spreadsheet skills.

Microsoft Excel Beginner Course overview.

Build a strong foundation in Microsoft Excel and learn how to use one of the world's most widely used spreadsheet applications with confidence. This beginner-friendly course introduces you to the Excel interface, essential spreadsheet tools and the core skills needed to create, organise and work with data effectively.

You'll work through Excel step by step, learning how to enter and format information, create simple calculations and organise your spreadsheets in a clear and practical way. The course focuses on real-world tasks and useful techniques, helping you develop good spreadsheet habits from the beginning and become more confident using Excel in everyday situations.

Who it's for.

This course is designed for complete beginners who are new to Excel, as well as anyone who has used spreadsheets before but wants to develop a stronger understanding of the software. It's suitable for students, administrators, business professionals, managers and anyone who needs to use Excel as part of their work or studies.

No previous Excel experience is required. Whether you want to improve your workplace skills, manage information more effectively or simply become more comfortable working with spreadsheets, this course provides a clear and practical starting point.

What you'll learn.

You'll learn how to navigate Excel, create and format spreadsheets, enter and organise data, and use essential formulas and functions to perform calculations. You'll also explore basic charts, tables, sorting and filtering tools to help you present and understand information more effectively.

By the end of the course, you'll be able to create clear, well-organised spreadsheets and confidently carry out common Excel tasks. You'll also have a solid foundation to build on as you progress into more advanced formulas, data analysis and professional Excel workflows.

Microsoft Excel Intermediate Course overview.

Build on your existing Excel knowledge and develop the skills needed to work with spreadsheets more efficiently and confidently. This intermediate course takes you beyond the fundamentals, introducing more powerful formulas, data management techniques and tools that can help you analyse information and create more effective, professional spreadsheets.

You'll learn how to combine Excel's features to solve practical problems, organise larger datasets and improve the way you work with information. The course focuses on useful, real-world workflows that can help you save time, reduce repetitive tasks and produce clearer, more reliable results in both professional and personal projects.

Who it's for.

This course is designed for learners who already have a basic understanding of Excel and want to take their spreadsheet skills to the next level. It's ideal for professionals, administrators, managers, students, business users and anyone who regularly works with data and wants to become more efficient with Excel.

A basic familiarity with Excel's interface, formatting and simple formulas is recommended. The course builds on these skills and introduces more advanced techniques without requiring specialist technical or programming knowledge.

What you'll learn.

You'll explore more advanced formulas and functions, including techniques for combining functions to solve more complex calculations. You'll also learn how to manage and analyse larger datasets using tools such as tables, sorting, filtering and conditional formatting.

The course will also introduce practical techniques for presenting and interpreting data, including creating effective charts and working with structured spreadsheets. By the end, you'll be able to work more efficiently with Excel, build more sophisticated spreadsheets and confidently handle a wider range of everyday data and reporting tasks.

Microsoft Excel Advanced Course overview.

Take your Excel skills to an advanced level and learn how to work confidently with complex data, powerful formulas and sophisticated spreadsheet workflows. This course builds on your existing Excel experience and introduces advanced techniques designed to improve productivity, analysis and the quality of your reporting and decision-making.

You'll explore Excel's more powerful features and learn how to combine them to handle larger datasets, automate repetitive tasks and create dynamic, professional spreadsheets. The course focuses on practical applications, helping you develop efficient workflows that can be applied to demanding business, financial and analytical tasks.

Who it's for.

This course is aimed at experienced Excel users who are ready to move beyond intermediate techniques and develop a more advanced level of proficiency. It's ideal for analysts, managers, finance professionals, administrators, business users and anyone who regularly works with complex data or relies on Excel for reporting and analysis.

You should already be confident using Excel's core formulas, functions, formatting and data management tools. The course assumes a solid foundation and focuses on advanced techniques, efficient workflows and solving more complex spreadsheet and data analysis challenges.

What you'll learn.

You'll explore advanced formulas and functions, working with complex calculations, logical functions and techniques for analysing and transforming data. You'll also develop your skills with tools such as PivotTables, advanced filtering, conditional formatting and data analysis features.

You'll learn how to build more dynamic and efficient spreadsheets, improve reporting workflows and reduce repetitive manual tasks. By the end of the course, you'll have the confidence to tackle complex Excel projects, analyse larger datasets and create professional reports and tools that support informed decision-making.

Microsoft Excel for Data Analysts Course overview.

Develop the practical Excel skills needed to work confidently with data, identify trends and patterns, and turn raw information into meaningful insights. This course is designed specifically for data analysis and moves beyond everyday spreadsheet tasks to explore advanced formulas, data preparation, analysis, visualisation and reporting techniques.

You'll learn how to take data from different sources, clean and structure it for analysis, perform calculations and summarise large datasets efficiently. The course focuses on real-world analytical workflows, helping you use Excel to investigate information, answer business questions and communicate findings through clear and professional reports.

Who it's for.

This course is ideal for aspiring and experienced data analysts, business analysts, finance professionals, reporting specialists and anyone who regularly works with business data. It's particularly useful for professionals who need to analyse large datasets, produce management reports or turn raw information into useful business insights.

You should already have a good working knowledge of Microsoft Excel, including basic formulas, formatting, tables and spreadsheet navigation. Previous experience with PivotTables is helpful but not essential, as the course develops these skills alongside more advanced analytical techniques.

What you'll learn.

You'll learn how to clean, organise and prepare data for analysis, including removing duplicates, handling missing information, standardising data and working with different data types. You'll explore Excel tables, sorting, filtering and structured references to create reliable datasets that are easier to analyse and maintain.

You'll develop advanced skills with Excel formulas and functions, including lookup functions, logical functions, conditional calculations, text functions and date and time functions. You'll learn how to combine functions to solve practical analytical problems and create calculations that can be reused across larger datasets.

You'll learn how to use PivotTables and PivotCharts to summarise and analyse large volumes of information quickly. You'll explore grouping, filtering, calculated fields and different ways of presenting results, allowing you to identify trends, comparisons and patterns without manually analysing every row of data.

The course also introduces advanced data visualisation and reporting. You'll learn how to choose appropriate charts, apply conditional formatting and build interactive reports and dashboards that highlight key findings. You'll focus on presenting analytical results in a way that is clear and useful to managers, colleagues and other stakeholders.

You'll also explore Power Query and modern Excel data preparation techniques, learning how to import, combine and transform information from multiple sources. You'll discover how repeatable queries can reduce manual work and make regular reporting processes faster, more consistent and less prone to error.

By the end of the course, you'll be able to confidently clean, analyse and interpret business data using Excel. You'll have the skills to build sophisticated calculations, summarise large datasets, create meaningful visualisations and produce professional reports that turn data into actionable information.

Microsoft Excel for Government Course overview.

Develop the Excel skills needed to manage, analyse and present data effectively within a government or public sector environment. This course focuses on practical spreadsheet techniques for working with operational data, performance information, budgets, statistics and reporting requirements, helping you produce accurate and professional results.

You'll learn how to organise large datasets, perform reliable calculations, analyse information and create clear reports for colleagues, managers and stakeholders. The course places particular emphasis on accuracy, consistency, data quality and repeatable workflows, helping you use Excel confidently when working with important public sector information.

Who it's for.

This course is designed for government and public sector employees who use Excel to manage information, analyse data or produce reports. It's suitable for administrators, policy teams, finance staff, analysts, project teams, operational staff and managers who need to work confidently with spreadsheets and data as part of their role.

The course can be adapted for users with different levels of Excel experience and is particularly useful for professionals who need to improve the accuracy, efficiency and consistency of their spreadsheet work. Basic familiarity with Excel is recommended, although the training can be tailored to suit the needs of individual teams and departments.

What you'll learn.

You'll learn how to structure, clean and manage government and public sector datasets, using tables, sorting, filtering and appropriate formatting to keep information organised and easy to work with. You'll explore techniques for identifying duplicate, missing or inconsistent information and improving overall data quality.

You'll develop practical skills with Excel formulas and functions for calculating totals, percentages, variances, dates and performance measures. You'll also learn how to use lookup and logical functions to combine information from different worksheets and datasets while reducing manual calculations and potential errors.

You'll learn how to use PivotTables, PivotCharts and filtering tools to analyse larger datasets and quickly identify trends, patterns and exceptions. These techniques can be used for areas such as performance monitoring, service statistics, expenditure analysis, staffing information and operational reporting.

The course also covers data visualisation and reporting, helping you create clear charts, summaries and dashboards that communicate important information effectively. You'll learn how to select appropriate visualisations and present figures in a way that makes key findings easier for decision-makers and stakeholders to understand.

You'll also explore techniques for creating consistent and repeatable reporting processes, including reusable templates, structured tables and data preparation workflows. Where appropriate, Power Query can be introduced to help automate repetitive data cleaning and consolidation tasks and reduce manual processing.

By the end of the course, you'll be able to use Excel more effectively for public sector data management, analysis and reporting. You'll have the skills to work with data accurately, produce reliable calculations, identify meaningful trends and create professional reports that support informed decision-making and effective public services.

Microsoft Excel for NHS Course overview.

Develop practical Microsoft Excel skills for working with healthcare, operational and administrative data within an NHS environment. This course focuses on using Excel to organise, analyse and present information accurately, helping staff work more efficiently with performance data, activity figures, workforce information, finance and operational reports.

You'll learn how to structure datasets, perform calculations, identify trends and produce clear reports that can support planning and decision-making. The course places a strong emphasis on accuracy, consistency, data quality and efficient working practices, with techniques that can be applied to a wide range of NHS administrative, clinical-support and operational reporting tasks.

Who it's for.

This course is designed for NHS staff who use Excel as part of their day-to-day role, including administrators, operational teams, managers, finance staff, workforce teams, analysts, project staff and support services. It's particularly useful for anyone who needs to organise information, analyse figures or produce regular reports and summaries.

The course is suitable for users with basic to intermediate Excel experience and can be tailored to different roles and levels of responsibility. It is focused on working with data appropriately and efficiently and does not require previous experience in advanced Excel analysis.

What you'll learn.

You'll learn how to organise, clean and structure healthcare and operational datasets, using tables, sorting, filtering and consistent formatting. You'll explore practical techniques for identifying duplicate, missing or inconsistent information and creating spreadsheets that are easier to maintain, review and update.

You'll develop skills with Excel formulas and functions for calculating totals, percentages, averages, variances and performance measures. You'll also learn how to use lookup and logical functions to combine information from different worksheets and reduce repetitive manual calculations.

You'll learn how to use PivotTables, PivotCharts and advanced filtering to analyse larger datasets efficiently. These techniques can be applied to areas such as activity reporting, workforce information, service performance, waiting-time data, financial information and operational monitoring.

The course also covers data visualisation and reporting, helping you create clear charts, summaries and dashboards that highlight important information. You'll learn how to choose appropriate charts, apply conditional formatting and structure reports so that key figures and trends can be quickly understood by colleagues and decision-makers.

You'll also explore techniques for creating repeatable and efficient reporting workflows, including reusable templates, structured tables and data preparation processes. Where appropriate, Power Query can be introduced to help combine and transform information from multiple sources and reduce repetitive manual tasks.

By the end of the course, you'll be able to use Excel confidently for healthcare and NHS-related data management, analysis and reporting. You'll have the skills to work more accurately with information, analyse performance and operational data, identify useful trends and produce professional reports that support effective planning and decision-making.

Course overview.

Develop practical Microsoft Excel skills for managing, analysing and presenting information within a policing and law enforcement environment. This course focuses on the everyday use of Excel for operational data, performance information, resource planning, case-related administration, reporting and statistical analysis, helping staff work with information more efficiently and accurately.

You'll learn how to organise datasets, carry out calculations, identify trends and produce clear reports that can support operational planning and informed decision-making. The course emphasises accuracy, consistency, data quality and appropriate handling of information, with practical techniques that can be applied across a range of policing and administrative functions.

Who it's for.

This course is designed for police officers, police staff and support teams who use Excel as part of their role. It's suitable for analysts, administrators, operational staff, supervisors, managers, intelligence teams, finance teams, workforce teams and project staff who need to work with spreadsheets, statistics and operational information.

The course is suitable for users with basic to intermediate Excel experience and can be adapted to different roles and levels of responsibility. It focuses on practical data management and analysis techniques rather than requiring previous experience with advanced Excel features.

What you'll learn.

You'll learn how to organise, clean and structure operational datasets, using Excel tables, sorting, filtering and consistent formatting. You'll explore techniques for identifying duplicate, missing or inconsistent information and learn how to create spreadsheets that are easier to review, update and maintain.

You'll develop practical skills with Excel formulas and functions for calculating totals, percentages, averages, variances and performance measures. You'll also learn how to use lookup and logical functions to compare information, combine datasets and reduce repetitive manual calculations.

You'll learn how to use PivotTables, PivotCharts and advanced filtering to analyse larger volumes of operational information. These techniques can be used for areas such as incident statistics, demand analysis, performance monitoring, workforce information, resource allocation and other operational reporting requirements.

The course also covers data visualisation and reporting, helping you turn detailed information into clear charts, summaries and dashboards. You'll learn how to highlight trends, comparisons and exceptions using charts, conditional formatting and appropriate report layouts so that important information can be communicated clearly.

You'll also explore techniques for creating consistent and repeatable reporting workflows, including reusable templates, structured datasets and efficient data preparation. Where appropriate, Power Query can be introduced to help combine, clean and transform data from multiple sources while reducing repetitive manual work.

By the end of the course, you'll be able to use Excel more confidently for policing and operational data management, analysis and reporting. You'll have the skills to work accurately with information, analyse performance and operational trends, create meaningful reports and present data in a clear format that supports effective planning and decision-making.