**Learn Excel Online**

## Improve Excel Skills with Free Online Training Course!

Since the** Excel Course Lesson Plan** on the home page has the videos grouped into categories rather than complexity, I thought it would be important to provide a recommended Lesson Guide for watching the videos and tutorials. I’ve tried to group them into Beginner, Intermediate, and Advanced (based on complexity). More importantly, they are ordered in the way that I feel would be most effective for learning Excel.

If you plan on going through the entire course, I would recommend watching them in this order. All lessons are video tutorials unless specified, with the total video time next to each link.

Make sure to download the **Master Workbook **to follow along with the lessons!

**Beginner Lessons**

**Beginner’s Introduction to Excel**[19:44][08:06]**Basic Formatting Techniques**[13:53]**Math & Statistical Functions (e.g. SUM, AVERAGE)****Date & Time Functions (e.g. TODAY, MONTH)**[13:25]**Text Functions (e.g. LEN, CONCATENATE)**[14:34]**Group / Ungroup Rows & Columns**[Non-Video]**Alternative to Merged Cells (Includes Removing Gridlines)**[Non-Video]

**Extract List From Data With Duplicate Values Removed**[Non-Video]

**Intermediate Lessons**

**Logical Functions (e.g. IF, AND)**[14:56]**Lookup & Reference Functions (e.g. VLOOKUP, MATCH)**[14:04]**Absolute and Relative Cell Referencing (i.e. the $ sign)**[07:44]**Naming Ranges and Cells**[09:58][08:54]**Data Validation with In-Cell Drop-Down List****Conditional Formatting**[09:11]**Introduction to Pivot Tables**[06:57]**Advanced Pivot Tables: Round 1**[08:18]**Advanced Pivot Tables: Round 2**[11:19][06:34]**Auto-Filter and Advanced Data Filtering****Creating and Designing Charts (including Sparklines)**[14:48]**Error Checking and Data Monitoring**[16:52]**Introduction to Tables**[Non-Video]**What-If Analysis**[Non-Video]**Protecting and Hiding Information and Formulas**[Non-Video]

**Advanced Lessons**

[09:44]**Information Functions (e.g. CELL, ISNUMBER)**[07:28]**Formula Auditing & Formula Evaluation****Advanced VLOOKUP Examples**[14:36]**Advanced INDEX & MATCH Lookup Examples**[09:40]**Five Powerful Excel Tips**[15:19]**Introduction to Macros & VBA programming**[13:08]**Learn by Doing: Intro to VBA via Adding Charts Example**[Non-Video]**VBA Macro Walkthrough #1: Purchase Order Generator**[17:28]**VBA Macro Walkthrough #2: Message Encoder & Decoder**[16:51]

**Excel 2013**

**Excel 2013: In-Depth Preview**[15:29]**Excel 2013: Data Model Tutorial**[Non-Video]**Excel 2013: Real World Examples of New Functions**[Non-Video]

how to consolidate large data? with sub-total and grand total

Dear I need Your help.

i have a query in excel.

if A=B the value come from c. but if A not equal to B, but if cell A and B contain any value from below list then value also come from cell c.

list:- skt, lyp, lhe, khi

example:

A = SKT

B = SKT

C = 10

it is easy FORMULA =if(a=b,c,””)

but if

A = SKT

B = LYP

C=10

Both value are from list. therefore result should b c.

FORMULA:??

kindly advice formula if possible.

looking for helpful response

=IF(A2=B2,C2,IF(I2=1,C2,” “)) then in I2 nest the IF for your list

case1= a=b result is C

case2= if a and b both contains an element on the list

to do that let column E be list

Column E = E1{q}, E2 {w} E3{r} E4{t}

Method 1

let Column G be if A contains the list 1 if true otherwise 0

let Column H be if B contains the list 1 if true otherwise 0

IF (A=E1, if true result 1, IF(A=E2, 1 , IF( …. so on ,1, if false 0))))

Disadvantage is that you cant drag down copy the formula and E1:EN should be retyped

Method 2

IF (A=”string of word in the list example: SKT”, 1, IF(A=”q”,1,IF(……. ,1,0)))

Disadvantage changing the List on the column would not affect this formula therefore deemed permanent unless re type in the cell where the formula was typed.

WORKS WITH BOTH METHOD AFTERWARDS

Let I be the result of G and H with Fx

=Product(G,H) would only return 1 if both A and B contains elements on the list

any number multiply by 0 is zero therefore both need to be G=H contains{LIST}

SUMMARY: IF A=B answer is C else if I=1 which means both a and b have an element on the list answer is C, else otherwise print this “text”

=IF(A2=B2,C2,IF(I2=1,C2,” “))

https://imgur.com/a/UsYOF excel screenshot

hello. these lessons have been very helpful! However, I am not able to download the Master Workbook or any other of the suggested materials to follow along and practice. And you have mentioned in one or two videos reference to other videos, but have not seen those videos yet. Is there any kind of order to the videos, to help them make sense, or is it a catch as catch can kind of thing? Thank you for your help!!

Hi Teresa,

What happens when you try to download the Master Workbook from the site?

There is certainly an order to the videos, grouped by Beginner, Intermediate and Advanced above.

Can you let me know what specifically is tripping you up?

Feel free to email me at Ben@ExcelExposure.com if that’s easier.

Cheers,

Ben C.

so im struggling with my data set and this sexy voice comes for help haha!!

Hey,

Could you also suggest any platform to revise/practice these skills?

PS-It’d be awesome if I could find it on this website as the lessons are amazing here

https://www.modeloff.com/questions/ is a great resource. Most of the questions are well over my head, but they also provide the solution workbooks showing formulas and steps.

Thank you so much for this reply Patrick. You don’t know how helpful it was/is.

Hey there,

your lessons are truly amazing, but other than learning all this stuff, i also needed to practice, could you suggest any website or add something on?

Thanks

hi

Hello Sir…..m really really thankfull to ur work…….and dedication…….

i am not able to download the master book sir…i dont know what to do…plss help me with this…

Hello Sir,

This is really awesome.

You’ve done a great job. Appreciate your efforts..

Best wishes for you.

Hello Sir,

This is a great effort by you. Really appreciate your great initiative for learners.

Best wishes for you.

Really helpful 😊 thanks lot

This is great! I’m currently in between jobs and have been looking for something to brush up on my administration skills. The downloadable workbook is fantastic. Thank you for making this so easy to go along with.

Hi Ben,

Can I use this for my 11th grade High School homeschooled daughter? Thank you! Terry

I replied via email, but yes! The course is for people who’ve never used Excel so I’m sure she’ll be fine. Let me know how she does with it! 🙂

I love this detail of excel in very beautiful manner with easiest way…Now I’m learning from this channel only it’s very helpful. thank u for making these viedos.

Thank you very much for your positive words! 🙂

Hi Ben,

Thank you for this excellent guide to excel. I found the videos (watched 90% of them) extremely helpful and clear. I must say, your videos are one of the rare tutorials that don’t lose me after 20 seconds 🙂 Great work. Thank you.

All the best,

Salma

Nice and complete. Thanks a lot for doing this.

Hello and welcome to the members-Kindly make it convenient to deliver free excel all era posts on daily basis including lessons guide and training purposes.Thanks

Best Wishes Imtiyaz Khan

cool

Thanks Ben! I am totally clueless when it comes to the dark arts of Excel. Did your beginner video. Afterwards I could replicate everything 🙂

This is great! Thank you !

Hi I wanted to join this course plz tell me what is the procedure.

I tried to download the workbook on my computer and my phone but can’t open it up on either. Any help you could give would be highly appreciated!

Thank you very much for this. I really appreciate your time and the effort that put in these videos to help us.

Hello,

I need complete excel

Want to excel in excel

Suggest pls….

you are the man. thank you

When I try to select and sum a column, what appears is: #NOME (Portuguese) and no summing up

You need to specify the range of cells you want to sum i.e.

=SUM(start cell, end cell)

Make sure you add the ‘(‘ after =SUM to get the option to select the range on your page.

Thanks Ben! Your lessons were very helpful, from the beginner to the advanced. Even if I knew the topic beforehand, every lesson had a new helpful trick to enhance my skillset. Practice exercises would definitely be an added bonus.

Thanks so much for your time and expertise! May you be blessed continuously for your help and generosity. 🙂

i am fresher to study for excel. But i want to study the excel.Please teach me about the excel . I can’t effort the class of the payent and i have a mobile device .So, teach me my teachers.

The video is so helpful. It help even a basic learner to understand completely. Great job sir.

Thank you so much for uploading such great videos. They have helped me a lot!It would be great if you can upload some practice exercises which would help us to understand how to apply the different functions while working on spreadsheets.You can make different exercises for beginner, intermediate and advanced levels.

Great content, thank you so much!

Hello, I just wanted to know if you’ve designed a course based on Microsoft word.

Fresh out of college, starting a job next week. Your videos have saved me time and money. Extremely helpful and I thank you for all of your hard work you put into this.

I really like to stary with the beginner course in excel.

Thank you so much this is very kind of you

Great tutorial Ben!

冒险岛服务端奇迹mu服务端传奇外传服务端风云无双服务端神迹服务端

跑跑卡丁车私服开服英雄远征私服开服幻灵游侠私服开服洪荒神话私服开服

英雄王座travia开区一条龙暗黑修仙开区一条龙仙境传说ro开区一条龙弹弹堂开区一条龙

天龙八部开私服一条龙服务 http://www.e7if.com/

Hi Ben,

I am really thankful to you for the information. God bless you

awesome stuff, saved my bucks.

Thanks Ben.

Which website are you referring to

Thanks Ben, verry helpful

Hi Ben,

Its really a wonderful stuff you had put in and I really glad that I came across this website, there are so much to learn and I am sure that your videos will help. Thanks for all the videos and hoping for more posts and updates.

Cheers,

Santhosh

Hallelujah! Thank you Ben!!

This site is amazing. Excellent videos. Thank you!!!!!!!

Athena 7-Minute Lift anti agiing serum offers a way to look years younger in a matter of minutes.

Use a positive outlook and specific, but realistic goals at heart for enhancement of

your respective visual appeal. It is able to stimulate tthe growth

of your natural collagen and elastin, which will build your stores back up to where they wefe years ago.

Hi there,

Until today I was self-taught, very slow process, trying to keep up to speed with documents I’m managing for my volunteer organization. You have clarified things so much for me and helped me to be much more effective! I’m looking forward to progressing through many more lessons in order to use Excel to its fullest! Wonderful lessons, well-taught, very thorough! I will be recommending this site to many others.

Thank you,

Ellen

Hi Ben, and others,

I’m looking at entry level accounting positions and this has helped me tremendously. How would you guys recommend adding that I’ve done this course on a resuem?

This site has been very helpful. I have never had to be a heavy Excel user and my new position requires a lot of Excel work. I am working through, and need, all the lessons. have this site bookmarked at work so I can grab a tutorial whenever I need.

Thank you Ben!

By taking a certification test. http://www.microsoft.com/learning/en-us/exam-77-882.aspx

THIS IS AMAZING. I’m starting a job where I need to be pretty proficient in Excel, and I wasn’t, until now. I will definitely be bookmarking your site on my work computer! Thank you, Ben!

I have been looking for learn some advance excel function for months, this is a great website, thank you sooooooo much!! Very useful information!

Thank you so much ben for this awesome website.I was away from Excel for many years and almost forgot everything but you saved me now!

Awesome lessons! Awesome videos! Awesome explanations! This is priceless!!! Thank you!

This is so incredibly helpful I can’t thank you enough. If you aren’t a teacher, you really should be.

I absolutely agree. Thank you, Ben, for helping us so much!

agreed

I always had!

trouble learning how to use Excel properly and how to set up Pivot tables but you have made learning easy! Thank you so much

hi.it’s such a good educative tool. thank you very much.

Many many thanks for all your Excel videos! I’m a computer illiterate and never in my life thought that I could learn the basics of Excel in such a short time and in the comforts of my home + with all that flexibility!! Awesome!!

thanks a lot for the site team

Hey Raghavendhra,

So glad that you found the site/tutorials to be useful! It’s actually not a team but just myself who created & operates the site.

Getting positive feedback is what makes it all worth it.

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

Cheers,

Ben

great ben thanks.

Excellent……

Useful Data…….

Thank you so much! I love this site!

thankyou SO much, i really need to learn to use Excel. word and office to get any decent kind of job and this will help a lot. very much appreciated

Hello Ben,

Your tutorial is excellent ….. I am looking out for Planned lessons. How could I get them ?

this site is so awesome I want to marry it and have it’s babies!

be blessed,it is very helpful

These lessons are brilliant. Nice to have them organised in terms of difficulty progressively getting more advanced. Very useful reference also when I need a quick tip on a formula or a technique i have forgotten about. This is a real help for me as a finance analyst!

Very well done! Thank you so much

you saved my life with these videos!!! I have a job interview in a few days and did not read the job description properly and it said must be proficient in excel, i have used excel but that was years ago and forgot almost everything, so at least now when I go for my interview I can say it’s been a few years but I’m re teaching myself. THANK YOU!!!!

really very helpful lessons for me, thanks 🙂

waht understood you?

Really good work mate, I spend all my free time at work looking at these videos as much as possible. Cheers!

Thank you for doing this, I am very this really helpful

its really help ful thanks

Ben,

I truly appreciate the amount of work you have put into this. This is very clear and organized. Cheers!

In fact, I recently bought a course on MS Excel, but the quality of this course is way higher than paid course both in terms of quality of content, presentation, and organisation. It is indeed an excellent resource. I present my sincere appreciation to the creator for producing a highly organised and very effective course. Thanks a lot.

I really appreciate you posting this tutorial ! This is very beneficial , Have a blessed day!

Hello – again, excellent sessions. You mentioned you might be rolling out a third lesson around pivot table functionality. Today I discovered ‘slicers’ – pretty cool stuff. You might want to include in future pivot lessons. Thanks again.

Can you take beginners,intermediate and advanced or do you choose one level?

You guys are doing a wonderful job. I’ve been yearning to find a right place to learn excel and here am I. Thanks a lot!

Hey mate, Do you have anything of microsoft access?

Hey!

As much as I would love to be able to do other products, I currently only do MS Excel 2010 and doubt I would be branching beyond that due to time constraints and work. Any other project like that would really take away from my ability to keep up with Excel Exposure.

I’m sure there are some useful resources online though, and I hope you never stop wanting to learn!

Cheers,

Ben

How to download the videos?