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.
- Silicon Valley's 19 Coolest Places to Work
- Is Windows 8 Development Worth the Trouble?
- 8 Books Every IT Leader Should Read This Year
- 10 Hot Hadoop Startups to Watch
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Gartner Magic Quadrant for Client Management Tools The client management tool market is maturing and evolving to adapt to consumerization, desktop virtualization, and an ongoing need to improve efficiency.
- Acxiom Case Study This case study, which focuses on Acxiom, explores how the company was able to secure employee data, reduce migration costs and boost productivity...
- Windows® XP Migration: Protect and Secure Critical Data With the end of the Microsoft Windows XP operating system's lifecycle on April 8, 2014, businesses are faced with the decision to migrate...
- Exponentially Accelerate Data Protection and Recovery with Simpana 10 IntelliSnap® Snapshot Management Technology Are you making the best use of your storage array snapshot functionality? CommVault Simpana 10 IntelliSnap technology manages hardware-based snapshots across multiple vendor...
- Top 4 Digital Signage Fails Join RMG Networks for a look at four of the most common reasons digital signage fails in corporate businesses. Learn about strategies to...
- Building Tomorrow's Infrastructure Listen to this podcast to discover how Crider Foods worked with PC Connection to update their IT infrastructure, while maintaining compliance and control. All Desktop Apps White Papers | Webcasts