**Learn Excel Online - ** Free Online Excel Training Course - Improve Excel Skills!

This free online Excel class was** **created with the goal of helping you learn Microsoft Excel. In these video tutorials I teach how to use Microsoft Excel 2010 specifically, but most of the information is applicable to previous versions as well.

I’d recommend checking out the **Lesson Guide** which lists the lessons in the ideal order for viewing, especially if you plan on going through the course start to finish. As a side note, I recently found out that I won a **2013 Microsoft MVP Award** for Excel in April. Thanks so much to all of you for making the site such a success!

**Most Recent Excel Video Lessons**

**Adding Sheet Walk-through – Accounting/Finance Related [Next Lesson]**

**Excel 2013: Real World Examples of New Functions**

**Excel 2013: Data Model Tutorial**

**Error Checking and Data Monitoring**

**Workbook & Reference Related (Video Lessons)**

**Beginner’s Introduction to Excel****Basic Formatting Techniques**

**Absolute and Relative Cell Referencing (i.e. the $ sign)****Conditional Formatting****Naming Ranges and Cells****Auto-Filter and Advanced Data Filtering****Introduction to Pivot Tables****Advanced Pivot Tables – Round 1****Advanced Pivot Tables – Round 2****Creating and Designing Charts (including Sparklines)****Data Validation with In-Cell Drop-Down List****Formula Auditing & Formula Evaluation****Five Powerful Excel Tips****Error Checking and Data Monitoring**

**Function & Formula Related (Video Lessons)**

**Math & Statistical Functions (e.g. SUM, AVERAGE)****Lookup & Reference Functions (e.g. VLOOKUP, MATCH)****Advanced VLOOKUP Examples****Advanced INDEX & MATCH Lookup Examples****Date & Time Functions (e.g. TODAY, MONTH)****Text Functions (e.g. LEN, CONCATENATE)**

**Logical Functions (e.g. IF, AND)****Information Functions (e.g. CELL, ISNUMBER)**

**Macros / VBA (Video Lessons)**

**Introduction to Macros & VBA programming****VBA Macro Walkthrough #1: Purchase Order Generator****VBA Macro Walkthrough #2: Message Encoder & Decoder**

**Excel Tutorials, Tricks & Quick Tips (Non-Video Lessons)**

**Guest Excel Lesson: I**ntroduction to Tables (by reddit user VertexVortex)**Grouping and Ungrouping Rows / Columns****Alternative to Merged Cells and How to Remove Gridlines****Extract List From Data With Duplicate Values Removed**

**Excel External Resources and Software (Posts with Links to Other Sites)**

**Excel Book and Website Recommendation Links****Excel Add-In: ASAP Utilities****Software: KeyRocket (Helps with Excel Keyboard Shortcuts)****PDF to Excel – Free Online File Conversion**

**Function Related Lessons (Planned Lessons)**

- How to Write Complex Custom Formulas Using Multiple (i.e. nested) Functions
- Microsoft Excel Help

**Workbook & Reference Related Lessons (Planned Lessons)**

- Protecting and Hiding Information & Formulas
- Advice on Setting Up Models, Worksheets, and Intelligent Data Structure
- What-If Analysis (Data Table, Goal Seek, etc) and the Solver Add-In
- Setting Up Useful Templates to Help Automate Work
- Additional Functionality & Advanced Usage of Pivot Tables
- Presentation Options For Data / Information
- Copying / Pasting Functionality (values, transpose, formatting, constants, links, etc.)
- Introduction to PowerPivot

**Job Industry Specific (Planned Lessons)**

- Financial Planning & Analysis – Techniques for Budgeting (This may be a multi-part lesson as it will go through the entire budgeting process using a fictional business).
- Accounting - Useful Excel Adding Sheet I made to assist with ticking, tying, footing, and more during my Public Accounting days.
- Financial Reporting and Performance Dashboards

**Macros / VBA Lessons (Planned Lessons)**

- Additional Macro Walkthroughs and Advanced Training in VBA Programming
- Creating User Defined Functions in Excel
- Creating your own personal Macro Workbook that you can use on any active workbook.

I have analysis your post. Nice information you done here. This information is useful to for all who is having the top quality web design. Best of fortune…

Pre School Bangalore Indira Nagar

hi Ben I Have question related to workday.intl function in this function when i need the no of workdays which exclude the holiday’s but when i got the result I’m getting its surprising this farmula does not deduct the total no of holidays date wise why is it so.

Hey, I just seen that sometimes this website shows an 403 server error. I thought you would be keen to know. Thanks

Great webiste for excel beginners.. looking forward for more advance excel lessons whica can cover more advanced , complex formulas , macros etc

Looking Forward for Accounting/Finance Related Tutorial.

Hey Ben, This is really a great help:)

Excellent website. A lot of useful details here. I¡¦m providing it to some friends and also referring to in wonderful. And of course, thanks in your sweat! https://www.accounting-guru.net/features.html

I’d like to learn more about excel.

Spot on with this write-up, I honestly feel this web site needs a great deal more attention.

I’ll probably be back again to read through

more, thanks for the advice!

-1′

Hi Ben, thanks for all the work you’ve done here. Helped improve my Excel chops immensely.

Regards

Assalam Alaikum

I am enjoying excel because of your great tutorials, really great job

Thanks

great site. congrats

as i said before this excel tutorial is pure magic:) but i really wait for accounting/finance applied excel ,when we can expect those ones?

I can’t wait to try this! I need to learn this for a job.

Add Some Examples of HLOOKUP also.

please send me to my email

This is brilliant! Appreciate the efforts. Thanks.

Hi, thank you so much for this excel free training, I am about to start a new job and I needed to brush up on my knowledge. Thank you

Thank you for a wonderful resource

VERY VERY USEFUL BEN…tHANKS ALOT

Thank you for all the time and effort you put into these videos. It is greatly appreciated!

Wonderful!

awesome course, thank you!

you deserve the award; the material is organized and you present very well too (because i found i really learn something useful from you)

thank you so much for your time and such a great free excel training program.

im interested in taking this course. i wntd learn from beginner to

master course. thnx. n great videos, keep uploading.

Great stuff! Thank you so much

Much appreciation for this great work, I was requesting if you can send me this tutorials for excel training which can be helpful to me, am Moses from Nairobi Kenya in Africa, am am a procurement student.

This Website is amazing. How can I learn job specific financial excel elements? I am a finance student and it would be great if I could learn that too.

How to lean

I haven’t been on excelexposure.com in a while, just returned today.

Hi

I’ve an issue.

I have a below data file and want to use Vlookup. But the data I want to fetch is conditional.

Company City Charges CreditCustomer Contracted

Ace Mumbai Prepaid No Yes

Pace Delhi Collect Yes Yes

Race Chennai Prepaid No No

Ace Delhi Prepaid No Yes

With regards to the above table we have n number of companies in varioud cities across the world and hence not sure how to apply a conditional Vlook up.

From the above table, I would want to know if the company Ace located in Delhi is contracted with us. Kindly note that this customer has its branches connected with us throughout the world.

Could you please suggest me some idea, would really be a big help!

Thank you!

Hey Asad,

I’ve created a working copy of the situation you mentioned. I did it using a COUNTIFS formula (which may or may not have been the most efficient choice, but it’s late and I’m heading to bed soon). Here’s the file: http://excelexposure.files.wordpress.com/2013/05/asad-lookup-help.xlsx

You could also accomplish this by using a ‘helper column’ in column A which could combine the company/city into one name using a formula like =B1&C1 which would come up as AceMumbai, and then you could do a vlookup on AceMumbai to see if it’s contracted.

Either way works, but I hope that helps.

Cheers,

Ben

Hello Ben

That definitely was a big help!

Thanks a lot dear!

This is utterly brilliant…and I haven’t even scratched the surface yet. Thanks so much.

This is the BEST free educational service site. Thank You

i have a data where the cell value a1=praveen, but the rest of details of his name like contact number, email id, location are in different cells like b2,c3,d1. i want to bring all together. pls gide how?

Ben,one word ,AMAZING! thanks for unselfishly sharing precious knowledge and helping many people! Im looking forward to plan lessons-Financial planning and analysis,hope it’s gonna be soon posted:)

Thank you so much for your website and dedication, you surely deserve the MVP prize! Glad you are safe after what happened in Boston!

Hi there I am so glad I found your website, I really found you by accident, while I was searching on Aol

for something else, Nonetheless I am here now and would just like to say many

thanks for a incredible post and a all round enjoyable blog (I also love the theme/design), I

don’t have time to read it all at the minute but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read more, Please do keep up the excellent work.

Plz I want to know how to learn exal

Congratulations! for winning/voted as the MVP – great job!!!

Ben, thanks so much and congratulations on the Microsoft MVP award! The content and examples are very very helpful and the presentation is crisp, precise. Very well deserved award!

Would like to see an example combining pivot table and macros which takes data from different sheets to create charts. Thanks again!

Hi Mr.Ben i have a query i have my monthly data plan in that i have to choose 3 maximum sales figure and as well as top 3 count i am facing a problem when i use countif it shrink my criteria it count only specfic given range and for the max when i use max fuction every time i have to hide my top 1 data after search is there any method pls help me out becouse my teacher i also doesn,t know.

ram shyam ghyanshyam

12 21 56

16 16 48

18 64 26

Great step. There are so many excel websites these days but your content especially the videos are simply awesome. I am gonna follow your video channel.

Hey. I would like to learn Financial Planning and Analysis using Excel. Could you let me know when are the planned courses taking place?

beginer excel i want to lern

i want 2 lern excel plzgive me hint

will this course prepare me for the excel certification?

it would be better for me if i had the link of vedio download.

can anybody tell where is the download link?

You’re able to download the video on Vimeo(where the video is hosted) in multiple formats. Click the vimeo icon at the lower right hand corner of a video and then you will find a download link below the video and description on Vimeo’s website.

I like the sound of your tutorial

As nearly certified prince2project manager I found out that is crucial to learn excel I hope you can help on this

Many thanks

How do I

Go to you cite

Hi Bassou,

You’re already on the site. Just click any of the lessons above (or up top where it says ‘Lesson Guide’ for a listing of videos by difficulty).

Hope that helps.

Ben

thank u sir editing this many usable things ,it makes us easy on my work

I would like enroll as well

Hey Tyesh,

Sorry but I responded to Araceli below by email, but I’ll respond here in case others are wondering:

You actually aren’t required to ‘enroll’ in order to see any of the videos/training material on the website. All of the lessons are listed in the homepage as well as the Lesson Guide (which groups them in order by difficulty).

If you’d like to be listed on the student roster at University of Reddit, you can go to my course page and sign up for the course (but again, this is not required, although is good for communications).

Try clicking Getting Started at the top if you’re still unsure about the course format.

Hope that helps.

Cheers,

Ben

I would like to enroll asap!

I would like to enrol on this course please.

Hi please can I enrol on this course

How do a round a decimal to the nearest quarter.

i.e. 7.725 to 7.75

Hey Victor,

Assuming your variable that you’re trying to round is in A1, you’d use the following formula:

=ROUND(A1/0.25,0)*0.25

I tried it with some examples and it works fine.

Let me know if you have any other questions.

Cheers,

Ben

Mach doch ma auf deutsch!!!

but thanks, english is ok too :)

Been out of touch with Excel for a couple of years now, this has really refreshed my knowledge as well as learning new stuff aswell. One thing will you be covering data modelling in Excel. Predicting data, forecasting etc. Thanks

Excellent lessons!!!

I want to learn advance excel with best examples

I need to learn excel for job applucations. Help!

I would like to participate in your online excel course please.

Regards

Eloise Gale

These training modules are fantastic! I’ve been using Excel for years without really tapping into any of it’s more advanced features, and your training does a terrific job of providing quick, simple modules that are enormously helpful. Many thanks and great job!

Hey mate Ben, I would like to congratulate you for your noble work. Please keep me posted with the future topic.

Hi

I am doing simple agency business and i made entry for bills sold to my buyers in a sheet row wise 7 bills 7 rows each having ref no 1,2,3, and so on till 7. Now whenever i get payment i separate col in fornt of that ref no like ch no., chq date and amt. and i do enter the payment enrty in the same sheet. then i do bill amt – payment amt which comes to 0 hence payment for that bill is fully recd. Now today i got the joint payment for 3 bills with 5 cheques how i will do the entry i am facing problem. need your help.

I’ve got one for you. I know that there is a way to have Excel pull information from a database on the internet and to have excel update that information whenever you open the sheet, but what if you want it to pull from weekly reports? Is there a way to have Excel automatically recognize that there is a new document to pull information from and to have that information placed in a new sheet automatically?

Thanks so much for all of your hard work. I look forward to digging into the lessons and becoming more than just an advanced beginner.

nice

im interested in taking this course, but when you complete the course do u get a certificate?

of course not. Stupid!!!!

Very helpful course!!! I have been looking for something just like this for a long time. Atlast i found it here. many thanks

What a great course. I have been looking for something just like this.

Hi, got a question. How can I copy data from one worksheet to another worksheet without using a copy/paste? using only a formula..

You can refer directly to the sheet. For example if Sheet1 has all the information you want, on sheet2 in cell A1 you can put

=Sheet1!$A$1

And it will show the value that’s there, you could drag this down and across and it would show you what’s in those cells. (Now problems can come about when you start changing sheet1 depending on how it’s setup).

You can also use INDIRECT() and/or OFFSET() functions to make sure it’s always pointing to cell A1.

Hope that helps. Feel free to email me if you have further questions..

ben i try =sheet1!$A$1 its awosome thanks.

Thank you for great videos!

Ben, thanks so much for these! Skimmed and they look great, can’t wait to fully watch when I have time later this week! Cheers

How soon will the ideal order list be available? Definitely looking forward to these lessons and I’m a stickler for structured order.

Hey Leon,

Just posted the Lesson Guide, as requested.

You can see the link to it at the top of the page.

Cheers,

Ben

MUCH APPRECIATED. THANK YOU!!!!!!!!!!!!!!!!

you’re awesome man. Greatly appreciate the great post!

Man, this is really awesome. Will you be taking donations or anything? This is the kind of thing I love to contribute to.

how can a particular cell contain only 16 digits, and that also begin with zero

That would likely require custom formatting.

If you’d like to email me, I can help you more easily.

I found your instructional videos very helpful.

Very nice, the pace is excellent. Keep up the great work!

its very useful thanks a lot

LOVE this! Thank you so much for taking the time to put this together for fellow Excellers!

I have an intermediate Excel test coming soon and I am hoping that by going over all of this, it will help me pass. I thought I knew Excel until I started going over this information. This has really helped me a lot.

Thank you, thank you, thank you! :)

Thanks a lot!!!!!

i realy appreciate your Noble deed

Time to face the music armed with this great information.

Very good. I learned a lot.

Excellent lessons

This is a great website with a lot of new information regarding Excel. Great Job !!!!

keep it coming this is awesome

Very quickly this website will be famous among all blog viewers, due to it’s pleasant articles

thanks a lot !!! all the lessons were very helpful !!

Wow! very interesting and helpful site, thanks for sharing! :D

this is so great! Thank you very much ;)

Thank you for helping me improve my excel skills and knowledge! I appreciate it!

Dear Ben,

I wanna thank you for your excellent excel course! you have changed my life!

This site is awesome. Thank you so much.

Interested in your planned lessons. When may i expect them?

This is exactly what I have been looking for – thank you for providing the content and guidance

This is an amazing site !! Thank you !!!

Thanks for all the great information. Its very useful. Great work :)

how does one write an “IF Function” in excel for a range…for example, if CELL C25 was equal to or less than 1 and equal to or greater than -1, the result would be 200%. how would the IF equation be written? I tried IF(c25=-1,200%,0%)

The IF statement you wrote would only work if it was equal to -1. For what you want, I think this formula should work just fine:

=IF(AND(C25>=-1, C25<=1),200%,0%)

That formula checks to see if C25 is greater than or equal to -1 AND whether C25 is less than or equal to 1 (using the AND() function).

Hope that helps!

I like your instructions very much!! Thank you!

Thanks,

MJ

How much does your course cost? I’m interested in starting at the beginner level and advancing at least to the intermediate level.

Thanks, Jim

Hi Jim,

The course is completely free. Go ahead and click on any of the links in the lesson plan above and it will take you to the related lesson/post.

Hope you enjoy it!

Woah! very useful stuff, I am blown away. I will certainly review this over and over again

very useful one.Every body can learn excel easily using this tutorial

Thanks for all the great information, you rock!

great step,appreciate it !!!