Hello folks,
If this article was a person, they would be schizophrenic. You see, it has 2 purposes:
- Give you all the details about my upcoming Power Pivot course
- Give you a solution to last week’s vacation days problem
Details about Power Pivot Course
In case you are not interested in this course, skip to the solution video.
What is this course?
Power Pivot, an Excel add-in makes it easy to connect, analyze & visualize massive amounts of data. This course aims to teach you how to use Power Pivot to analyze data, create advanced reports & prepare dashboards all from familiar interface of Excel.
Who should go for this course?
This course is ideal for data analysts, reporting & MIS professionals, business analysts, managers & dashboard makers.
Please note that you should be familiar with Excel & Pivot Tables and running at least Excel 2010 to enjoy this course.
Course topics, methodology & full details:
I made a short video explaining how this course works, benefits for you, topics covered and more. Please watch it below
(click here in case you are not able to see the video in email or feed reader)
Download Power Pivot course brochure
Click here to download our course brochure.
Use it to,
- Ask your company / boss to sponsor your for this course
- Understand topics & benefits of the course
- Learn how our course works
- Know about Chandoo – your instructor
- Find out how to get in touch with me if you have doubts or questions
- See what our earlier students think about us
IMPORTANT DATES
- Enrollment for course begins on: 6 Feb 2013 (Wednesday)
- Enrollment closes on: 15 Feb 2013 (Friday)
- Classes begin on: 18 Feb 2013 (Monday)
Demo lessons
For free demo lessons on Power Pivot, click here.
Questions or doubts?
If you have any questions or doubts about our course, please email me at chandoo.d@gmail.com or call me at +91 814 262 1090.
Solution to Vacation Days problem
On Friday, we posted a home work problem for you – Calculate vacation days using formulas. There were quite a few interesting solutions in the comments.
Today, let me explain how to solve these problems using Excel formulas.
Watch below video:
Download solution workbook
Click here to download the solution work book & see the formulas.
Not interested in either of them?!?
Then what are you doing here? Go out and enjoy the sun, sip some coffee or play with your kids 🙂
PS: Once power pivot and regular pivot were in a bar bragging to each other. Power Pivot says, “I am so awesome I can turn data in to insights in no time.”, After thinking long and hard, Pivot table says, “I don’t know, I can’t really measure.”
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()”