How I Made $70,000 Using Excel Pivot Tables

, President of Shir Consulting


Use Discount code LASTTIME to get $20 off

Don't miss my other classes which will be taught for the last time on the following dates:

Excel Foundations: Analyze the Past & Control the Future - 4/16/13

Behind the Curtain: Excel Secrets Revealed - 4/30/13


#3 Rated Master Teacher on Skillshare in Ratio of Endorsements to Students

As seen on

"Must-take class for all aspiring Excel gurus. Went into the class expecting to acquire just a general idea of what pivot tables might be, came out feeling like I can now perform magic tricks with mass data tables." - Michelle J. (Project Manager, Morgan Stanley)

"One of the few instructors I've come across in the Excel education world that I feel is concise, understands his audience, and extremely passionate about the topic." - Brandon L. (Vice President, Macquarie Group)

"I've been at work 45 minutes and just used pivot tables for my first analysis in a standard update I do twice a week. Um... it took 20 seconds... this used to take 10-30 minutes! THANK YOU SHIR!" - K. K. (Scientist)


Yes, you read the title correctly. $70,000 in 6 months to be exact. You don't have to be an Excel guru to figure out that's a pretty good deal!

Can I promise you the same results? No, but I can promise you that you will never be out of work ever again.

How can I be so sure?

Because people who truly understand Pivot Tables can save companies hundreds of thousands of dollars through increased accuracy, efficiency, as well as the ability to make informed business decisions. In fact, I saved one of my clients over $150,000 per year doing just that: Shir Consulting Testimonial.

In this 2 hour class you will learn:

  • The 5 basic elements of Pivot Tables
  • 5 Reasons why not using Pivot Tables will cost you dearly
  • 5 Specific examples of when to use Pivot Tables
  • 5 Key benefits of using Pivot Tables
  • 5 Simple steps to creating your own Pivot Table (in under 5 minutes)

A day before class you will receive an email requesting you to participate in my one-of-a-kind collaborative Excel project. It's super fun, and everyone will walk away with their own copy of the project. We'll also be using it in class, so please make sure to complete it on time.

Everyone is also encouraged to bring their own data set they would like to analyze. It can be something from work or even a personal spreadsheet (e.g. Workout log, personal finance tool, etc.). Just remember, the bigger the data set, the more interesting the analysis.

As always, all my classes are backed up with a 100% money-back guarantee. Attend all 2 hours of the class, and if you don't love it (for ANY reason) send me a single email, tell me how I can improve the class, and I'll refund ALL of your money. We'll even part as friends.

Easy peasy, lemon squeezy.

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:

  • Excel 2010 for PC (Preferred)
  • Excel 2007 for PC
  • Excel 2011 for Mac

Versions of Excel that are NOT OK for class:

  • Excel 2003 for PC or earlier
  • Excel 2008 for Mac or earlier

See the links below to download a free trial version of the latest Excel software, or purchase on (highly recommended and totally worth every penny!)

Free Trial for 60 days for Excel 2010 for PC:
Free Trial for 30 days for Excel 2011 for Mac:

Microsoft Office 2010 for PC Home & Student 3PC /1 User:
Microsoft Office 2011 for Mac Home & Student - 1 User:
Microsoft Office 2011 for Mac Home & Student -Family Pack (1 User/3 Installs):

Cancellation Policy:

  • If you absolutely have to cancel or reschedule a class, you must do so more than 48 hours before the class. Anything less than that does not provide enough time to fill your seat, and therefore is NOT ELIGIBLE for credit or a refund.
  • Cancellations more than 48 hours in advance can receive refunds (minus the Skillshare and Paypal fees) or get credit towards a future class.
This is an intro class designed for people who have little or no experience with Pivot Tables. If you are already familiar with Pivot Tables, THIS CLASS IS NOT FOR YOU!
  • How I Made $70,000 Using Pivot Tables

    Morpheus Media

    127 West 26th St., 6th Floor Between 6th & 7th Ave.
    New York, NY

    Wed, October 17th, 2012

    7:00 pm - 9:00 pm EDT

    Add to Cal

Shir Aviv

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, 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:

View Full Profile

99% Positive Reviews (80 Reviews)

    Morpheus Media

    127 West 26th St., ...

    New York, NY

    14 / 14 Students

    • 17


    • 170


    • 222