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-2014]

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.

73 thoughts on “Master Workbook

  1. I running into an issue where a lot of the video tutorials aren’t matching what I’m seeing in the master workbook 4-30-2014. The examples are either already completed or the data has been changed entirely (e.g. the vlookup video that references video game scores on the pivot data tab. My pivot data tab shows orders. ) is there an older version of the workbook somewhere or an uncompleted version that can be followed along with?

    • Thank you very much for pointing this out for me. I’ll try to set aside some time soon to add a Before/After version to make sure both the starting point, and ending point are included in the workbook.

      I hope to have something on the site within the next week or so. Sorry for the delay and hope it doesn’t hinder your learning too much.

      Cheers,

      Ben

  2. hi ben and I have a query i have a table of pin codes and in another sheet i received the location and whenever i try to use index and match it’s works but not in a correct way because when i drag the formula it shows wrong location pls help me out
    sheet-1 sheet-2
    799001 AGARTALA Delhi
    799002 chennai Agartala
    799003 delhi chennai

  3. This is amazing! I feel I am at an intermediate level but there is always so much more to learn. I cannot thank you enough Ben! My brain wants to absorb more and more!
    Your lessons are clear and easy to follow. Really, did I say thank you?!

  4. You’re so awesome! I do not believe I’ve read anything like that before.
    So wonderful to find another person with some original thoughts
    on this subject matter. Really.. thanks for starting this up.
    This web site is one thing that is required on the internet,
    someone with a bit of originality!

  5. I’m impressed that you would take the time to provide such a detailed course. My work requires that I work in Excel and actually create from time to time. Thank you for making this series of learnings as I will be navigating through them from now until I get a hold of this amazing program. You have done what other courses costing serious cash could not do.
    Thanks Ben!!

  6. Wow is all I have to say. I was looking for exactly this training. Thank you so much Ben. I needed to learn Excel for a new job and you have given me the training i needed.

  7. Hi Ben

    Awesome work, it explains each and every aspect very clearly and in a detailed manner.

    Love your work. Thank you very much.

    Himanshu

  8. 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.

  9. 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!!!!

  10. 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.

  11. 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

  12. 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.

  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.

  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

  15. 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.

    • 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

  16. 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?

  17. 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

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

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

      Ben

  18. 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!

  19. 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..

  20. 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.

Post any comments, feedback or questions below!

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

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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s