Learn various tips and shortcuts that will make you more efficient
when working with Excel.
Comfortable with basic Excel capabilities.
Are you using the fastest methods to accomplish tasks in Excel
2007? Could you use some of Excel's advanced features to automate
certain tasks? Would you like your spreadsheets to look more professional?
-
Freeze the headings on your worksheet so that they remain
visible as you scroll.
-
Split the screen to display non-adjacent areas of your worksheet
simultaneously.
-
Add a comment to a cell to make a note to yourself or other
users.
-
View a worksheet in Full Screen mode.
-
View calculated values in the status bar.
-
Customize the information that displays in the status bar.
-
Highlight all cells that contain formulas or all cells that
contain values.
-
View the formulas in a worksheet, rather than formula results.
-
Audit a worksheet.
-
Choose whether to recalculate formulas manually or automatically.
-
Name a cell or range of cells that you use often.
-
Quickly enter a series of data (e.g., days of the week, years,
numbers).
-
Find and replace specific data in a worksheet.
-
Learn how to enter fractions in a cell, enter the same data
in more than one cell, and enter the current date or time.
-
Use hyperlinks to jump to another cell, file, or Web page.
-
Add pictures, clip art, and SmartArt diagrams to a worksheet.
-
Choose how often Excel automatically backs up your data (for
recovery in case of a crash).
-
Save multiple workbooks in a workspace.
-
Download templates from Microsoft's Web site.
