Escolha o seu idioma

Excel

Formulas · Power Query · Pivot Tables · Automation

Practical Excel resources, examples and projects to help you analyse data, automate repetitive work and build clearer reports.


Explore by topic

Develop the Excel skills that make everyday analysis faster, clearer and more efficient.

Formulas

Use practical formulas and functions to clean, analyse and organise business data.

Explore formulas →

Power Query

Import, clean and transform data efficiently with repeatable workflows.

Explore Power Query →

Pivot Tables

Summarise large datasets and uncover patterns using flexible interactive analysis.

Explore Pivot Tables →

Automation

Save time by automating repetitive tasks with advanced Excel tools and VBA.

Explore automation →

Choose your Excel learning path

Start with the essentials and progress towards more efficient analysis and automation.

Beginner

Build the foundations.

Learn formulas, tables, formatting and the essential tools for working confidently with data.

Intermediate

Analyse data more efficiently.

Improve your formulas, Pivot Tables and Power Query skills with practical business examples.

Advanced

Automate and optimise.

Work with advanced formulas, reusable models, Power Query and VBA to streamline complex tasks.

Featured Excel Resources

Excel Starter GuideFREE

Essential formulas, shortcuts and practical examples for working more efficiently in Excel.

Excel Analysis ToolkitPREMIUM

Reusable templates, formulas and analytical tools for common business reporting tasks.

Excel Practice ProjectPREMIUM

Analyse a realistic business dataset using formulas, Power Query, Pivot Tables and reporting techniques.


Featured Projects

Automotive Parts Analytics

Clean, explore and analyse sales, product and inventory data using Power Query, formulas and Pivot Tables.

Work smarter with Excel.

Build practical analysis and automation skills with reusable resources and real-world projects.