Email: Ben@ExcelExposure.com
Text or leave me a voicemail at my “Excel Emergency Hotline”:
404-91-EXCEL (404-913-9235)
If you’d like personalized Excel consulting in a professional capacity beyond the normal teacher/student questions or feedback, feel free to check me out on Maven:
I also offer Corporate Training workshops (of varying length) for on-site employee training. Please contact me directly for more information.
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.