subtotals
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Subtotals

Subtotals

resolvedResolved · Low Priority · Version Standard

replyReply Tue 25 Mar 2008, 16:04Delegate Michelle said...

Michelle has attended:
Excel Intermediate course

Subtotals

What is the maximum number of subtotals I can have?

For upcoming training course dates see: Pricing & availability

replyReply Sun 30 Mar 2008, 20:54Trainer Mara said...

RE: Subtotals

Hello Michelle,
I hope you enjoyed your Excel training session with us.

In response to your question, you can apply subtotals multiple times, if you want to apply them to multiple columns or if you want to apply other functions (AVERAGE, COUNT, etc). I am not aware of the maximum number of times you can apply subtotaling - you may want to test it out!

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

 

Please browse our web site to find out more about
learn excel in london and other Microsoft training courses.

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard