The Excel Dojo

The Excel Dojo

Home
Notes
Archive
Leaderboard
About
TED #040: Array of Possibilities: Introducing =TAKE() in Excel
Learn how this function can revolutionize your data handling experience in Excel.
 • 
Ajay Patel
1
TED #039: Slice & Dice your Text with =TEXTSPLIT()
Breaking down the nuances of =TEXTSPLIT(), turning bulky text into manageable pieces.
 • 
Ajay Patel
4
TED #038: =FILTER() Your Way to Efficiency
Discover how the =FILTER() function can streamline your data analysis, making spreadsheet tasks simpler than ever.
 • 
Ajay Patel
TED# 037: SORT & SORTBY
A must know function that helps us organize our data.
 • 
Ajay Patel

September 2023

TED# 036: Exploring Dynamic Array Functions in Excel
Part 1: =UNIQUE()
 • 
Ajay Patel
TED #035: Creating Numbered Sequences in Excel - Part 3
A deep dive into Excel's =SEQUENCE Data Array Function
 • 
Ajay Patel
TED #034: Creating Numbered Sequences in Excel - Part 2
Diving into a few of Excels features that allow you to get this done!
 • 
Ajay Patel
TED #033: Creating Numbered Sequences in Excel - Part 1
Diving into a few of Excels features that allow you to get this done!
 • 
Ajay Patel

August 2023

TED# 032: A Deep Dive into XLOOKUP - Part 3
Breaking down one of Excel’s most versatile and useful functions.
 • 
Ajay Patel
TED# 031: A Deep Dive into XLOOKUP - Part 2
Breaking down one of Excel’s most versatile and useful functions.
 • 
Ajay Patel
TED# 030: A Deep Dive into XLOOKUP - Part 1
Breaking down one of Excel’s most versatile and useful functions.
 • 
Ajay Patel
TED #029: Splitting Up Data In Cells
Using Text-to-Columns to split up data from a single cell into multiple cells.
 • 
Ajay Patel
© 2025 Ajay Patel
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture