Microsoft Office 2010 Expert, Office 2007 Expert, software speaker, software training, consulting, software tips & tricks, Office 2007 trainer, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, tips, Microsoft Office 2007 trainingSoftware Tips & Tricks, Expert Speaker, Microsoft Office 2010 Training, Microsoft Certified Trainer, Microsoft Office Consultant, Books, Videos, Web Training  
 Home Products Programs Meet Dawn Free E-zine Media Room Contact 
Excel 2007  

Technology Trainer
Software & Tech Speaker
Software Consultant
Tips & Tricks
The Pro Shop
Free Software Articles
How-To Lessons
Tips Newsletter
Bonus Resources

 
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)
WBENC Certified

WOSB (Women-Owned Small Business) Certified

(303) 699-6868
Dawn@TheSoftwarePro.com

>>Back to Articles Home

Excel 2007: Top 7 New Features

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:

  1. 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!
     
  2. 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.
     
  3. Formula writing is much easier with a resizable formula bar, a range name manager, and other upgraded formula tools.
     
  4. Improved sorting and filtering tools including the ability to sort data by color and by more than 3 (and up to 64) levels.
     
  5. 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.
     
  6. 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.
     
  7. 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.
>>Learn 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

Go To Top of Page
 



Home for Dawn Bjork Buzbee, The Software Pro
Contact Dawn Bjork Buzbee, The Software Pro
Hot Excel 2007 Tip
Press [Alt] + F to open the new Microsoft Office Button and to access file management commands and more.
 

 
www.TheSoftwarePro.com
HomeContact Us | Training | Speaking | Consulting | Services | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

© Copyright 2015 The Software Pro® & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868
§ Dawn@TheSoftwarePro.com § www.TheSoftwarePro.com
Geek Speak Becomes People Friendly

Microsoft Certified Trainer (MCT)
§ Certified Microsoft Office 2013 Specialist (MOS 2013) Master
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
§ Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist (MOS) Master Instructor
§ Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE) WBENC Certified
§ WOSB (Women-Owned Small Business) Certified
The Software Pro
® is a registered trademark
Terms & Conditions       Privacy Policy