CP011: 5 Excel magic tricks to impress your boss

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

1. Pintu Soni says:

   June 19, 2014 at 8:19 am

   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

   Reply
2. Mike Daniels says:

   June 19, 2014 at 8:08 pm

   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.

   Reply
3. leonk says:

   June 20, 2014 at 10:11 am

   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

   Reply
4. Dave Bruns says:

   June 21, 2014 at 2:19 am

   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

   Reply
5. Azam Lodhi says:

   June 24, 2014 at 2:31 am

   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

   Reply
6. Mucio Batista says:

   July 22, 2014 at 6:59 pm

   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!

   Reply
7. Rasheed says:

   August 5, 2014 at 1:41 pm

   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.

   Reply
8. NAYAKSANJU says:

   December 16, 2015 at 5:10 am

   Dear chandoo...

   YOU ARE AWESOME.

   Regards,
   Nayaksanju

   Reply
9. Vijay says:

   March 30, 2017 at 12:10 pm

   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

   Reply
   • Vijay says:

     March 30, 2017 at 12:11 pm

     I have learnt "How to tie photos from drop down list box" from your excel magic tricks, Thanks a lot
     VIJAY

     Reply

Leave a Reply