Lesson Plan

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 received the 2016 Microsoft MVP Award for Excel in April 2016, the fourth year in a row! Thanks so much to all of you for making the site such a success!

Interested in booking an Excel Exposure Corporate Group Boot Camp?
Email me for more information!

Most Recent Posts (see Lesson Guide for full listing in order)
Excel 2016: IFS Function
What-If Analysis
Protecting and Hiding Information and Formulas
Learn by Doing: Intro to VBA via Adding Charts Example
Excel 2013: Real World Examples of New Functions
Error Checking and Data Monitoring

Workbook & Reference Related (Video Lessons)

Function & Formula Related (Video Lessons)

Macros / VBA (Video Lessons)

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

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

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.

Add to RedditAdd to StumbleuponAdd to FacebookAdd to TwitterAdd to Del.icio.usAdd to BlinklistAdd to TechnoratiAdd to Yahoo BuzzAdd to Newsvine

231 thoughts on “Lesson Plan”

  4. I’ve had a look but cant find any lessons on doing Percentages%, is this something you have done and if not something you will do?

    Reply ↓

  6. 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 received the 2016 Microsoft MVP Award for Excel in April 2016, the fourth year in a row! Thanks so much to all of you for making the site such a success!

    Reply ↓

  7. Would love to learn how to use excel. Is there any recognition with this online course as im trying to move up in work and need this behind me

    Reply ↓

  12. Hello sir,

    I interested in learing MS EXCELL online programe could you please give me the details for joining the programe classes.

    Reply ↓

  14. 1. I want to know the difference between two date and time, following is the format:

    Say two cells a1 & b1, a1 = 09/16/2016 T 06:11:37.924 and b1 = 09/16/2016 T 06:11:37.924

    2. from above example i want to separate date and time in two different cells.

    Reply ↓

  29. I’m very interested in learning all about Excel because a lot of warehouse jobs I’m interested in require knowledge of this specific program. Please email me more information on how to get started.
    -Chris Navarro

    Reply ↓

    • How to calculate the hours of waiting
      Eg :
      From
      Date IN Time OUT Time
      1-Apr-16 10:20 PM 11:45 PM
      to
      Date IN Time OUT Time
      2-Apr-16 5:30 AM 7:30 AM

      Reply ↓

      • how to clculate my balance auto matically if i put cash remaining balance collect tell me process e.gMid SiM
        SR Date M.Sim Amount Cash Balance
        1 16-5-16 30 3000 200 2800
        2 17-5-16 300 ?
        3 18-5-16 500 ?
        how to automatically balance comes out?

        Reply ↓

        • What I am getting that you want to calculate remaining balance. For have to apply formula–
          Example-
          Total amount- 5000
          Expence- 940
          What is total remaining balance ??
          Formula is…
          Put = in balance cell then put bracket start ( and drage left arrow to total amount put minus – then right arrow to expence cell then bracket close ) and tab. Will automatically show remaining amount.

          Reply ↓

  37. So glad I found this site. I’ve been using excel pivot tables, formulas, and QA processes for a while but I’m slowly realizing the power of VBA. Looking forward to leaning in to your lessons.

    Reply ↓

  38. Dear Sir,

    I am Prasad. I got a query!

    I need to record Intime and Out time of Staff. When I enter in in time cell, Out time should Automatically calculate and get reflected in the out time cell without any further entry in the out time column. Is there any procedure Sir. If so please share me in the form of PPT please

    Reply ↓

    • Dear Sir,

      I am Prasad. I got a query!

      I need to record Intime and Out time of Staff. When I enter in in time cell, Out time should Automatically calculate and get reflected in the out time cell without any further entry in the out time column. Is there any procedure Sir. If so please share me in the form of PPT please.

      Reply ↓

  39. I have an excel sheet of a company in this the persinal protective items are taken by the employees are added like cover all glasses .and from that i want to take only one item taken by all employee and create a list how can i do that

    Reply ↓

  42. There are many affiliate sites where companies have programs you can sign upp for.
    Look for products you like annd companies you have confidence in. e-commerce sites and
    all the other ways to arket on-line.

    Reply ↓

  45. I am really impress with the quality. Keep up the great work. Does it have any for word, powerpoint and access ? It will be great as I am looking for the software for a reasonable price to put on my new computer.

    Reply ↓

  46. Thanks for all that you are doing to help learners.
    I am interested in doing some of the courses that you offer in excel.
    Maxwell

    Reply ↓

  65. Founded in 1913, the German company Claas
    is a market leader in Europe and one of the biggest
    manufacturers of combine harvesters in the world.
    Some health benefits that you can get by using this device are preventing illness,
    obesity, reducing tension and enhancing the immune system.
    And, rural broadband access today is as critical as roads, hospitals, clean water, etc.

    Reply ↓

  72. I don’t have finance background, is the above planned excel course alone is enough for me to get job in finance analyst sort of roles?

    Reply ↓

  77. Dear Sir ,
    You have done excellent work for new users , I really appreciate your working.
    This web is very helpful and useful for students and practical users even ,
    Great Working !

    Reply ↓

  78. Hey,
    Thanks for all the videos.
    Just want to let you know Advanced Pivot Tables – Round 2 does not have an HD video up.

    Thanks again

    Reply ↓

  81. This really got me through there practice makes perfect cant wait to get data and information recorded too become more proficient.

    Reply ↓

  82. Seeking online line help to learn any and all I can about using Excel..My new Job is requiring it to move up in my career which I’m trying to do..I don’t even know the basic please help I learn fast.

    Reply ↓

  86. Great resource! I’m also interested in FP&A and VBA lessons and plan to refer your website to my new associate/interns at my firm. Any plans to continue development of lessons?

    Reply ↓

  89. Hi,
    I am looking for a beginners course for the excel program. I need this for my job as they use the excel program quite often. I would very much appreciate if you could help me out with this.

    Thank You
    Gail Vincelette

    Reply ↓

    • Hey Levi,

      Sorry, things have been a bit busy here as I just moved across country recently.

      I’ll try to record / get that lesson up soon, but I’m not sure exactly when unfortunately.

      Glad you like the site!

      Cheers,

      Ben

      Reply ↓

      • I’m also very interested in this lesson (financial planning and analysis and accounting). Thanks so much for all the work you put into this site. It has helped me immensely.

        Reply ↓

    • hi ,,,i am working in airline business and task primarily on annual leave processing for all pilot/cabin crew .. it is a repetitive process and am thinking of automate some of the process to make me effective thru excel. what do you think is the best excel technique to use for this application?thanks

      Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

    • 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: https://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

      Reply ↓

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

    Reply ↓

  127. 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:)

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

      Reply ↓

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

    Reply ↓

    • 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

      Reply ↓

    • 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

      Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

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

      Reply ↓

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

    Reply ↓

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

    Reply ↓

  192. 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%)

    Reply ↓

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

      Reply ↓

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

    Reply ↓

Post any comments, feedback or questions below!

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com 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 )

Cancel

Connecting to %s