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 ShirAvivExcel@gmail.com 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
President of Shir Consulting
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.co...view full bio