Все публикации

Create a Dynamic0:10:45

Create a Dynamic Commentary in your Power BI Reports with Smart Narrative

Create an interactive1:13:43

Create an interactive HR Dashboard in Excel using Power Query, Power Pivot and PivotTables.

Create a Personal0:58:32

Create a Personal Actual vs Budget Dashboard in Excel | Power Query, PivotTables, Power Pivot

Create an Inventory0:42:39

Create an Inventory Management Dashboard in Excel: No Functions, Just PivotTables and Power Pivot

How to Analyze0:20:06

How to Analyze Google Form Responses with Power BI | Step-by-Step Tutorial

Create Interactive Visuals0:10:23

Create Interactive Visuals in Power BI with Bookmarks

Create a Dynamic1:44:29

Create a Dynamic Actual v Budget Dashboard in Excel using Power Query, Power Pivot, DAX, and Cubes

Online Lookup with0:12:40

Online Lookup with Power Query and Power Pivot

Unlock the Power0:11:41

Unlock the Power of Forecasting with Power BI and Excel | Step-by-Step Tutorial

Create a Waterfall0:11:37

Create a Waterfall Calculation Using Excel's Dynamic Arrays: Capital Allowance Case Study

A CONTAINS FUNCTION0:13:30

A CONTAINS FUNCTION IN MICROSOFT EXCEL? | Workaround with MATCH, OR, EXACT & More

Combine Trial Balance0:18:02

Combine Trial Balance Data with Power Query for Month on Month Analysis in Excel.

New Ways to0:25:06

New Ways to Summarize Data with New Dynamic Array Functions GROUPBY and PIVOTBY: Actual v Budget 1

Getting Started with2:45:56

Getting Started with Power BI: Complete Power BI beginners Case Study - Full Course

Topic 10 -0:43:22

Topic 10 - Analysing Data with PivotTable - Part 2

Topic 10 -0:48:52

Topic 10 - Master PivotTables in Excel: A Comprehensive Guide for Beginners: Part 1

Free Payroll Template0:10:47

Free Payroll Template with new Income Tax (PAYE 2024)

Demystifying Excel Icon0:15:53

Demystifying Excel Icon Sets for Conditional Formatting: A Guide on when to use Number / Percentage.

Reset or Clear0:07:44

Reset or Clear all Slicers in your Excel Dashboard with One Click

Calculate Year to0:17:36

Calculate Year to Date Values with the TOTALYTD DAX Function

Topic 9 -0:44:05

Topic 9 - Master Cell Referencing and Named Ranges to create effective formulas

Unlock the Power0:11:29

Unlock the Power of Excel Online! Learn a Simple Trick to Publish Data Model Excel Dashboards online

Dynamic Arrays and0:15:01

Dynamic Arrays and Cell Referencing in Excel

Master the New0:08:49

Master the New Excel Checkbox Feature: Create a Family-Time Dashboard Easily!