Excel Exposure – Learn Excel Online

Free Online Excel Training Course!

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.

Update 10-10-2017: Exciting new giveaway for the new Logitech Craft Keyboard, a $200 value! Check out the Logitech Craft Keyboard Giveaway post I put up, and enter for your chance to win!

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.

These lessons are intended for everyone to use, so while I would like to add more jokes and make it a little more fun, I have to make the lessons accessible to non-native English speakers.  Feel free to reach out to me with questions or suggestions via the contact page!

Before watching the videos, make sure to download the Master Workbook to follow along!

Newest Lesson: Introduction to Power Pivot (8/28/2017)

Workbook & Reference – Video Lessons

Function & Formula – Video Lessons

Macros / VBA – Video Lessons

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

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

320 Responses to Excel Exposure – Learn Excel Online

  1. Jeff says:

    I think this is the best excel refresher out there. Thanks so much for your time and dedication.

  2. Fede says:

    Hello I’m really happy to find this site!

    Now I find myself eager to start!

    But I wonder, am I going to need anything else than my computer with excel, I this practical o merely theoretical?

    Thanks,

  3. Erick says:

    Hello. Thank you for putting time and effort to create such a brilliant work. Could you please advise when you will release the planned lessons? I can’t see to see your fantastic work.

    Thanks
    Erick

  4. Nitin Khapardey says:

    Hello , Thanks for this course. Can you please tell me how to calculate mass, volume and density in spreadsheet?

  5. Sheila Mealer says:

    I am so excited that I found this web site training. My manager is grooming me for an advancement within my department and using excel is an important part. I can’t wait to get started, and get started on my new adventure.

  6. Rachael says:

    This is exciting I want to practice what I learnt and improve on my career

  7. Frances Pitt says:

    I am very interested in this excel program

  8. imran khan says:

    how we can use comas ” in excel

  9. Britteny Farmer says:

    Hello –

    I’m excited to start learning the excel program. This is opportunity will open many more doors for me in my career. Thank you!

    – Britteny

  10. Bettye Gilkey says:

    As a retired corporate secretary, I’ve not kept my clerical skills current and desperately need to know Excel for employability in the marketplace. Please follow up on when class begins. Thanks much for your time and dedication!

    • cobainbc15 says:

      Hi Betty,

      Glad to hear that you’re interested in improving your Excel skills!

      All of the Excel lessons in the course are available online for free without any sign up requirements.

      I’d suggest checking out the Lesson Guide which has the lessons listed in the order they should be taken.

      Also, the Getting Started page is a good overview of how the course is set-up and meant to be utilized.

      Feel free to reach out with any other questions or suggestions.

      Cheers,

      Ben

  11. Thank you for that informations. I am an Italian Excel teacher and I found informations that I didn’t know. Thank You!

  12. Manjunath G S says:

    Your links work properly, Thank you

  13. Chiraiya Sharma says:

    Thanks a lot dear. Keep up the good work. You really are a very kind & helping person. 🙂

  14. asad says:

    its very very helpful from at my work thank you so much

  15. Donna says:

    Thank you for the information very helpful

  16. Johnnie Woolard says:

    Thank you for this valuable information. I used Excel many, many years ago but find I need more than just a brief refresher. This is going to be just what I need.

  17. Katz Vie says:

    Thank you so much 😊

  18. Lakhan popandiya says:

    Hi Ben, I have one query.. that how can I select cell in excel based on cell border…

  19. Shanthi R says:

    Your links are not working !!! It goes to “page not found tag”. I tried Advanced Pivot table-Round I and II

  20. Shanthi says:

    Your links are not working !!! It goes to “page not found tag”. I tried Advanced Pivot table-Round I and II

  21. Lawrence mutumba says:

    I want to be an excel champion. How can u help mi?

  22. Charles Watson says:

    I am not sure what version I have but it’s what was put on my Apple when I bought it in 2013. I was working with a spreadsheet. Closed it and went to file to open another one. When I click on File Open Recent there is no listing. Only more. Click on that &it goes to online templates and of course there are none. I need to know how to get to my files. Can you help?

    • Ashish Bhutada says:

      Did you the excel file before closing it? You need to save the file on your device to open it next time or see in File Open Recent.

  23. Olatunji says:

    I stumbled on this and I found it quite interesting on account of the content. My Question: I would be working with excel spread sheet for generating quotation, do kindly guide on the aspect of excel to opt for considering my job description as stated above. Thanks in anticipation

  24. Tihngang Cyril says:

    I will like to take this excel classes online how can I sign up ?

  25. Cecelyann Shelton says:

    I would like to take this free excel class. How do I register?

  26. Kausik Karmakar says:

    Dear Sir/Madam,

    I want to be a excel champion..Please help me..

  27. Mandy Power says:

    How do I register for this course

  28. Elia mpondo says:

    Good

  29. mocdstudio says:

    Thank you for sharing this useful information related to excel . Really this is awesome blog.

  30. Imtiyaz Ahmad Khan says:

    Hello to Ben C-It is incredible to have available the list of different excel era guide.A question i am not finding a solution eg as we manually work/write on cash book then as per ledger folio we find different accounts and posting it on each respective personal accounts in the ledger,a ledger containing different columns from main cash book.now how it is possible that here from main C.B master excel sheet ( not in fixed ) some specified data whether all along or in breaks also auto exist in different each personal excel sheet ledger account without the efforts of copy paste posting.besides access,data base or tally/filter,software IS there any way to do such job..Kindly intimate me about how? Best Wishes Imtiyaz khan

  31. Ahmer says:

    Dear Sir,

    Please see here below mentioned query for your easy understanding.
    I want to see the result in column E7 when i filter data in column A3

    (Column E7) Vendor Name:

    (column A3) Vendor Name
    Abdul Aziz Fahad Al Hajri Est
    Ali-Ahmed-Al-Kanfari Gen. Co. Est.
    Amtar Al-Watan Const. & Dev. Est.
    Arab Al-Tamuz for Cont. Est.
    Arkal Est. for Cont.
    Danat Al-Rayan
    Gray Falcon

  32. Mweru anslem says:

    Thanks this is so helpful, am to work in a pharmacy, but on the side of tallying on pc but I have less knowledge on tallying, please some advice, thank you!!

    • Imtiyaz khan says:

      Hello to Free Excel Training.I am new to excel,If you put the free all excel era training in a simple way as a skill booster and enable me to generate a knowledge little by little perfectly.best wishes Imtiyaz Khan

      On Wed, May 3, 2017 at 9:09 PM, Free Excel Training! wrote:

      > Mweru anslem commented: “Thanks this is so helpful, am to work in a > pharmacy, but on the side of tallying on pc but I have less knowledge on > tallying, please some advice, thank you!!” >

  33. Aarti Arora says:

    Pls snd some more information on online excel classes as. I’m very much interested in learning excel

  34. John L. Nelson says:

    I am beginner level at best, however I need immediate (urgent) help to do a specific excel task. I need to consolidate 2 columns into one, then prepare add email addresses in preparation to export to Gmail. I have absolutely no problem paying you for your help.
    John Nelson… 713-943-0083

  35. Reynaldo Mumme says:

    In other words, how can i search for forums that match what I want to read about?

  36. Anonymous says:

    how can i do make index in excel

  37. anupama tola says:

    Want to learn Microsoft excel

  38. cheryll says:

    good

  39. Curtissiz says:

    byqwevu

  40. voma says:

    How we calculate using Microsoft excel?

    • Rv says:

      apply this formula in excel spreadsheet where you want total.. Example … =sum(E1:E10) and press enter now you can get total amount from E1 to E10

  41. Anju Sreenivasan says:

    Pls details in excel online class

    • Excel VBA Tutorials says:

      Thank you for sharing this useful information related to excel . Really this is awesome blog.

  42. Debbie says:

    I can not thank you enough for these free lessons. I am a working mom with two jobs and i dont have time or money to take classes outside the home. My boss is very advanced in Excel and it was hard for me to keep up. Your lessons have been a huge blessing and has taken alot of stress off of me. Thank you so much for sharing your time and knowledge!

  43. Wendy says:

    I am interested to know more about the use of Excel and it’s formulas

  44. Hafiz Mohsin Ali Khan says:

    Hi
    I need to revised my excel with advance level my boss syed hurr recommended me this site may he live long for ever. Aameen.

  45. Jonathan Bloomfield says:

    Do you have this but for 2016 version

  46. Silambarasan says:

    Pls details in excel online class

  47. Viresh Sharma says:

    Pl detail of excel online classes

  48. Ahmed Islam says:

    Very useful and i m recommended to all accounts .

  49. Ram sandhikar says:

    Looking to learn advance excel with macros

  50. Cheryl Pilcher says:

    I need exposure to excel.but have to start at very beginning. Only one at work who’s too old to have had it in school. Age 55 and uncomfortable at work. 😞 not sure where to begin

  51. uche says:

    When to learn hw to use excel

  52. Antoinette Dauphin says:

    I need help

    • Anonymous says:

      Trying to make a booklet, when I have two pages on the screen, what do I do if I only want to change one of them without messing up the other?

  53. divya says:

    As I’m nt able to either view or download video.. can u plzz suggest me.

    • You right click on the cell and click format cell. Next on the numbers tab, select custom. In the box that says general, remove that text, and insert the following in its place: ###,###,###,###,###.#######.

      This should give you the formatting you are looking for.

  54. Vipan says:

    sir,
    how can i write a value of amount 256,258.65 in excel in lieu of 2,56,258.65

  55. Imtiyaz Ahmad Khan says:

    Hello Mr Ben and members-Self auto copy paste posting of each personal ledger accounts of specified data whether all along or with breaks not fixed way and continued process as an auto out reflection from Main master excel sheet containing a continuing data so to save extra efforts from it for copy paste posting to respective personal ledger accounts.What we write here should also auto exist in the each personal ledger/ac’s.what is way and how. Thanks with regards Imtiyaz khan

  56. Imtiyaz Ahmad Khan says:

    With regards to all the members.Kindly deliver free excel posts with training guide and expert advise to the solutions.Best Wishes Imtiyaz Khan

  57. 12p1674 says:

    Is the advanced excel course similar to the CA- itt training excel syllabus?

  58. Jo says:

    Hi for Excel 2007 which path should I follow? thanks J

  59. Rachael says:

    Hi, I just graduated with an associate degree In accounting. I would like to learn more specific to the job.

  60. Vaishali Vinerkar says:

    Hi I would like to join online course

  61. olokunboro akinsanmi says:

    pls i want to learn some basic aspects of excel and formulas

  62. Mukisa Julius says:

    I Want More Guid On Excel Training Daily Am At Work With Little Computer Skills

  63. Shelene Kumar says:

    Hi there please let me know how do I register with doing an excel beginner to intermediate courses thanks.

  64. Caroline says:

    I would like to know about the advanced Excel formating with the formulas. Can you let me know the online free course material

  65. muhammad ishaq says:

    thank you

  66. Tanay says:

    Hi I want to take an online excel course please can you guide . I want to learn all the things including macros.

  67. Dominic says:

    Hi! I need to take an online course in excel, kindly guide me,
    Thanks,
    Dominic

  68. Edith Christian says:

    Hi I want to take an online excel course please can you guide . It’s the first time I will taking that course.

  69. Kavitha t.v says:

    Good,thanks

  70. Saleh Uddin says:

    Good

  71. Anonymous says:

    Your tutorials are very helpful, i have tried several others and i had a hard time understanding them. Thanks a lot!!!

  72. Muhammad Riaz ul hasan says:

    Pl iwant to take excle basics computer

  73. Shar says:

    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?

  74. Subhankar saha says:

    I want to learn online

  75. Yanga Thetha says:

    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!

  76. Kevin o sullivan says:

    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

  77. So thankful for this website. Learning excel while traveling in Costa Rica, pretty awesome!

  78. linkirani says:

    Hiiii
    I m also interested to learn advanced excel kindly guide me sir

  79. Shad says:

    It is very useful

  80. Paulina says:

    I am very interested to take on line training of excel, please guide me

  81. Abdul Rahman says:

    Hello sir,

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

  82. Kavi says:

    I need to join plz guide. Me

  83. Anonymous says:

    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.

  84. Ananya says:

    I am interested in this training programe could you please guide me about the same. Whats is the process

    Reply

  85. Praveen says:

    I want to learn about advance Excel. Can you guide me. I am really interested.

  86. rohin says:

    i want knwlge about excel formulas lik vlookup hlookup pivots etc .with certificate .. give me info

  87. Anonymous says:

    good program for us thunk u

  88. Krishna prasad Ghimire says:

    I Need Learn More Knowledge On Excel But How….

  89. Anonymous says:

    Hi
    Want to join an online excell course .
    Please provide more information regarding the process .

  90. bina bhatia says:

    Pls provide the material where I can learn this

  91. Saijyothi says:

    Hi I want to join advanced excel training with VBA macros.

    My email id saijyothisv@gmail.com

    Do let me know the places in Bangalore.

  92. David Hughes says:

    I am interested in training could you please make download available.

  93. Anonymous says:

    I am interested in downloading videos. Could you supply the link please

  94. Amrit Simkhada says:

    I want to take this advance excel training what is the process???

  95. Cindy Cotton says:

    Hello interested in this course . Where can I get the link to download the videos? Thanks!!!!

  96. Subhodeep says:

    can you tell me from where can i download the video of the above tutorials

  97. Kevin says:

    Just wondering when your ‘Job Industry Specific’ lesson plans will be available.

  98. Christopher Navarro says:

    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

  99. I wants to learn more about excel

    http://www.excel-formulas.in/p/excel-vba-tutorial.html

    i was referring this website since i had interest

  100. Anonymous says:

    Very helpful!!! explanations are very clear and understandable. Many thanks.

  101. Akhilesh Shukla says:

    One of the best websites over the internet for excel. I would recommend to my friends.

  102. Anonymous says:

    Great Lessons, really appreciate it!!!

  103. caroline says:

    I whant to learn more about excel spreadsheet every thing step by step

    • Anonymous says:

      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

      • Anonymous says:

        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?

        • Rahul says:

          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.

  104. Ali says:

    I want to learn basic computer skill and Excel
    for my small business

  105. N.Magesh says:

    Sir I need ms excel real time course

  106. James says:

    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.

  107. JRK PRASAD says:

    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

    • Jrk Prasad says:

      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.

  108. Rijin says:

    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

  109. Yadhuraj says:

    i am interested to this lesson

  110. webi jotham says:

    Am interested for the lessons

  111. Kaitlyn McLeish says:

    Loved it. Really interesting stuff. Thanks for taking the time to write it

  112. anju arora says:

    Need your help in excel formulas, Retrieving the Column Header of the Next Non-Blank Cell in a Row

  113. Shanna says:

    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.

  114. Saah Maxwell Tosah says:

    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

  115. Anonymous says:

    update me

  116. charity says:

    im intrested plz i want to learn exel

  117. arun says:

    I want to learn basic xl

  118. mark says:

    i love this site… i need to learn too

  119. Michael says:

    Please I would like to join your classes, what should I do to get that opportunity

  120. Becky colvin says:

    I need to learn excel. I know a little. How do I get classes

  121. Anonymous says:

    great, big up!!!!!!!

  122. Gaurang modi says:

    Online Excel Training Course CD 💿 for available to advance excel..

  123. Saicharan reddy N says:

    Wanted to lean excel at reasonable price or if it is earn n learn also I preferable

  124. Juliet feitelberg says:

    Can u email me info for beginners course on excel the free course u have thanks

  125. Linda Coleman says:

    I am interested in learning more about this class

  126. Nancye Pope says:

    Interested in taking course

  127. eden says:

    Nice site.very helpful for novice like me.ill definitely go through all the videos! Thank you sir Ben

  128. Savita m says:

    I am interested in this course

  129. Luke says:

    Great! Thank you Reddit for sending me here.

    I can’t wait to see more lessons

  130. Cheang Keng Chai says:

    I would like to find out more for the excel course

  131. Lee Owens says:

    Is Your Lesson combo FREE or not? Are they available right now?

  132. Alisha Kasey says:

    I AM Interested In Taking This Class.

  133. www.celsias.com says:

    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.

  134. Shahbuddin says:

    Want to learn excel .any one can help me 9844519871

  135. yanni sarwon says:

    I want to be great at excel.

  136. Alison says:

    I need to learn excel!

  137. dawn says:

    I am very interested in this course

  138. Washington D. Dalamo says:

    I am very much interested in doing this course

  139. Gerson Thomas Willie Damaseb says:

    I want to start with the traing as soon as possible.

  140. Vj says:

    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?

  141. hamsa says:

    I want to learn exel please help

  142. varneishs says:

    I need to learn excel. Please help.

  143. Midstokke.85.Alison@aol.com says:

    I am interested in taking this course.
    Thank You.

  144. Elsie dyke says:

    Am interested thanks.

  145. Anonymous says:

    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 !

  146. Dorian says:

    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

  147. Button says:

    I need to learn more about excel. I use it often but need it for analysis purposes at work. Can you help?

  148. Prabhuram varadharajan says:

    Hi,

    I am interested in learning online course on excel. Do mail me the details.

    Regards
    Prabhuram

  149. ateasweet says:

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

  150. Tina Young says:

    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.

  151. Antay says:

    its great excel tutorial

  152. Theresa Rosen says:

    Need basic office skills

  153. Mani Seo says:

    I am from india , once i get place from here , more likee person , i am only . http://www.bangalorewebzone.com

  154. Anonymous says:

    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?

  155. chrissykovalick says:

    Need to learn fast for a job

  156. Anonymous says:

    I like ur lessons & enjoy them. thanks Naomi

  157. Gail Vincelette says:

    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

  158. Levi says:

    Very much look forward to the accounting & finance lesson plan! Any ETA on the release date?

    • 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

      • Grant says:

        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.

    • marilyn burgos says:

      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

  159. Anonymous says:

    Thanks man, this is great

  160. Anonymous says:

    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.

  161. Marl Kens says:

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

  162. Raghavendra V B says:

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

  163. Anonymous says:

    Looking Forward for Accounting/Finance Related Tutorial.

  164. Mahesh says:

    Hey Ben, This is really a great help:)

  165. mekala kumar says:

    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

  166. Laura Selko says:

    I’d like to learn more about excel.

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

  168. Sean W. says:

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

    Regards

  169. SAQIB HUSSAIN LOHAR says:

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

  170. Anonymous says:

    great site. congrats

  171. casius says:

    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?

  172. Sharon zeffiro says:

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

  173. Abhishek Gulati says:

    Add Some Examples of HLOOKUP also.

  174. kishor says:

    please send me to my email

  175. Srikanth Perinkulam says:

    This is brilliant! Appreciate the efforts. Thanks.

  176. stephanie says:

    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

  177. zubair says:

    Thank you for a wonderful resource

  178. RAGHAVENDHRA REDDY says:

    VERY VERY USEFUL BEN…tHANKS ALOT

  179. Mahmut Kaya says:

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

  180. Anonymous says:

    Wonderful!

  181. Ryan says:

    awesome course, thank you!

  182. Anonymous says:

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

  183. Anonymous says:

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

  184. rj says:

    im interested in taking this course. i wntd learn from beginner to
    master course. thnx. n great videos, keep uploading.

  185. Kevin says:

    Great stuff! Thank you so much

  186. Moses Mwangi says:

    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.

  187. Archchana says:

    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.

  188. soesoemaung says:

    How to lean

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

  190. Asad says:

    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

  191. Anonymous says:

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

  192. Ravi says:

    This is the BEST free educational service site. Thank You

  193. Anonymous says:

    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?

  194. casius says:

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

  195. fattie says:

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

  196. cehv8 says:

    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.

  197. neelima says:

    Plz I want to know how to learn exal

  198. Marivel Root says:

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

  199. MaxK says:

    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!

  200. RAVI says:

    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

  201. Kaul Ank says:

    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.

  202. Shina Gulati says:

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

  203. sana ali says:

    beginer excel i want to lern

  204. sana ali says:

    i want 2 lern excel plzgive me hint

  205. patron says:

    will this course prepare me for the excel certification?

  206. mahmud says:

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

    can anybody tell where is the download link?

    • Anonymous says:

      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.

  207. Bassou aalam says:

    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

  208. Tyesh says:

    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

  209. Araceli says:

    I would like to enroll asap!

  210. Monika Barley says:

    I would like to enrol on this course please.

  211. Laura Jayne says:

    Hi please can I enrol on this course

  212. Victor Anderson says:

    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

  213. Manuel says:

    Mach doch ma auf deutsch!!!

  214. nushig says:

    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

  215. Manoranjan Sahoo says:

    I want to learn advance excel with best examples

  216. Audrey Bennett says:

    I need to learn excel for job applucations. Help!

  217. I would like to participate in your online excel course please.
    Regards
    Eloise Gale

  218. Bob Thomas says:

    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!

  219. ajit says:

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

  220. prakash says:

    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.

  221. Beckham says:

    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?

  222. janitha95 says:

    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.

  223. shibu Purushothaman says:

    nice

  224. kandice says:

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

  225. venkat0249 says:

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

  226. JD says:

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

  227. Anonymous says:

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

  228. Quinten says:

    Thank you for great videos!

  229. Mario Reto says:

    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

  230. Leon says:

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

  231. Anonymous says:

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

  232. Anonymous says:

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

  233. Dan says:

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

  234. Anonymous says:

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

  235. Anonymous says:

    I found your instructional videos very helpful.

  236. Anonymous says:

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

  237. Anonymous says:

    its very useful thanks a lot

  238. Anonymous says:

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

  239. chip says:

    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.

  240. Michelle says:

    Thank you, thank you, thank you! 🙂

  241. Bharath says:

    Thanks a lot!!!!!

  242. Nadir says:

    i realy appreciate your Noble deed

  243. Anonymous says:

    Very good. I learned a lot.

  244. Kam says:

    Excellent lessons

  245. Jawed says:

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

  246. noob says:

    keep it coming this is awesome

  247. web data software says:

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

  248. Anonymous says:

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

  249. Anonymous says:

    Wow! very interesting and helpful site, thanks for sharing! 😀

  250. Anonymous says:

    this is so great! Thank you very much 😉

  251. Andres Lozano says:

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

  252. mefeadman says:

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

  253. Victor Anderson says:

    This site is awesome. Thank you so much.

  254. Ali says:

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

  255. Anonymous says:

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

  256. Vicki says:

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

  257. denise says:

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

  258. John says:

    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!

  259. Anonymous says:

    I like your instructions very much!! Thank you!

    Thanks,
    MJ

  260. Jim says:

    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

  261. Steve says:

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

  262. sreedevi Ranjit, bangalore says:

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

  263. Anonymous says:

    Thanks for all the great information, you rock!

  264. bishal says:

    great step,appreciate it !!!

Leave a Reply