Good day,
Let's learn how to replace those OLD Vlookup and Xlookup functions with a powerful combination of newer functions in Excel that allow us maximum control and flexibility.
(At the end of the video, I'll also show you how to do the same thing using AI.)
AI News & More from TeachExcel
I made a new YouTube channel that focuses only on AI related news, updates, and how to's. If you're interested in AI, check it out here.
(This is separate from our main TeachExcel channel and will be commentary heavy.)
Can’t see the thumbnail? Click here to watch on YouTube
Last Week's Video: Pivot Tables are Dead
[Tiny Tip] Create a Dynamic Chart Title that Changes
Chart titles do not have to be typed manually.
You can link a chart title to a worksheet cell, and then use a formula in that cell to make the title update automatically.
Create the Title Cell
First, create the title you want in a normal worksheet cell, it can be text or a formula.
For example, in cell A1, enter:
Sales Report - June 2026
Link the Chart Title
Click the chart title once.
Click inside the Formula Bar.
Type an equals sign: =
Click the cell that contains your title.
Press Enter.
Excel will create a full worksheet reference similar to:
=Sheet1!$A$1
The chart title now displays the contents of that cell AND will change when you update that cell.
Important Note
Do not type the formula directly inside the chart title box.
The title link must be entered in the Formula Bar while the chart title is selected.
Excel needs the full worksheet reference, such as =Sheet1!$A$1, not just =A1.
Why This Is Useful
Keep chart titles updated automatically.
Make monthly reports easier to maintain.
Use one cell to control the title for a dashboard or report.
Learn more about working with dynamic Excel reports, via functions and formulas, in this week's tutorial on YouTube.
Excel AI for Fixing Macros
Courses
Cheers and see you next week!
Don