54 thoughts on “Contact

  1. i would like to do some excel exercises while studying the course otherwise how will i know that i have learned something it looks like i am just watching the videos and than forgeting everything i learned if you could provide with some practice question with each video it will be helpful thank you

  2. Hi Ben, thanks a lot for all these great tutorials.
    – If I may ask for your help, I need an assistance with the below subject:
    I am forming a table shows that which medicine is indicated for which illness.
    The table starts from ”row 1 to row 10″ e.g. But between these rows, there could be some empty cells. For example row 4 and row 7 is empty. (These are empty because may be filled later according to future storage of the infirmary)
    I’d like to enumerate the medical items in the table on a coloumn using by number autofill technic or by another method. But I also want to ingore empty cells in the row and skip these ones. So, when i autofill, in a coloumn it should be like 1 2 3 – 4 5 – 6 7 8 (It should skip the empty cells and continue autofilling for the next row)
    Thanks for you help..

  3. HI All,
    I need Help to create a macro for IE ,but I have Issue in that ,plz help me How to Chage this code to (=2048){ this.value = this.value.substring(0,2048);}” onkeyup=”javascript:if (this.value.length>=2048){ this.value = this.value.substring(0,2048);}” rows=”2″ cols=”20″>) Excel macro.

    Plz send the macro Code for Me and i need all Macro Code For excel to IE macro.

    • =SUM(AVERAGE($A$2:$A$100,{1,2,3,4,5,6,7,8,9,10}))

      This is an array formula and must be entered via Ctrl+Shift+Enter and your list cannot contain text

  4. Hello, I am very interested in learning excel. I am a beginner and want to get started asap. From the comments I have read it has given me hope to be able to learn and use this knowledge.

    • Ben:
      How do I center the text on a page. I start it left and want to move in the center of the page. I click Center and nothing happens. Yorr 19 minute video helped me a lot.

  5. Hi Ben, The tutorial videos and the workbook are so informative. In fact, I have never come across such a comprehensive training offered by anyone, especially free of charge. I wish to contribute to this cause as you are helping us in many ways than one. Thanks for being such a blessing, and I have learnt more than the internal training that our company offers. Keep it up !!!

  6. Hello, Would you please be able to guide me as I have numerous reports coming in every day and I have to tally everything up. Could I put them all in a folder and the info can be updated automatically without me having to open every report?
    Thank you for your consideration.

  7. Firstly thank you so much for all your efforts to make Excel so easy and interesting.
    I have a question and would appreciate if you have the answer, is there a feature, function in the excel where numbers and amounts could be automatically changed in to alphabets?

    I knew that this is available in the ASAP version of 97 – 2003 office, but in English only and not a formula, in the excel we are using there is some thing but writing only one Asian language, do you know if there is any thing for Arabic?

    Thanks and Regards

  8. I need help with a VLOOKUP formula for 3 places. I have 2 worksheets in a workbook and need to get the Qty of the PO, In Stock or Qty on Hand and the Total Order

  9. Amazing! I just started a new role in my long time job doing reception/admin work. I thought excel would be easy because I’m generally good with computers and game in all my free time. Boy was I wrong, I didn’t even know where to begin with half of the things they ask me to do. Thankfully I found this, now I feel confident that I will do fine. Thank you so much! 🙂

  10. hi, thanks for your videos, really enjoying them. may i suggest you put the dates on when lessons were posted? i think it would help keep track since the lesson guide and lesson plan pages are categorized differently.

  11. Please help for formula.. for example Sheet 1
    Company Title Balance
    Company Abc 5000
    Company Def 6000
    Company Ghi 100
    Company Jkl 250
    Company Mno 2647
    Company Pqr 9895

    i want that sheet 2 when i write only company and balance the result come like this..

    company Abc Def Ghi Jkl Mno Pqr
    balance 5000 6000 100 250 2647 9895

  12. I need to write a formula that will take deposits, listed in cell G rows 1-300 and subtract withdrawls listed in lets say cell D rows 1-300 and keep a running total in say cell H1.
    I thought I had it right with =SUM(G1:G300)-D1:D300 writing the formula for cell H1 but it doesn’t work. Can you help me figure out what I am doing wrong I am using Excel 2010
    Thank you…

  13. Ben, first of all I have gone through all of your trainings except the VBA ones (not ready for them yet), and they are all wonderful. I have questions for you about naming ranges or cells. I sheet that I cut information into weekly and the length is different each week. In column A it will always have Monday-Sunday with a different amount of blanks in between each day, like Monday will always be in A1, but Tuesday may be in A50 or A66 or any other cell in column A. Is there a way of naming the cell that Tuesday will be in Tuesday even though it moves?

  14. Super job! The videos have been extremely easy to follow and learn from. I was absolutely surprised at how quickly I was able to pick up and go in excel once I began the tutorials. My skills with excel have been basic up until now. Hesitant at first, with online learning, once I began watching the videos, I became immediately engaged and ready for the next tutorial.
    Thank you for all the time and effort you have put into the creation of this sight, the videos, workbook, etc.
    You have allowed me the opportunity to ‘excel’ at my work in leaps and bounds!
    Tina

  15. Love it! Great work! You are truly a gifted teacher. I feel like an expert now! Now that I’ve completed most of the videos, I’m curious what you are going to tackle next!

    • Hey Lee,

      So glad that you found the site/tutorials to be useful!

      Getting positive feedback is what makes it all worth it.

      My laptop crashed a couple weeks ago so I’m in the process of getting it up and running but I should be posting two new videos this month.

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

      Cheers,

      Ben

  16. Hey Ben!
    Thank you so much for the videos and Tutorial
    They are very helpful
    I’ll be looking forward to see the planned course videos as well:)

    Thank you so much once again!

  17. I’m actually looking for a course to learn Excel this Holy Week because I’m planning to create an inventory system for the company that I work in. I hope that your free course might help me to create one.

  18. Hey Ben,

    Great job! That’s very useful!!

    Could you share with us what’s the tecnology you use to record the videos??

    Thanks and regards,
    Carlos

  19. Dear Ben,

    This is an amazing course and is very helpful. I would like to congratualte you for the same.
    I also wanted to know if there is anyway we could acquire a certificate stating that we have completed a course in Excel.

    Thank you.

    • Hey Vash,

      So glad that you found the site/tutorials to be useful!

      Currently there is no certificate related to the course that I can provide. In the future I may have multiple choice quizzes/tests that can be completed after the videos to prove that the information was understood. As it currently stands, I don’t have any way of knowing whether someone has completed the course.

      Cheers,

      Ben

  20. Thank you very much for the videos and workbook! I am from Singapore and would like to self study Excel and progress from a know-the-basics to Advanced user. Then I want to try to sit for Microsoft Certifiied Exam for Excel. May I know how to learn more from you to the advanced stage?

  21. These are awesome! I’m looking for something just a good for Word. Could you recommend a site as all the one’s I’ve viewed are pretty average.

  22. Oops I have sent you an email but should have posted here! I recently bluffed a job interview (chancing both arms) and by some freak of nature got the job… which requires Excel skills I did not even nearly have, and then I watched your videos! Thank you Ben, you’ve probably saved my career 🙂

  23. You are wonderful! Thank you so much for these lessons. Our server was down today, so I decided to see if I could find some Excel training. I know Excel and have some advanced knowledge, but I’ve been looking for a way to learn more. One of the things I’ve wanted to start using more are Pivot Tables – was glad to see a lesson on those. You have just streamlined a lot of what I’m working on. Keep giving us more tips and tricks!

  24. I just wanted to say that I appreciate all of your hard work with this project. This is very helpful and is much more accessible and faster paced than the training my company provides. I will recommend your course to anyone interested in learning excel.

  25. This is so useful thank you for doing this. I am pretty good with excel but I am self taught so there are obviously things that I missed. Again thank you. Really good stuff.

Post any comments, feedback or questions below!

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

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 )

Connecting to %s