| |
Dawn Bjork Buzbee
The Software Pro®
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist Master Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE)
(303) 699-6868
Dawn@SoftwarePro.com
|
| | In addition to the dramatically different user interface and new file formats shared with other Microsoft Office 2007 programs, Microsoft Office Excel 2007 also adds a number of improvements and new features: - Excel 2007 now supports up to 1 million rows and 16 thousand columns per worksheet! Specifically, the Office Excel 2007 grid is 1,048,576 rows by 16,384 columns, which give you 1,500% more rows, and 6,300% more columns than Excel 2003 to manage massive amounts of data! (FYI-columns now end at XFD instead of IV).
As if that wasn’t impressive enough, each Excel 2007 workbook can contain up to 1024 worksheets, an increase from the previous limit of 255 worksheets. Bet you can’t wait until a project of this size lands on your desk!
- Quickly format data with Shared Themes and Styles. For instance, in just minutes, you can easily apply professional looking formats to worksheets complete with borders, color and font formats, and other slick enhancements.
- Formula writing is much easier with a resizable formula bar, a range name manager, and other upgraded formula tools.
- Improved sorting and filtering tools including the ability to sort data by color and by more than 3 (and up to 64) levels.
- New shared charting engine. Add visual enhancements to your charts such as 3D, soft shadowing, and transparency. Create and interact with charts the same way, regardless of the application you are using, because now the new charting engine is consistent in both Word and PowerPoint 2007.
- The significantly upgraded Page Layout View helps ensure what you see on the screen is what you’ll get in printed output. That means any headers and footers you add or edit are displayed in plain view and worksheet pages are even easier to see.
- Significantly improved PivotTables with updated features to summarize, analyze, and format your PivotTable data.
© 2008 by Dawn Bjork Buzbee
Dawn Bjork Buzbee
is The Software Pro® and a certified Microsoft Office Expert,
Certified Microsoft Applications Specialist (MCAS) Instructor, and a certified
Microsoft Office Specialist Master Instructor. Dawn shares smart and easy ways
to effectively use software through her work as a software speaker, trainer, and
consultant. Discover more tips, tricks, tools, and techniques
at
www.SoftwarePro.com.
This article and
more can be reprinted at no charge in your publications and website with
copyright and attribution. >>Learn
more about how easy it is to share this useful information.
More Microsoft Office 2007 Articles
More Smart & Easy Software Tips, Tricks &
Techniques for You
<<Back to Articles
| |
Press [Alt] + F to open the new Microsoft Office Button and to access file management commands and more.
|
|
Tips, Tricks, Secrets
that you need to know now!
|
|
