Excel Links for you – Busy busy edition
As the launch date for our 2nd batch of Power Pivot class nears, my plate looks fuller than ever. Fine tuning the course details, preparing our online classroom for new batch of students and coordinating with Rob for video recording etc.
But I wanted to take a few mins today and share with you some really useful Excel tricks, ideas and examples from web. I found these really useful and inspiring. I am sure you will learn from these links as much as I learned.
Excel Links – from USA edition
Hello there,
My travel to US was fantastic and fun. Many thanks to Jocelyn & Rob Collie, who found a nice apartment for us and made sure we are settled down in almost no time. Weather has been excellent so far too with lots of sunshine and blue skies. We went to a nearby park the other day and kids really loved walking on trials and exploring.
Gentle reminder
Today is last day to sign-up for my USA Masterclass
Today is last day to join my USA Advanced Excel & Dashboards masterclass with early bird discount. If you live near Chicago, Washington DC or Columbus and love Chandoo.org style of teaching, then you will benefit alot from my masterclass. We have very few spots left in Chicago & Columbus. So go ahead and book yours today and save $200.
Excel Links – Lets meet in Chennai this Sunday edition
Hi readers… I am in Chennai this week, conducting in-house training at Renault Nissan on Advanced Excel. As I am busy teaching Excel & making young graduates awesome in it, I will not be able to write much on the blog. But don’t worry. We have some great articles coming up from Hui & other […]
Excel Links – Going to Togo Edition
After a long time, I am writing one more Excel links post. First let me share a quick personal update.
I am invited to Lome, Togo to spend a day at Ecobank – CFO conference in 3rd week of September. I will be conducting a one day masterclass on Advanced Excel & Dashboard Reporting. I am excited about this trip as I have never been to any African country. I will post some pics and tell you how it went once I am done with the conference.
Moving on to Excel Links for today,
Excel Links – Live from Sydney Edition
Hello folks,
My flight to Sydney has been lengthy but fun. I have reached here on Sunday morning (8AM) and spent most of the day with Danielle’s family. (Danielle is the founder of Plum Solutions. She is the one who invited me to Australia and planned this whole experience for me).
On Monday (30th April), I went exploring the city on foot. I had coffee in the beautiful Queen Victoria Building, attended 1PM church service at the magnificent St. Mary’s cathedral, walked thru Hyde park, went to Sydney central station, took at sneak peek at the new Apple store in down town, got back to my hotel, walked to Opera house to meet up with our readers.
Reader meetup at Sydney
We had 6 people turn up for the meetup. It was fun talking about Excel & our journey with these wonderful folks. Here is a pic (you can see the harbor bridge in background & 8 awesome Excel users in foreground, Click on it to enlarge).
Excel Links – Live from Bangkok Edition
It has been a while since we had an Excel Links feature. So here we go again. But before jumping in to all the Excel goodness, let me share a few tidbits about our Bangkok adventure.
Using an Array Formula to Find and Count the Maximum Text Occurrences in a Range
Chandoo is off on Holidays and once again thrown me the keys to Chandoo.org.
So this week we’re going to:
- Pull apart an Array Formula and see what’s under the hood;
- Have a look at a technique for quickly developing Custom Number Formats &
- Look at how we can use HTML Codes in posts at Chandoo.org to spice up your questions and answers.
Today is Tarun’s Problem
“I have got multiple names in each row and would like to have what name is repeated maximum number of times and how many times?”
Today we pull apart an answer to this question and see how it works.