Hi folks,
I have a quick announcement & a creative dashboard to share with you. First the announcement.
Only few hours left to join our Power Pivot course…
As you may know, I have opened enrollments for our 2nd batch of Power Pivot course few days ago. The aim of this course is to make you awesome in Excel, Advanced Excel, Dashboards, Power Pivot & Advanced Power Pivot.
We will be closing the doors of this program at midnight, today (11:59 PM, Pacific time, Friday, 16th of August).
If you want to join us, click here and enroll now.
How many people have joined the class?
At the time of writing this, we have 230 students enrolled in Power Pivot class. We are eager to share Power Pivot knowledge & techniques to as many more of you as possible. So go ahead and join us because you want to be awesome in Excel & Power Pivot. See an interesting dashboard on this further down this announcement.
5 Important things about the Power Pivot course
1. This course is self-paced
That means, you can access Power Pivot & Excel lessons from anywhere at any time. You can pause, repeat or skip lessons as per your needs.
2. You will get a course completion certificate
At the end of the course, you will get a e-Certificate showing that you have completed online course on Power Pivot. Use it to show off or claim reimbursement from your boss.
3. You need Excel 2010 or Excel 2013 Pro Plus
To enjoy our Power Pivot classes, you need either Excel 2010 (any edition) or Excel 2013 Professional Plus or Office 365 Professional Plus Editions.
However, to enjoy Excel School alone, you just need Excel 2007 or above.
4. Guest lessons by Excel celebs around the world.
If Excel world has a Hollywood, then our guest faculty would be like Tom Cruise, Ashton Kutcher or Beyonce. I am honored and thrilled to present Bill Jelen, Debra Dalgleish, Zack Barresse, Kasper de Jonge, Miguel Escobar, Denny Lee, Ken Puls and others in our online classroom. Learning from these gurus is going to be legendary.
5. Special Bonuses
I have struck a deal with Rob Collie’s publishers to bring you an e-book edition of DAX formulas for Power Pivot Analysts – the definitive guide on Power Pivot measures & calculated fields. You will be able to download your copy once you join either Power Pivot class (download link will be available after we discuss DAX formulas in the class)
Apart from this, there are more bonuses – special modules on Excel, SQL & Dashboards, cheat sheet on common DAX formulas and so much more…
When will be the next batch of Power Pivot course?
As this is the first time we are running advanced power pivot course, Rob & I will be spending a lot of time fine tuning the lessons, answering student doubts & thinking up creative ways to use Power Pivot.
I am hoping to re-open Power Pivot class again in early 2014. But we may delay it if needed.
How much time I’ve got? – Count down timer using Power Pivot
We are going to close the enrollment window at today midnight (11:59 PM, Pacific Time – Friday 16th August).
So go ahead and join us before its too late.
Creative dashboard on Enrollment stats
As a token of thanks for all your support, here is a dashboard I made (with Excel ofcourse). It shows how many enrollments we had to this class.
(note about the data: Country is not captured for all sales due to limitation of our shopping cart software. Sales from certain countries excluded as they go thru another system).
This is how the dashboard looks like:
How does the dashboard work?
The basic techniques used in this dashboard are,
- A bubble chart with world outline map in the background (same as Olympic medal chart)
- Option buttons to select the course
- Conditional formatting to highlight selected course
- Text boxes to display statistics for selected course
- Tables, INDEX, MATCH, LARGE formulas in the background to do the magic.
Watch below video (16 mins) to understand how this is put together.
Download the dashboard workbook
Click here to download this dashboard workbook. Play with it to understand how it works.
And remember, enrollments for Power Pivot classes are closing tonight (at 11:59 PM, Pacific time). So go ahead and enroll if you want to become Awesome in Excel.
Thank you…
Rob & I thank you so much for your overwhelming support to this class. Your enthusiasm to learn, use and master new techniques, your kindness and your passion for Excel are truly remarkable. You inspire me everyday to learn new things and share new ideas. Thank you.
PS: Go ahead and join the class because you want to be awesome.
34 Responses to “What would you wear to an Excel themed Halloween party?”
I would go as an amoeba ... A cell!
Clippy!
Either Clippy or the Wizard.
My girlfriend and will dress up as two veals. We will carry a big heart stating our love.
It will be veal hookup
A Guantanamo bay prison guard outfit with Messi's Barcelona jersey to get across the power of discipline and creative energy.
I'd be dressed as Ross Geller, shouting "Pivot! Pivot! Pivot!":
http://24.media.tumblr.com/6b6265de049e4b4b918ec66572b2d40f/tumblr_mh5fmkj58S1rycrkjo1_500.gif
I will go with a quote on my shirt 🙂
"I love Lookup()"
Dont take the wrong meaning
I'd bring the kids and go as Pivot Table and chairs
I would dress up as the Mysterious Excel Solver!
... you could be looking for that notorious serial killer "the slicer."
Me and my wifey would wear shirts with an R and an A printed on them. We'll we an aRrAy... 😛
#N/A....
Sometimes
a t-shirt with this:
=IF(ISBLANK(QAT),"Snail Speed", "Lightning Fast")
a key! 🙂
I wonder if he would hand out Surface 3's to super heroes? I'm thinking an x(l)-men ...
http://www.jeffkoenig.com/demo/xmen.html
I just wear my expression.
I would wear a white sheet with the word "Spread" written on it.
@Pizzaguy
If there was a prize I would vote for you so far !
My T should be printed with "Excel without CHANDOO is like Computer without Inetrnet"
CH O O SE
Toga - because as large as I am, it would be a spread sheet.
Have some Rows and Columns
My t-shirt would read "I am with stupid" and point to the left while my wife's t-shirt would read "I am with stupid" and point to the right...
Guess there's nothing scarier than a circular reference..!
Happy Hallowe'en Chandoo. 🙂
I think you win, Adi! 🙂
Good one. Another indirect twist to this.
The t-shirt says "My spouse is with stupid" and both of you walk together. The circular reference breaks whenever someone joins you for a chat.
I'd put my left arm inside my shirt and go as the RIGHT function.
=vlookup(substitute(A2434," ",""), mytable$A$1:$A$100000,Match(A$1,table22:$2$.0),0)
=excel nerd
a Sum-Product Pumkin
I will have my t-shirt signed by all my relatives so I can USE RELATIVE REFERENCES to get through the bouncers at the doors
To avoid getting into any trouble at the party my T Shirt would say:
On Error Resume Next
What kind of nerd am I that I almost laughed out loud at yours Hui? 🙂
I would go with my girl and have her wear a t-shirt say =index("mr. right",match("me","all guys at party",0),1) and i would wear a shirt with two cells with one saying "me" and another saying "mr. right"
I will love to wear:
I LOVE INDEX+MATCH
“I love VLookup()”