Math On Demand (Office 12 Coolness, Part 4)
New features with Excel 12 ...
"Here's a neat time-saver in Excel 12. Let's say that you have some numbers somewhere in the Excel grid, in this case monthly sales figures for the branches of a store:
Now, let's say I wanted to quickly find out the average or total sales for some or all of my store branches. In Excel 12, I simply multi-select the sales figures of the store branches to compare and look down in the status bar at the bottom of the screen:
As I select numbers in the grid, the status bar automatically updates with the most commonly computed simple formulas. The status bar can display Average, Count, Numerical Count, Minimum, Maximum, and Sum".(Via Jensen Harris)
"Here's a neat time-saver in Excel 12. Let's say that you have some numbers somewhere in the Excel grid, in this case monthly sales figures for the branches of a store:
Excel 12 Grid.
Now, let's say I wanted to quickly find out the average or total sales for some or all of my store branches. In Excel 12, I simply multi-select the sales figures of the store branches to compare and look down in the status bar at the bottom of the screen:
Excel 12 Matches.
As I select numbers in the grid, the status bar automatically updates with the most commonly computed simple formulas. The status bar can display Average, Count, Numerical Count, Minimum, Maximum, and Sum".(Via Jensen Harris)
0 Comments:
Post a Comment
<< Home