MS Excel 2003 has a great feature – The QuickSum Calculator – but you have to know where to find it. It is on the Status Bar – that area at the lower right of your screen. Simply select at least two data cells. They can be contiguous or non-contiguous. But remember where to look for the QuickSum Calculator – it is on the Status Bar.
Want to change the function? It simple! Just right-click on the name of the Function. You can choose Average, Count, Count Numbers, Min or Max – Excel’s most common Functions.
This is a great way to perform an Ad-hoc Query. I recommend that you use this for spreadsheets with Subtotals. Watch this short video lesson to see how this works – and how you can save time!
Find the Excel Video Lesson that you want – Index of all Excel Topics
News! My DVD, “The 50 Best Tips for Excel 2007” is now availabe to purchase. I invite you to visit my online bookstore for more details.
Link to this post!
Hi Danny really enjoy your tutorials and have learnt so much about excel as a result.
Can you help with the following problem? Whenever I email a worksheet with conditional formating the recipients lose the conditional formating.
Is there a way of locking in the conditional formating so that it appears in their spreadsheet? We are all using 2007.
cheers
steven
Hi Steven –
Thank you for your kind words. I am pleased that you have picked up some good tips for using Excel from my videos and posts. I am going to email you directly to respond to your query. I did a little bit of research on the topic and I have a few thoughts that might help you with this.
Best wishes,
Danny Rocks
ARRRRGHHHH , LOL
Time calculations, do you have a tutorial for a timecard using military time for in/ out with a lunch.
I do have a lesson in Excel that uses military time – the focus is on converting from military time to standard time (AM – PM). I also have several lessons illustrating how to structure a time card (hours worked before and after lunch). I do not have a lesson that combines BOTH. Let me see what I can come up with during the next few weeks.
Danny
Danny,
I am working on a spread sheet and I am trying to get a number in one cell (lets call it A1) which stays constant/starting point and have cells subtract as they are entered (lets call it B10 thru M10) from A1 and the total running be in another cell (lets call it H5)?? I am stumped!! To clarify, I want Cells B10 thru M10 to subtract as they are entered mothly from A1 and the total number show in H5… Any help would be great. I also want to thank you for your postings on You Tube as they are teachign me a lot about excel!
Thank you!
Ron
I figured it out!! if you had an easier way than using MAX please let me know… fun stuff!
Hi Ron -I am pleased that my video tutorials are helping you. And I am happy to hear that you figured out how to solve your problem.
Thank you for writing to me.
Danny Rocks
Hi Ron –
If I understand you correctly, the constant cell A1 needs to be referred to as $A$1 (Absolute Cell reference) when you perform your subtractions.
For a running total formula – let’s say cells B2:B25 contain the daily sales numbers that you want to total in B26. Write the formula as =SUM(B$2:B2) and copy it down. The left side of the range B$2 is the “anchor” – you will always be calculating the running total beginning with row 2 and moving down – relative reference B2 becomes B3, B4, etc.
Thanks for asking me for help.
Danny
hi..really good stuff !! i have a query..can we somehow using excel macros or may me other tools get data automatically from website..Basically i need to manually export around 15-20 different parameters from a website ( in csv format) and then post process (pivot tables charts looku) the using excel …so i was hoping if there is someway for doing it automatically…post processing i have been able to write macro..was wondering if there is way to automatically download the file also
Thank you for your comments.
Re: Gathering information from the internet. Here is a link to a video tutorial that covers this topic:
http://www.thecompanyrocks.com/create-a-web-query-in-excel-to-gather-updated-information/
I would have to have more information – the website that you wish to query, etc. in order to answer your question.
Danny Rocks
Hello,
I’m having problems with my excel sheet. I’m trying to re -size all of my cells at once and I can’t find a way to do it.
thanks for your help.
Lehi –
To re-size all Excel Cells at one time, you have 2 choices:
1) Change the ZOOM Level – From the VIEW Tab or Menu – change the Screen Magnification Up or Down. This does not affect the Font Size or how your Excel Worksheet will be printed.
2) Select ALL Cells (Use the Ctrl + A Keyboard Shortcut) and then change the FONT SIZE for all Cells. While all of the cells in the worksheet are selected, you may have to adjust the ROW Height. Do this for one row and all of the rows will adjust automatically.
Dear Sir
How I can get your excel DVD in India. I don’t use net banking I want to buy it by cash .
Please Guide me.
Thank You
Rajesh Kumar.
Danny, Hello from the UK!
Your tutorial videos are excellent and have given me the confidence to see what a valuable tool Excel is. I am using Excel 2010 and want to create a form that another user on a different computer can insert images from their library into. Is this at all possible and if so where would I start?
Apologies if you have already covered this in a video tutiorial, I have looked through many!
Thank you in advance,
Paul
Thank you for your kind words. I am pleased that you enjoy my video tutorials.
Danny Rocks