Dawn Bjork Buzbee
The Software Pro®
Microsoft Certified Trainer (MCT)
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE)
WOSB (Women-Owned Small Business) Certified
>>Back to Articles Home
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)
- 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.
© Dawn Bjork Buzbee, MCT, The Software Pro®
Dawn Bjork Buzbee
is The Software Pro®
and a Microsoft Certified Trainer (MCT) as well as a certified Microsoft Office
Specialist (MOS) Master Instructor, certified Microsoft Applications Specialist
(MCAS) Instructor, and a certified Microsoft Office expert. Dawn shares smart
and easy ways to effectively use software through her work as a software
speaker, trainer, consultant, and author of 8 books.
This article and
more can be reprinted at no charge in your publications and website with
copyright and attribution.
more about how easy it is to share these valuable tips, tricks, and techniques.
More Microsoft Office 2007 Articles
More Smart & Easy Software Tips, Tricks &
Techniques for You
<<Back to Articles
Be an Excel Expert!
How effectively are you using Excel to create, format,
and analyze your important data?
Become an Excel expert with the
Excel with Excel
Learning Series. Master functions, filtering,
linking, PivotTables, charts and graphics, macros, and more!
Click Here to
Choose Your Excel Training
Press [Alt] + F to open the
new Microsoft Office Button and to access file management
commands and more.