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

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

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

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

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

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

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

Very Awesome work – Ben.

It’s an remarkable paragraph in support of all the web users; they will

take benefit from it I am sure.

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!

wonderful thanks

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

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

Hi Ben,

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

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!

Simply great! Thank you

Assalam Aliakum

Ben I found your tutorials helpful , Thanks

Hope you ‘ll keep it up

You Rock!

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

Peace & blessings!

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

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.

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

thanks a lottt…..

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

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

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.

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

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

gooding

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.

AWESOMENESS IN EVERY BITE. Thanks for saving my life.

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

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

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.

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

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.

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

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

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

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

following taking your courses are we able to pass the certification test for each level?

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 !

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?

This is so useful, thank you so much :)

thank u sir u r amazing

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

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

I love to appreciate this great effort.Thanks anyway

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

Thanks man :D YOU SAVED MY LIFE

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

I just downloaded the file, and it’s fine. You may be using an older version of Excel. I posted a version above that might work for you, here’s the section:

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

Really helpful…thanx

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

This is inspiring!!! Thank you!

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

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!

Thanks! You make learning this easy

i would like to say thank you so much

Very very resourceful site…Thank you

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

goot excel work

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

Thanks for the work and sharing… You are awesome…

Thanking you Thanking you Thanking you Thanking you

This is a blessing. Thank you so much.

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

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.

Awesome, I’ll make sure to include it in my next update.

Thanks!

Great excel file! thx!

Love it thank you for the sheet