Master Workbook

All-in-one Excel Cheat Sheet

Here is a link to a file I created which has a lot of useful Excel information.  This workbook should be used in conjunction with the online video lessons & tutorials.  Some lessons have their own individual files which will be linked to in the post.

Download here: Excel Exposure – Master Workbook [4-30-2013]

This is the workbook which will be used in Video tutorials, and will be updated frequently for additional examples and information.

It is essentially an all-in-one Excel Cheat Sheet which includes:

  • List of all Excel functions/formulas with explanation, syntax, category, and experience level ranking.
  • List of all Excel shortcuts with explanation, shortcut method, category, and experience level ranking.
  • Outline of Overall Lesson Plan, this will evolve over time but has many of the areas I plan to cover.
  • Examples of Experience Level 1 Functions by category.
  • Additional sheets which will be relevant to future lessons (Pivot Tables, Autofill, Data, etc).
  • And much more!

Here’s an Excel 2003 version for those of you using it.  There will be some sections of the Master Workbook that break because the features are not available in 2003, but I wanted to at least post a version that can be opened using 2003.  Most of the information will still be relevant.

50 thoughts on “Master Workbook”

  4. Excellent! I’ve been using Excel for over 10 years and have found something new even from the Introduction. Can’t wait for the Pivot Table lessons as I’ve always struggled with these.

    Reply ↓

  6. wow i wouldnt have been able to learn excel any other way…thank you so much Ben for your tutorials…you wouldnt know how much you have helped me.Thamk you so so very much!!!!

    Reply ↓

  7. I know its been said, but I just wanted to leave my own “thank you” comment. I’ve been applying to a lot of admin positions, and this skill will help my resume immensely.

    Reply ↓

  9. Excel Exposure ROCKS! I have been out of the workforce for a while and needed to sharpen my Excel skills. I have listened and watched numerous video tutorials that were almost painful due to the speakers voice or their lack of instructional ability. You are the only tutorial where I have enjoyed listening to the instructors voice and the curriculum is delved into at a deeper lever for understanding and knowledge. Very challenging, as well.
    Thank you so much for your efforts. This obviously was a huge endeavor on your part and a very generous gift to the many students.
    Blessings to you.
    PS-Wish you did MS Access

    Reply ↓

  11. Thank you so much for such selfless work for the greater good. Courses like this are so expensive and here you are spending your time and sharing your knowledge. Thank you again for being who you are.

    Reply ↓

  13. This has been the most informative tutorial for any level of Excel tutorials I have come across for free . I cannot thank you enough for this website. I wish you all the very best for your success and appreciate your effort.

    Reply ↓

  14. Dear,

    There are a set of debit values and a set ot credit values in a column. I want a vba code by whcich the debit value plus a single / multiple credit value is zero that needs to be marked .

    finally i will come to know out of the avaibale debits which cannot be used the with avilable credits either single or multiple values.

    If multiple matching sets are available let it take the 1st or the 2nd one its not an issue.

    Column A Ref

    -1000 A
    -5000 B
    -8000 C

    800 A
    100 A
    100 A
    2000 B
    3000 B
    13000
    15000

    Thanks in Advance

    Reply ↓

  17. Hi,
    I just can’t thank you enough for making this available to everyone. I’m a business student, so needless to say we work with plenty of spreadsheets, and yet there is no dedicated excel course. Or, at least not as part of the core curriculum. This means my knowledge of excel is shallow and sporadic and nothing near what it needs to be if I really want to use excel in a meaningful way. Thank you very much for allowing me to strengthen my knowledge so comprehensively. This is exactly what I needed.

    Reply ↓

    • Hey Miranda,

      So glad that you found the site/tutorials to be useful! Getting positive feedback is what makes it all worth it.

      I started the site for almost the exact same reasons you mentioned. It’s ridiculous to go through both undergrad/grad programs without any specific Excel training required (or even offered).

      Feel free to reach out to me if you have any questions or suggestions.

      Cheers,

      Ben

      Reply ↓

  19. I previewed it first video for Excel and it looks like a very professional job. Only problem is I Can’t seem to download workbook on android phone… can you offer any suggestions?

    Reply ↓

  29. HI Ben,
    I am new at this and loved it; Thank you so much for taking the time to make these videos; they are fantastic. I have a question though. When downloaded the latest worksheet “Excel Exposure – Master Workbook [1-11-2013]” for this video, I only see sheets 1-3; however, in the “Conditional Formatting” video, you referenced sheet 12. How can i get to the sheet that is using in this video to practice along your tutorial?
    Again, thank you so very very much…
    Kim

    Reply ↓

    • Hi Kim,

      The spreadsheet should open to a table of contents which has links to all of the sheets. There are definitely more than 3, but maybe you need to use the right arrow symbol in the bottom left hand corner of excel so that it can scroll through the sheets.

      Here’s a screenshot with it highlighted in yellow:
      http://i.imgur.com/4UhjFxa.png

      If that doesn’t work, feel free to email me.

      Ben

      Reply ↓

  32. You are awesome, thank you so much for your help! The time you have invested in putting this together and the fact that you are not charging for these tutorials demonstrates your true nature. Thank you!

    Reply ↓

  36. I just wanted to say thank you. I am interviewing for an analyst job and I know some of excel or I should say that anything I needed to know I learned on my own. but you have made it much easier.. I will be back again and again… Thank you.. P.S. you have a nice voice..

    Reply ↓

  43. Hi. Got a shortcut that’s not on your master spreadsheet.

    Hold SHIFT then hover the mouse over the fill handle. The cursor will change shape to two parallel bars with arrows pointing up and down. Select the number of cells you want to insert and it will shift the selected cell down accordingly. Yes, you can do this with selecting a range, then CTRL++ then selecting Down. This just does it in one step.

    Reply ↓

Post any comments, feedback or questions below!

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out / Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out / Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s