Uploaded July 2025 | Updated November 2026, 5 days ago
Avoid common Excel errors by ditching INDIRECT for better alternatives.
π©βπ« Master Power Query with my course: bit.ly/indirect25course
β¬οΈ Download the example file here and follow along: bit.ly/indirect25file
Letβs talk about a function that seems useful but secretly causes chaos in your workbook: INDIRECT.
You enter a cell reference or a defined name as text, and INDIRECT turns that text into a real reference.
It feels advanced and powerful because it overcomes limitations we used to experience β but itβs one of the top reasons spreadsheets break, slow down, and become a nightmare to debug.
In this video, Iβll show you why itβs time to move on β and how to replace it with modern Excel features that are faster and easier to maintain.
LEARN MORE
===========
π° EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
π― FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
β² TIMESTAMPS
==============
0:00 Why INDIRECT seems useful
2:01 The problems with INDIRECT
2:44 Alternatives
13:30 Create your own Excel functions
#Excel #ExcelFunctions #ExcelFormulas
Avoid common Excel errors by ditching INDIRECT for better alternatives.
π©βπ« Master Power Query with my course: bit.ly/indirect25course
β¬οΈ Download the example file here and follow along: bit.ly/indirect25file
Letβs talk about a function that seems useful but secretly causes chaos in your workbook: INDIRECT.
You enter a cell reference or a defined name as text, and INDIRECT turns that text into a real reference.
It feels advanced and powerful because it overcomes limitations we used to experience β but itβs one of the top reasons spreadsheets break, slow down, and become a nightmare to debug.
In this video, Iβll show you why itβs time to move on β and how to replace it with modern Excel features that are faster and easier to maintain.
LEARN MORE
===========
π° EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
π― FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
β² TIMESTAMPS
==============
0:00 Why INDIRECT seems useful
2:01 The problems with INDIRECT
2:44 Alternatives
13:30 Create your own Excel functions
#Excel #ExcelFunctions #ExcelFormulas





![Excel Tutorial for Beginners [Made Easy]
β¬οΈ Download the example file here and follow along: https://bit.ly/beginner24file
π©βπ« Advanced Excel Formulas course: https://bit.ly/formulas24course
π©βπ« Excel Tables course: https://bit.ly/tables24course
Excel is the key to unlocking limitless opportunities. Itβs a skill that can elevate your career, manage your finances like a pro, and turn raw data into powerful insights. In this video, weβll cover everything from the basics right through to tools most Excel users never learn, which holds them back. Weβll start with navigating the interface, entering data, including some shortcuts, as well as formulas and functions, Formatting, including Conditional Formatting, Sorting & Filtering, Data Cleaning, Tables, Charts and PivotTables, and all in well under half an hour.
π Useful Excel materials mentioned in this video:
- Excel Shortcuts for Windows & Mac: https://youtu.be/TmzEOze_HHs
- How to Store Data the Right Way: https://youtu.be/CNlw1-Vh4cE
- PivotTable Tricks That Will Change the Way You Excel: https://youtu.be/187xEPVg1Gc
LEARN MORE
π° EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
π― FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
π¬ EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
β² TIMESTAMPS
0:00 What youre going to learn
0:47 Understanding the Excel interface
1:56 How to enter and navigate data
4:08 Every beginner needs to know this trick
4:40 How to create formulas and functions
6:20 Why & how to use $ (Dollar) sign in formulas
7:27 LIMITED OFFER
7:56 Simple & conditional formatting
10:03 How to sort & filter data
11:47 How to delete duplicates
12:21 Why you need to use Excel tables
14:34 LIMITED OFFER
14:47 Different types of charts and their purpose
17:37 One of the most useful Excel tools (PivotTables)
19:25 Slicers to filter PivotTable data
#Excel #ExcelTutorial #ExcelForBeginners Excel Tutorial for Beginners [Made Easy]](https://i.ytimg.com/vi/fzdn1vcHPsA/mqdefault.jpg)




