Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

training microsoft excel - subtotals

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Subtotals

training microsoft excel - Subtotals

ResolvedVersion Standard

Emily has attended:
Excel Intermediate course
Excel Advanced course

Subtotals

What is subtotal used for?

RE: Subtotals

Hi Emily

Thank you for your question.

Subtotals are used to create some kind of summary figures (e.g. totals, averages) within a list of information, and provide a grand/overall summary figure for the whole list.

Amanda

Excel tip:

Page Break Preview in Excel 2010 (Hint/tip)

If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.