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.  The workbook should work as intended with Microsoft Excel 2010 and 2013, although the videos are recorded in Excel 2010.  For those with Excel 2003 or earlier, there is an alternative .xls version at the bottom of this page.

Download here: Excel-Exposure Master Workbook (1-20-17)

Be sure to click ‘Enable Editing’ in the top yellow bar if you see it. Example below:

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 an older Excel. 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 easier using Excel 2003 and earlier.  Most of the information will still be relevant.

134 thoughts on “Master Workbook

  1. Thanks for giving good exposure on excel if along with this attachment of raw data and objects and final solution is given will be more helpful

  2. Thanks for giving good exposure on excel if along with this attachment of raw data and objects and final solution is given will be more helpful

  3. Thank you so much Been I have really gained more than even what I learnt in college,if there are more lessons on QuickBooks, Tally web design and other business software applications please update me,Nice work n God bless u.

  4. My boss has emailed me an excel sheet which I need to put in a file on my desk top how do I do that.
    Also the month of aprils sheets need to be transferred to a file ready to email firstly how do I put them in a monthly file then how do I attach to an en
    Mail HELP before Monday thank you

  5. Thank You. I really like the way you guide. Its working like a helping hand. I finally get something which I actually looks for learning excel. Superb Sir !!!

  6. I am a beginner and trying to learn excel then I stumble to your website. Your website video tutorial is amazing. It is very easy to understand especially if you are a beginner. Thank you very much for you time and effort for putting this all together. More power to you and please continue the great work.

  7. Hey Ben
    I just recently starting to teach myself excel to make myself a more valuable employee. Just wanted to say that your videos are extremely helpful, well spoken, and very well laid out.
    Very informational without a lot of random filler


  8. I am using Excel Online (the free version you can use on web browsers), but I can’t open the master workbook. I get an error message that says the workbook cannot be opened because it uses an unsupported feature called Watch Window. It would be awesome if there was a version of the workbook that was compatible with Excel Online!

  9. I am glad to be your student, a million thanks to you,
    As you gave me the strength, to make my dreams come true!

    Thanks & Regards,
    Vijay Jadoun

  10. Great work….i learned lot of things from your video and this excel file also help me because for practice i don not require to make own data. Really great work ,,,,,thank you so much

  11. Thanks a big help needed it for work you make you tube videos look like garbage this helped me in an easy formatted way thanks so much!

  12. I am looking to understand the IF formulas and alot of items I never have used because I taught myself and picked up odds and ends from others along the way.

  13. Hi can u please help me I’ve undergone a major brain surgery to remove a blood clot in brain after getting it removed m paralysed on left side wheelchair bound together with to my Microsoft office skills excel got erased need to b trained from home in order to b employed again don’t even know how to send emails old help a disabled man

  14. I thank you for Excel , Because I just got my Diploma in Medical Office Billing and Coding Specialist, I need to know all able Excel and how to work with spreadsheets ,

  15. I’m a beginner and have never done excel . Your lessons has given me a start up to learn and pursue later some job involving doing spreadsheet. Thank you mr. ben. You’re great!

  16. I am trying to compile a master spreadsheet to reflect changes in all other linked spreadsheets so that I don’t have to go into each one and make changes separately. Is that possible? I can’t seem to find a definite answer anywhere.

  17. I needed a refresher course and this worked perfectly Thanks so much. I will be using this blog for future trainings. Have an awesome day!!

  18. Hi Ben
    I, like most people that have posted comments here, would like you to know that your work is very useful. Thank you very much. Beginners like me have somewhere to go for information as we take our very first steps in understanding excel.

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



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

  21. 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?!

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

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

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

  25. Hi Ben

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

    Love your work. Thank you very much.


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

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

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

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

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

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

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

    Thanks in Advance

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



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

  35. 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…

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


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

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

  38. 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: Logo

You are commenting using your 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