Excel Auto Sums and Custom Number Format
An Excel tutorial by Peter Kalmstrom
In
the demo below Peter Kalmstrom gives two Excel tips. He
shows four ways to make Excel calculate sums, and he also
explains how to add a custom number format to cells.
The possibility to tell Excel to calculate is a crucial
feature and the most important reason to use it. In other
demos Peter Kalmstrom has shown how to
create formulas for plus and minus and
how to make Excel mulitpy and divide.
These are the auto sum methods shown in the demo:
- Write in cell coordinates with a plus sign between:
=A1+A2+A3
- Write in the first and last cell coordinate: =SUM(A1:A3)
-
Press
the AutoSum button and accept or reject the suggestion
- Select the cells you want to summarize and press
the AutoSum button
To define a custom number format, Peter opens the dialog
box launcher of the Number ribbon group and enters a code
with hash marks (=display if a value), zero (= numbers should
always be displayed) and the value "miles" he wants to add.
Peter uses Excel 2013 for his demo, but the Excel sum calculation
and custom number formats are the same for earlier versions
of Excel.
|
Software that enhances SharePoint |
Kanban Task Manager
Visualize and co-operate on projects and tasks in SharePoint
and/or Outlook |
Pivot Explorer
Visualize and analyze list data in SharePoint |
Templates Manager
Find, use, manage and distribute Office templates in SharePoint |
Calendar Browser
Resource booking in SharePoint calendars |
|