Uploaded December 2024 | Updated September 2026, 2 weeks ago
Impress (or prank) your colleagues with five jaw-dropping Excel tricks that blend creativity with functionality. From generating personalized images in cells using Lambda functions to creating a broken sheet illusion, these clever hacks are guaranteed to spark curiosity. You'll learn how to create an "AnyImage" function to dynamically display themed icons, a "GridImage" trick for generating grid-based graphics, and even manipulate number formatting to show misleading results. Plus, master the XLL function for clickable XLOOKUP links and the ingenious broken sheet hack that turns a screenshot into a convincing sheet background.
Whether you're looking to amaze coworkers, teach advanced Excel concepts, or just have fun, these tricks provide a perfect mix of entertainment and education. Dive in to uncover the magic of Lambdas, creative formatting, and Excel's hidden potential. Don’t forget to download the example file and try it out yourself!
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
How I did it:
00:00 The tricks demonstrated
03:25 Trick 1 : AnyImage
05:38 Trick 2: GridImage
08:45 Trick 3: Wrong Numbers
09:18 Trick 4: XLL - XLOOKUP LINK
10:53 Trick 5: Broken Sheet
File:
https://accessanalytic.com.au/5-excel-tricks-to-wow-your-colleagues/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
Impress (or prank) your colleagues with five jaw-dropping Excel tricks that blend creativity with functionality. From generating personalized images in cells using Lambda functions to creating a broken sheet illusion, these clever hacks are guaranteed to spark curiosity. You'll learn how to create an "AnyImage" function to dynamically display themed icons, a "GridImage" trick for generating grid-based graphics, and even manipulate number formatting to show misleading results. Plus, master the XLL function for clickable XLOOKUP links and the ingenious broken sheet hack that turns a screenshot into a convincing sheet background.
Whether you're looking to amaze coworkers, teach advanced Excel concepts, or just have fun, these tricks provide a perfect mix of entertainment and education. Dive in to uncover the magic of Lambdas, creative formatting, and Excel's hidden potential. Don’t forget to download the example file and try it out yourself!
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
How I did it:
00:00 The tricks demonstrated
03:25 Trick 1 : AnyImage
05:38 Trick 2: GridImage
08:45 Trick 3: Wrong Numbers
09:18 Trick 4: XLL - XLOOKUP LINK
10:53 Trick 5: Broken Sheet
File:
https://accessanalytic.com.au/5-excel-tricks-to-wow-your-colleagues/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
