Resources on Excel Features @ ExcelOptimize.Com
Currently Browsing: Excel Features

Live Preview

You simply can’t say enough about Live Preview and how much easier it makes formatting the worksheet. Live Preview works with all the style galleries as well as Font and Font Size pull-down menus in the Font group on the Home tab. It enables you to see how the data in the current cell selection would...

Style Galleries

Excel 2007 is jammed full of different style galleries that make it a snap to apply new sophisticated  (and, in many cases, very colorful) formatting to tables and lists of data, charts, and various and sun dry graphics you add to your worksheets. Coupled with the Live Preview feature , Excel’s...

Page layout view

Page Layout View in the Excel worksheet is just what the doctor ordered when it comes to visualizing the paging of printed reports. When you turn on this view by clicking the Page Layout View button on the Status bar, Excel doesn’t just show the page breaks as measly dotted lines as in earlier versions...

The zoom slider

So, how’d we ever get along without the new Zoom slider that’s now always there to use on the Excel 2007 Status bar? Instead of having to select a new magnification percentage for the worksheet from a drop-down menu on some obscure Zoom tool (something you can still do with the Zoom button on the...

Format As Table

This brand new feature is a real keeper. By formatting a table of data with one of the many table styles available on the Table Styles drop-down gallery, you’re assured that all new entries made to the table are going to be formatted in the same manner as others in similar positions in the table. Better...

Charts right from the Insert tab

Charts have been a part of Excel since the first Excel version but it feels like not until Excel 2007 did they come into their own. Excel 2007 retires the Chart Wizard and in its place offers you direct access to all the major types of charts on the Ribbon’s Insert tab. Simply select the data to be...

Formatting and Editing from the Home tab

The Home tab of the new Excel Ribbon literally brings home all the commonly-used formatting and editing features. Gone are the days when you have to fish for the right button on some long, drawn-out toolbar or on some partially-deployed pull-down menu. Now all you have to do is find the group that holds...

Cell Styles

Comparing the six measly and bland cell styles offered in previous versions of Excel to the more than 40 colorful readymade styles offered in Excel 2007, I’m here to tell you that in Excel 2007 you finally have cell styles. Moreover, these are styles you can preview in the worksheet with Live Preview...

Conditional Formatting

Yes, I know conditional formatting is technically not a new Excel feature, having existed in many of the previous versions. However, the conditional formatting in Excel 2007 is definitely not your mother’s conditional formatting. For, in addition to giving you the ability to define formatting when...

The Ribbon

The Ribbon is the heart of the new Excel 2007 user interface. Based on a core of standard tabs to which various so-called contextual tabs are added as needed in formatting and editing of specific elements (such as data tables, charts, pivot tables, and graphic objects), the Ribbon brings together most...