Email: Ben@ExcelExposure.com

Text or leave me a voicemail at my “Excel Emergency Hotline”:

404-91-EXCEL (404-913-9235)

My Microsoft MVP Profile

I also offer Corporate Training workshops (of varying length) for online and/or on-site employee training. Please contact me directly via email or LinkedIn for more information:

### Like this:

Like Loading...

how to set PAN NUMBER format in excel cell. if anybody enter wrong format of PAN NUMBER cell does not accept values.

I want to learn about pivot. I reall badly need it for my daily updates in our operations.

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

–Solved– Thanks..

=IF(J5=””, “”, COUNTA($J$1:J5))

Hi.

I am new to excel.

Help me finding the right way to start my study.thanks a ton

I am a beginner to excel .Help me finding a right way to start my study..Thanks a ton…

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.

its so painful am just getting to know a site like this expecially when my work is basically on Excell.GOd bless you Mr Ben

I want a formula to calculate the average of the lowest 10 numbers if I have 20 numbers in a colum

=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

why am I getting a Microsoft security warning when trying to watch the second video re formatting?

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.

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

where can I find the tutorial videos of Ben?

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.

Hi,

I’m interested in learning excel, graphs, pie charts, pivot, all of it. Can you please contact me at your earliest?

Thanks much.

Val

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

I want to be a student in your university. I need Excel badly.

Regards,

Augustus

thank you again for this man. This is truly awesome .

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

Ben, I completed your excel course and want to say that it was excellent. Do you offer anything in word.

I managed to pass my Excel test just by listening to your tutorial. Thank you.

Do you have any tutorials in Word 2010?

Thanks for all the great info here – always my number one source for excel help. 🙂

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

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.

Hi do you have something like this for access and power point.

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

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…

Hi Susan,

The problem is that you should have the SUM formula around both ranges, like so:

=SUM(G1:G300)-SUM(D1:D300)

That should work. Let me know if you need any additional help!

Cheers,

Ben

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?

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

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

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!

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.

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

Hi Carlos,

I use Camtasia Studio for both screen/audio recording as well as video editing after the fact.

Hope that helps.

Cheers,

Ben

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

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?

Great work!!!

i want to get admission in this institute what is the procedure??

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.

Really worthwatch videos..Can u upload more intermediate level videos for finance and accounts section

Best excel tutorial on the internet!

Nice work. great website for learning about excel.

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 🙂

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!

This is indeed a very useful website to help people learn different excel functions. Thanks for offering us all of these！

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.

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.