Microsoft Office Tutorials and References
In Depth Information
If you missed the last two upgrades
PowerPoint, and OneNote files from just about anywhere, offering browser-based
viewing and lightweight editing.
Slicers Slicers provide an easy way to filter large PivotTables so that you can see
exactly the data you need without being distracted by data you don’t need.
Improved conditional formatting New conditional formatting options let you
quickly visualize and comprehend data. You will find more styles, icons, and data
bars, and you now have the ability to highlight specified items (such as the maximum
or minimum value) in a few clicks.
New functions and functional consistency Microsoft added a number of
statistical and financial functions that extend or refine existing functionality. Most of the
new functions are statistical distribution functions. For example, in addition to the
existing COVAR function, a measure of deviation between data sets, you can now
choose COVARIANCE.P or COVARIANCE.S, which applies to an entire population of
data (P) or a representative sample (S).
Improved math equation support
Create and display math equations with a rich
set of equation-editing tools.
Improved charting capacity Two-dimensional charts in Excel 2007 were limited to
32,000 data points per series. Chart series are now limited only by system memory.
Additional SmartArt graphics Incorporate great-looking graphics into your
professional documents without a large consulting team or time commitment.
64-bit edition Excel 2010 introduced 64-bit scalability for the Excel guru or analyst
working with massive, memory-intensive datasets.
Office Mobile Microsoft Office Mobile brought Office tools to the mini screen of
your mobile device.
If you missed the last two upgrades
If you are one of the people clinging to Excel 2007 and managed to hang in there all this
time, well . . . hey, it’s time to upgrade. Here is a summary of the things that were changed
in Excel 2007:
Results-oriented user interface The old toolbars and menu bar have been
replaced by a single toolbar and a new dashboard called the ribbon, which has a
taskoriented structure and easily recognizable tools. Most of the old menus have been
reborn as tabs.
Search JabSto ::




Custom Search