Update: This is the LAST TIME I will be teaching this course in person.
It was a beautiful Saturday afternoon, and the last place Dan wanted to be was stuck in his office working on the monthly sales report. But of course, his boss had a last minute change which absolutely had to be made by Monday morning.
"This is what I went to college for?" Dan thought to himself as he cursed Excel for robbing him of his weekend...again!
Over the past several years I have heard some variation of this story over and over again. What gets me every time is that Dan was a smart guy, capable of adding tremendous value to his organization, yet he spent most of his time doing tedious, de-humanizing work that Excel should have been doing for him.
It's not Dan's fault though, since nobody ever taught us these fundamental skills. Until now...
Just imagine how it will feel to go out for a long lunch break, and come back to find all of your reports prepared for you, with absolutely zero manual repetitive work remaining. At the end of this course you will be able to turn that dream into reality.
You will learn:
Course Content and Format:
The primary example we will be using throughout the course will be a personal finance tool which we will create together over the first 4 weeks. Once completed, it will help you pinpoint exactly where you are spending money, how much you need to earn each month to cover all your expenses, which transactions are tax-deductible, etc..
On the 5th week you will bring in your own Excel project for a capstone workshop (don't worry, I have plenty more examples to provide in case you don't have one). In this workshop, you will apply everything you have learned to turn your spreadsheet into the most impressive and useful data tool you've ever created.
For the first 4 weeks, each 2 hour class will be divided into part lecture and part hands-on workshop. You will work in pairs to complete exercises that gradually increase in difficulty and are specifically designed to teach you only the most essential Excel concepts. We then review your answers as a class and address any questions before moving on.
This course is perfect for you if:
This course is NOT for you if:
As always, all my classes are backed by the Shir Guarantee: "You will gain at least 1 new and valuable insight/shortcut or your money back. No questions asked."*
Note: Laptops are required. Computers will NOT be provided. If you cannot bring a laptop please email me at [email protected] so I can make sure there are enough laptops to share (we will be working in pairs).
Versions of Excel that are OK for class:
Versions of Excel that are NOT OK for class:
See the links below to download a free trial version of the latest Excel software, or purchase on Amazon.com (highly recommended and totally worth every penny!)
Free Trial for 60 days for Excel 2010 for PC: https://office.microsoft.com/en-us/try
Free Trial for 30 days for Excel 2011 for Mac: http://download.cnet.com/Microsoft-Office-2011/3000-18483_4-75305578.html
Microsoft Office 2010 for PC Home & Student 3PC /1 User: http://amzn.com/B004E9SKEQ
Microsoft Office 2011 for Mac Home & Student - 1 User: http://amzn.com/B0064PFB9U
Microsoft Office 2011 for Mac Home & Student -Family Pack (1 User/3 Installs): http://amzn.com/B004E9SKBO
To install a virtual PC on your Mac, please read the following post in the discussion board: http://www.skillshare.com/Excel-is-CRAP-How-to-Calculate-Record-Analyze-Present-Data/719860157/1943177622/classroom/discussions/1835
Calculations are the cornerstones of every spreadsheet. In this class you will learn:
Q: If data is recorded in a spreadsheet, but nobody is there to format it properly, does it exist?
A: Nope. At least not as far as Excel is concerned. Who knew Excel could be so heartless?
In this class you will learn:
Did you ever wonder why some people get promoted and others don't?
I believe the answer lies in the ability to translate raw information into meaningful conclusions. In other words, how to analyze data and then clearly communicate your findings to the right person. In this class you will learn to do just that.
In addition, you will also learn how to:
Believe it or not, I can look at thousands of rows of data all day and be absolutely enthralled. It's true, I'm a huge nerd :).
The truth is that most people require visual aids to assist in their understanding of the numbers. That's where charts come in.
In this class you will learn:
Before this final capstone workshop you will receive a cheat sheet with all the Excel concepts we covered in the previous 4 weeks. In addition, you will receive a checklist with specific instructions on how to apply these concepts to your own Excel project (don't worry, I have plenty of examples to provide you in case you don't have one).
I highly recommend that you take at least an hour or two to go through the checklist before the 5th session. That way, if you get stuck you can write down all your questions and bring them in for the workshop. Once again, you will work in pairs, but I will also be there to answer questions.
As a final wrap-up to the course, I will let students volunteer to share their projects with the rest of the class for no more than a 2 minute presentation. This is a great opportunity to get constructive feedback from myself and the rest of the class on how to improve your specific project. If you would rather not present in front of everyone, I will be there to give feedback on an individual basis as well.
Shir is the president of Shir Consulting, which helps small businesses use their existing data to uncover previously hidden insights & opportunities. He is also the former Marketing & Analytics Advisor for the New York Technology Council, has been featured as the Microsoft Excel Expert on Howcast.com, and has taught Excel classes at General Assembly.
When not tweaking spreadsheets, Shir can be found dancing Argentine Tango in NYC's vibrant Tango scene. He holds a BS in Business Administration from the University of Vermont.
Still curious? Check these out: