Skip to content
Excel Tips cover art

All Episodes

Excel Tips — 52 episodes

#
Title
1

How to use Python in Excel for sentiment analysis

2

Create interactive Excel charts (part 2)

3

Create interactive Excel charts

4

How to create accounting reports with DAX

5

Why Excel macros still matter in 2026

6

Template tips to boost workflows

7

Increment dates easily in Excel

8

Master your messy data

9

Build Better Excel Models

10

Smarter, faster, easier: Here's what's new in Excel

11

Unlock 7 underused Excel features you still need today

12

How to simplify complex calculations with custom functions

13

Smarter, faster, easier: Here's what's new in Excel

14

Unleash the power of Python in Excel

15

Python in Excel: Practical applications

16

Getting started with Python in Excel

17

Excel's GROUPBY and PIVOTBY explained

18

Better share price reports with Excel's new tool

19

Elevate your Pareto analysis skills with Excel

20

Unlock the power of Microsoft Forms in Excel

21

New tool explained: boost your efficiency with checkboxes

22

Improve your PDF data handling with Power Query

23

Handy hack to create timeline charts

24

Master calendar creation in Excel

25

How to add a user interaction into Power Query

26

Learn a smart way to hide blank or zero rows

27

The power of heat maps for sales and costs data

28

3 powerful macros to streamline your workflow

29

Level up your custom functions skills

30

How to create a dashboard using Excel's dynamic arrays

31

How to automate report building in Excel (part 2)

32

How to automate report building in Excel

33

Master the latest Excel changes: your ultimate guide

34

How to master using different Excel techniques together

35

Top Excel tips for your first 100 days in a new job

36

How to create improved data visualisations in Excel

37

Master 10 new and revamped Excel features

38

Boost your skills with tips for Excel function updates

39

Unlock 14 expert tips for Excel formulas

40

Why Excel can be a university student's secret weapon

41

22 Excel shortcuts to supercharge your efficiency

42

Excel and ChatGPT

43

Learn Excel's built-in artificial intelligence feature

44

How to use custom functions without macros

45

How to do dynamic arrays (subscription version)

46

How to create vertical lines in line charts

47

Excel tips: how to use the new data types feature

48

Excel tips: how to work with dates and days

49

Excel tips: how to use Goal Seek

50

Excel tips: how to improve your formatting

51

Excel Tips: New text functions for Excel

52

EXCEL TIPS, coming soon.