fbpx
Search
Close this search box.

CP011: 5 Excel magic tricks to impress your boss

Share

Facebook
Twitter
LinkedIn

In the 11th session of Chandoo.org podcast, lets puts on a magic show for your boss

5 Excel magic tricks to impress your boss - CP011 - Chandoo.org Podcast - Become awesome in data analysis, charting, dashboards and VBA using Excel

What is in this session?

We all want to impress our bosses, create awesome experiences for our users and become enviable in workplace with our Excel skills. In this session, lets explore 5 very powerful, magical features of Excel that can help you create that jaw-dropping effect.

In this podcast, you will learn,

  • Announcements
  • Why magic
  • 5 Excel Magic Tricks
  • 1: Conditional formatting
  • 2: Form controls + Charts
  • 3: Pivot tables + Slicers
  • 4: Macros + Automation
  • 5: Using right feature @ right time
  • How to learn these magic tricks
  • Conclusions

Go ahead and listen to the show

 

Links & Resources mentioned in this session:

Conditional Formatting

Form controls + Charts

Then vs. Now - interactive chart with form controls

Pivot Tables + Slicers

Macros & VBA

Transcript of this session:

Download this podcast transcript [PDF].

What are your favorite Excel magic tricks?

My favorites are conditional formatting, slicers, form controls + charts in that order.

What about you? What features of Excel are most impressive and mesmerizing? Please share your thoughts using comments.

Subscribe to Chandoo.org Podcast

Other options to subscribe

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

10 Responses to “CP011: 5 Excel magic tricks to impress your boss”

  1. Pintu Soni says:

    Hi Chandoo.

    Thank you very much for your effort to teach us so many things with simplicity. All your teachings have really helped me so far. Keep posting. God bless you.

    Pintu

  2. Mike Daniels says:

    Absolute best Excel item for me is PivotTable - and I still don't know all there is to know. But what a time saver; expecially for large data base.

  3. leonk says:

    1 - MS Query to pivot 2 workbooks via a 5 line UNION QUERY, which also exceeds the million line issue (I’ve currently managed 3.5 million lines and 20 workbooks - excellent for analysing researcher collected data in a dashboard with sliders and a dynamic graph created on the fly - Now that's magic.

    2 - Dynamic named range formula to create truly versatile pivots from variable column and row data EG NamedRange =$A$1:INDEX($1:$65535),COUNTA($A:$A),COUNTA($1:$1)). This formula, and variations of it to create columns and rows for Index/Match lookups, alters the data model dependant on the data from a data connection source on refresh. I replaced a heavy VBA model with a few formulas – NO VBA AT ALL - to achieve a far more versatile multi pivot table data model which is truly scalable as the customer’s requirements change – PURE MAGIC.

    I learnt technique 1 from Contextures.com. I developed technique 2 from Chandoo’s recent article on volatile formulas.
    Thanks Chandoo for your work

  4. Dave Bruns says:

    Hi Chandoo,

    Great podcast, and very nicely presented. I love the way you combine technical knowledge with a kind of human intelligence. Great combination.

    Near the end of the podcast, you talk about using the right feature at the right time to create a magic effect that can cause management and clients trust you in a special way. It reminds me of a British expression where they say he or she "is a safe pair of hands". Just a few simple words, but it's a great compliment.

    Thanks for taking the time to publish a podcast.

    Dave

  5. Azam Lodhi says:

    hi chandoo,

    thank you so much for you teaching. I am one of your very old reader/ student and learning lot about excel. You podcasting is out class it is a beautiful combination of knowledge, organization of program , simplecity, honesty , love to teach . So please keep posting and doing your work. I alwys love to see you articals or listen your podcasing every day

  6. Mucio Batista says:

    Hey Chandoo, another fantastic job!!! Congrats!
    I'm your fan!!! God Bless you with much health to let you sharing your knowledge for many many years!!! When do you come to Brazil? I'm looking forward to your sessions in Brazil! All the best!

  7. Rasheed says:

    Dear Chandoo ..

    I m a regular reader of chandoo.org and listener of your podcast. Really helped much as a learner of excel. Thanks a lot for sharing.

  8. NAYAKSANJU says:

    Dear chandoo...

    YOU ARE AWESOME.

    Regards,
    Nayaksanju

  9. Vijay says:

    I am interested in charts & Vlookup, Index & Match
    If anything interesting please send mail
    I have learnt How to tie photos from drop down list box from your excel magic tricks, Thanks a lot
    VIJAY

Leave a Reply