Tutorials

We constantly publish new content on the most modern and relevant Excel topics. Learn exceptional techniques that will amaze your peers and boost your career with outstanding skills and knowledge.

Ultimate Excel Personal Budget

This Excel tutorial teaches you how to create a full-blown personal budget management template with outstanding visualizations in Excel.

Ultimate Excel Gantt Chart

This Excel Tutorial teaches you how to create a professional Gantt Chart template in Excel with multiple advanced and interactive features.
Drop Down Lists in Excel - Masterclass

Drop Down Lists in Excel – Masterclass

This Excel Masterclass teaches the full range of drop down list techniques in Excel, from the fundamentals up to searchable drop down lists.
Automated Control Chart in Excel

Automated Control Chart in Excel

Learn step-by-step how to create an automated control chart in Excel with a data simulation built on top.

Shaded Deviation Line Chart in Excel

Learn step-by-step how to create a shaded deviation line chart in Excel, either with only one color or with different colors for positive and negative deviations.

Multi-Layer Doughnut Chart in Excel

Learn how to create a multi-layer doughnut chart in Excel. This advanced data visualisation technique allows you to build beautiful Excel dashboards.

Dynamic Data Search Box in Excel [Part 2]

Learn how to build a dynamic data search box in Excel that allows you to filter your data as you type (using the new FILTER function in Excel 365).

Dynamic Data Search Box in Excel [Part 1]

Learn how to build a dynamic data search box in Excel that allows you to filter your data as you type (using the new FILTER function in Excel 365).

Ultimate Excel Dashboard | Interactive Settings Menu

Learn how to create a custom interactive settings menu with modern and fully functional toggle and radio buttons for your Excel dashboard.

Ultimate Excel Dashboard | Interactive Dashboard Tabs

Learn how to create custom interactive tabs for your Excel Dashboard. They allow you to display more content without requiring additional space.

Ultimate Excel Dashboard | Interactive Info Button

Learn how to create a custom interactive info button for your Excel Dashboard that allows you to display additional information without any space required.

Ultimate Excel Dashboard | Auto-Refresh Pivot Charts

Learn how to make the Pivot Tables and Pivot Chart of your Dashboard automatically refresh when the source data changes.

Ultimate Excel Dashboard | Modern Slicer Design

Learn how to create a modern and minimalistic design for pivot slicers in an interactive Excel dashboard. It is not much effort but makes the difference.

Ultimate Excel Dashboard | Background & Tile Design

Learn how to create a modern background and gradient tile design for interactive Excel dashboards. Create advanced designs with only little effort.

Ultimate Excel Dashboard | Basic Interactive Dashboard

Learn how to create the ultimate Excel dashboard with interactive elements and an outstanding design. Bring your data to life with next level visuals.

Learn Pivot Tables in Microsoft Excel

Learn how to use Pivot Tables in Excel as a powerful tool to effectively slice and analyse your data. This short tutorial has everything covered!

Excel Map Chart Full Tutorial

Learn how to use the integrated Microsoft Excel Map Chart feature for an outstanding data visualisation. Get to know different map chart types and designs.

Top 10 Basic Excel Functions and Formulas

Learn about the top 10 basic Excel Functions and Formulas that you should know. This tutorial will give you a solid foundation for everyday work in Excel.

Well-Designed and Interactive Excel Dashboard

Learn how to use Pivot Tables, Pivot Chards and Slices to create a well-designed and interactive Excel Dashboard for your data.