Good day,
This week, let's make an automatically updating dashboard in Excel!
When you add a CSV file to a folder, Excel will automatically pick that up, import it, transform it, update pivottables and charts, and refresh the dashboard, all without code or vba.
Excel AI for Fixing Macros
Our automated tool for fixing and updating macros in Excel - this was built for complete novices to use!
Build the Self-Updating Excel Dashboard (Anyone Can Do It)
Can’t see the thumbnail? Click here to watch on YouTube
Last Week's Tutorial: Excel’s Hidden Data Entry Form
Funny Work-Humor Clip
A little office humor from us to start the week, courtesy of YouTube Shorts.
[None this week - please check back next week]
[Tiny Tip] The Two Text Functions You Need to Know
Working with text in Excel does not have to turn into a mess of ampersands, copy and paste, or Text to Columns. These two functions help you combine text and split text with clean, dynamic formulas.
1. TEXTJOIN: Combine Text Cleanly
If you have a list of values in A2:A6, you can combine them into one cell with a comma between each item.
=TEXTJOIN(", ", TRUE, A2:A6) |
Tip: click into the box and copy the formula.
The TRUE argument tells Excel to ignore blank cells, so you do not end up with extra commas.
Example
If A2:A6 contains this list:
Apple |
the formula returns:
Apple, Banana, Orange |
2. TEXTSPLIT: Break Text Apart Instantly
TEXTSPLIT does the opposite. It takes one cell and separates the text into multiple cells based on a delimiter.
=TEXTSPLIT(A2, ", ") |
Tip: this splits the text wherever Excel finds a comma followed by a space.
Simple Way to Remember It
TEXTJOIN takes many cells and combines them into one cell.
TEXTSPLIT takes one cell and splits it into many cells.
Notes
TEXTJOIN is available in modern versions of Excel and TEXTSPLIT requires newer versions of Excel that support dynamic array formulas.
Excel AI for Fixing Macros
Courses
Cheers and see you next week!
Don