CP031: Invisibility Tricks – How to make things disappear in Excel?
About this episode
In the 31st session of Chandoo.org podcast, let's disappear.
What is in this session?
Spreadsheets are complex things. They have outputs, calculation tabs, inputs, VBA code, from controls, charts, pivot tables and occasional picture of hello kitty. But when it comes to making a workbook production ready, you may want to hide away few things so it looks tidy.
That is our topic for this podcast session.
In this podcast, you will learn
- Quick announcements first anniversary of our podcast etc.
- Hiding cells, rows, columns & sheets
- Hiding chart data points
- On/off effect with form controls, conditional formatting
- Making objects, charts, pictures disappear
- Disabling grid-lines, formula bar & headings
- Hiding things in print
The post CP031: Invisibility Tricks – How to make things disappear in Excel? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
Get every episode summarized
Each time Chandoo.org Podcast - Become Awesome in Data Analytics publishes, we email you a written briefing from the transcript — the topics, who appeared, and any specific claims, with the ad reads skipped.
Email me new episodesFree for 3 shows. No card needed.
Hosts & guests
No transcript yet
This episode has not been transcribed. Request it and it moves to the front of the queue.
More episodes
More from Chandoo.org Podcast - Become Awesome in Data Analytics
CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)
Chandoo.org Podcast - Become Awesome in Data Analytics
SQL vs. Power Query – The Ultimate Comparison
Chandoo.org Podcast - Become Awesome in Data Analytics
CP03: The Ugly Truth About Power BI (actually, 4 of them)
Chandoo.org Podcast - Become Awesome in Data Analytics
CP02: Six Tips to get a Six Figure ($100,000+) Data Job
Chandoo.org Podcast - Become Awesome in Data Analytics