Master Workbook

Excel Exposure’s Master Workbook

Course Material and All-in-one Excel Cheat Sheet

Here is a link to a file I created specifically for the Excel Exposure course 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, 2013 and 2016, although the videos are recorded in MS 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 7-26-2017

Tip: Be sure to click ‘Enable Editing’ in the top yellow bar if you see it. Example below:
master-workbook-enable-editing

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

137 Responses to Master Workbook

  1. Roz says:

    Wow! Awesome work, Ben! Really appreciate your hard work. Thanks very much for putting this up 🙂

  2. Rohin says:

    Well !!! seriously I appreciate your efforts and hardwork. Fabulous work !!!

  3. Steve says:

    You are awesome.

  4. Subhash says:

    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

  5. Subhash says:

    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

  6. Radhika Kotian says:

    very good video, plus your explaining skills are amazing:)

  7. Anonymous says:

    amazing video:)

  8. John Macharia says:

    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.

  9. Stephanie says:

    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

  10. Choli Dasanayake says:

    Thank you so much Ben. I learnt so much from you. Great work! Bless you.

  11. Chinal Jain says:

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

  12. Anonymous says:

    Good Bless you as you reach out for people… Thank you for your free course. Its a life time help.

  13. Angel says:

    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.

  14. Jon says:

    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

    THANK YOU

  15. Francisco Cabrera says:

    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!

  16. Anonymous says:

    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

  17. Ramona Dan says:

    Hi, I have a problem downloading the workbooks. I have Excel 2016, is this one of the reasons?

  18. Dynamic Mawunyegah Akakpo says:

    Thanks very much. I am ready to undergo the excel training with you.

  19. Karen says:

    Thank you for this training. i am impressed. I have shared this file with my team as well. God bless you. amen

  20. Atul Sharma says:

    Great Work!! Thanks a lot!!!

  21. Rahul Modi says:

    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

  22. Cris says:

    Thank you so much for sharing your knowledge. You’ve help so many people. Thanks again.

  23. Anonymous says:

    Wow!! Thank you so much for this! This is so useful, I will be sharing your site with my team at work!

  24. Sarita Kadam says:

    Thank you So much for the sheet , its very helpfull for me and my new current job. Thank you : )

  25. erika says:

    this is amazing!well-explained, well-presented, very useful. Thank you very much!

  26. Anonymous says:

    very usefull

  27. Anonymous says:

    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!

  28. Manish Gupta says:

    You are the best Ben, Loved your work… A fan now

  29. Anonymous says:

    good notes

  30. jaypogi says:

    Thank you!! you have no idea how grateful i am THANK YOU!

  31. oohlalavie says:

    Wow, thanks! So easy.

  32. Jacky says:

    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.

  33. Deco D. Y. says:

    I want to learn excel software in line with my profession (Accounting).

  34. Anonymous says:

    Wow you are so easy to understand. Great work.. thank you for sharing.

  35. Noel Xavier says:

    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

  36. Anonymous says:

    A VERY COMPREHENSIVE WELL THOUGHT AND EASY TO LEARN PROCESS WELL DEVISED. THREE CHEERS. IT WAS A GREAT HELP

  37. Demin says:

    Great work! May Triple gem bless you!

  38. Anonymous says:

    THATS VERY INFORMATIVE

  39. Anonymous says:

    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 ,

  40. Anonymous says:

    this is very awesome….and easy to follow. Thanks

  41. Sibi Sarat says:

    Thank you a million times. Your presentations are so nice and easy to understand.

  42. Diya says:

    I needed to refresh my excel skills,your website was very helpful. Thank you very much!

  43. merlin says:

    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!

  44. Mariah says:

    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.

  45. Anonymous says:

    Hello, the link for the masterbook it’s down, it’s any other way to get it?

    Thank you in advance.

    Regards!!

  46. Anonymous says:

    good job
    very helpful

  47. Olawale Olusola says:

    wow, i can recommend this site for anybody, but please can we a get a pdf version of this tutorial?

  48. MarY Kay Lyons-McDonnell says:

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

  49. Kendra says:

    Awesome tools. Thank you so much. Do you have a test we could try

  50. Anonymous says:

    Good job Ben I’m Learning

  51. Brian Zonke says:

    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.

  52. Anonymous says:

    Thank you so much for doing this!

  53. Anonymous says:

    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

  54. ravi says:

    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

  55. mohsin hassan says:

    very useful…. I’ll recommend my friends to take advantage of these lessons

  56. Anonymous says:

    very useful .. I’ll recommend my friends to take advantage of these lessons

  57. Kristina says:

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

  58. Syeda Sajjad says:

    You are a legend!! I always struggled with excel but your explanation changes it all. Thank you 🙂

  59. Hareesh Kumar Kurapati says:

    Very Awesome work – Ben.

  60. options binaires en ligne says:

    It’s an remarkable paragraph in support of all the web users; they will
    take benefit from it I am sure.

  61. Brayden says:

    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!

  62. Anonymous says:

    wonderful thanks

  63. ACE says:

    Just want to say Thank you…. I wouldn’t have known what to do without it….. Much appreciation!!!!

  64. James says:

    Absolutely incredible resource to learn from. Wish I had more to offer than just a simple, ‘thank you!’

  65. vipin says:

    Hi Ben,

    Thank you very much for your excel master workbook. It really helps. Really appreciate your gesture.

  66. seo rankings says:

    Excellent site. A lot of helpful info here. I’m sending
    it to some buddies ans additionally sharing in delicious.
    And naturally, thanks in your effort!

  67. Saqib Hussain Lohar says:

    Assalam Aliakum
    Ben I found your tutorials helpful , Thanks
    Hope you ‘ll keep it up

  68. Steve says:

    You Rock!

    Thanks so much; I have Excel-phobia and really need this to substantiate the value of my income.

    Peace & blessings!

  69. Les Rivard says:

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

  70. Anonymous says:

    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.

  71. Himanshu Kalia says:

    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

  72. Anonymous says:

    thanks a lottt…..

  73. chandu says:

    thanks a lot,may god bless u dear………………….

  74. Anonymous says:

    Thank you so much for all tutorials!!!! You are my excel-rescue!

  75. Anonymous says:

    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.

  76. Anonymous says:

    Thank you for putting this together. It is a great tool!

  77. Ana says:

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

  78. Laura says:

    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.

  79. Marsha Grant says:

    AWESOMENESS IN EVERY BITE. Thanks for saving my life.

  80. Sara says:

    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

  81. Anonymous says:

    this is so useful. Thank you for the effort. I just can’t wait starting learning now.

  82. Ana says:

    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.

  83. Reji says:

    Amazing work Sir….It was indeed a great effort from your side…Thanks a lot

  84. Sharath says:

    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.

  85. kartik says:

    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

  86. Cari says:

    I have been trying to learn excel for years. Thank you so much for your free program.

  87. Anonymous says:

    You have no idea how helpful your work is to those of us not familiar with Excel. Cannot thank you enough!!

  88. Miranda Boydstun says:

    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

  89. Appreciative Dude says:

    Just want to add my thanks for the work you guys have done. Also, it looks like Excel 2013 will keep you busy with a lot of very cool new features !

  90. bonz9er says:

    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?

  91. Eric says:

    This is so useful, thank you so much 🙂

  92. Anonymous says:

    thank u sir u r amazing

  93. Priyanka Gupta says:

    Amazing, thanks a lot. Would it be possible to give some kind of tests to check our level of understanding..

  94. Anonymous says:

    You are so generous ! Your good job cannot be appreciated enough. Thank You.

  95. Anonymous says:

    I love to appreciate this great effort.Thanks anyway

  96. Peter says:

    Whew! Sure made my day a lot easier! Kudos!

  97. Romana says:

    Thanks man 😀 YOU SAVED MY LIFE

  98. Anonymous says:

    I can’t open the workbook it says file corrupted!! 🙁

  99. Anonymous says:

    Really helpful…thanx

  100. Anonymous says:

    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:
      http://i.imgur.com/4UhjFxa.png

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

      Ben

  101. Swayn says:

    This is inspiring!!! Thank you!

  102. Aneesha says:

    this is worth a million dollars!! thank you so much !

  103. Coleen Adderley says:

    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!

  104. Anonymous says:

    Thanks! You make learning this easy

  105. Sayed Masood says:

    i would like to say thank you so much

  106. helen says:

    Very very resourceful site…Thank you

  107. Linda says:

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

  108. Anonymous says:

    goot excel work

  109. Zaheer Abbas says:

    You are doing a great job to learn excell in good way please keep it up

  110. Email says:

    Thanks for the work and sharing… You are awesome…

  111. AMIT KUMAR says:

    Thanking you Thanking you Thanking you Thanking you

  112. Anonymous says:

    This is a blessing. Thank you so much.

  113. Anonymous says:

    Great job! Really appreciated ! God bless you and your generations ever and ever!

  114. ninjagrover says:

    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.

  115. Victor Johnson says:

    Great excel file! thx!

  116. Love it thank you for the sheet

Leave a Reply