5. Use macros.
At first glance, macros -- ingenious shortcuts you can create for performing repetitive tasks -- seem to have been banished from Excel 2007. But they're still there; display the Developer tab, and you'll find them in all their glory. In fact, the Developer toolbar puts the macro tools at easier reach than they were in previous versions of Excel.
You'll find everything you want in the Code group on the Developer tab. Record a macro by clicking the Record Macro button, manage your macros by clicking the Macros button and configure security for macros by clicking the Macro Security button.
Any macros you created in previous versions of Excel should work fine in Excel 2007. See Microsoft's Office Online site for more information about working with macros in Excel 2007.
6. Find your old friends.
In Excel 2007, no features or functions are where they used to be. But it's easy to find them. Use our Excel 2007 quick reference charts for an extensive list of where to find your old friends.
New features in Excel 2007
In Excel 2007, more is truly better. Microsoft has increased the number of columns per spreadsheet (and per PivotTable) to 16,384 (up from 256) and the number of rows to 1,048,576 (up from 65,536). Other limits have been also expanded: Text cells can now contain more than 32,000 characters (up from 255).
Chances are you'll never reach other new limits: PivotTables can manipulate more than 16,000 fields (up from an already generous 255), and formulas can now refer to up to 8,000 cells (memory permitting), so it's fortunate that Excel 2007 lets you drag the corner of the formula bar to expand it.
Excel 2007's memory manager can handle 2GB (double the amount in Excel 2003), so calculations execute faster. The new version also takes advantage of dual-core processors and multithreaded chip sets, so if you're lucky enough to be running it on a machine with either feature, expect a noticeable speed boost.
New visualization tools
Charts and graphs now support 16 million colors, and improved color support is evident throughout this version, especially in several new visual tools for highlighting data. For example, in Excel 2007 you can use conditional formatting to set the background color of a cell or use a colored bar (called a data bar) -- the length corresponds to the cell's value.
You can also add icons to cells based on their value, giving your worksheet a dashboard-like quality. For example, assigning traffic-light icons to a range of cells is a snap, and Excel's built-in logic assigns colored circles based on the value of the cell: green for the highest third, yellow for the middle third and red for the bottom third.
Similarly, a four- or five-icon set (such as set of vertical bars similar to what your cell phone uses to indicate signal strength) displays icons based on which quartile or quintile the value falls into.
In all cases, you can control the ranges for each icon in the set -- allowing you, for instance, to use a green traffic light to indicate only the highest 10% of values.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Is Your Big Data Solution Production-Ready? Read "Is Your Big Data Solution Production-Ready?" now, and discover best practices and actionable steps to implementing a production-ready big data solution.
- Pay-as-you-Grow Data Protection: IBM Tivoli's Full-featured Data Protection Suite for Small to Medium Businesses IBM Tivoli Storage Manager Suite for Unified Recovery gives small and medium businesses the opportunity to start out with only the individual solutions...
- Streamline Data Protection with IBM Tivoli Storage Manager Operations Center IBM Tivoli Storage Manager (TSM) has been an industry-standard data protection solution for two decades. But, where most competitors focus exclusively on Backup...
- Simplify and Consolidate Data Protection for Better Business Results Learn about IBM® Tivoli® Storage Manager Operations Center, which provides advanced visualization, built-in analytics and integrated workflow automation features that leapfrog traditional backup...
- Webinar: Building a Big Data solution that's production-ready Big data solutions are no longer just a nice-to-have.
- Meg Whitman presents Unlocking IT with Big Data During this Web Event you will hear Meg Whitman, President and CEO, HP discuss HAVEn - the #1 Big Data platform, as well... All Desktop Apps White Papers | Webcasts