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?
-
Save time by using Excel's shortcut menus.
-
Freeze a portion of your worksheet so that it remains visible
as you scroll.
-
Split the screen to display non-adjacent areas of your worksheet
simultaneously.
-
Name a cell or range of cells that you use often.
-
Add a comment to a cell to make a note to yourself or other
users.
-
Collapse dialog boxes to easily display and select worksheet
data.
-
"Float" menu options and formatting palettes for
quick access to common tools.
-
Use the AutoCalculate functions to quickly sum, average,
or count.
-
View the formulas in a worksheet, rather than formula results.
-
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, display cell contents
on more than one line, and enter the current date or time.
-
Automatically sum the data in a column, row, or table.
-
Use hyperlinks to jump to another cell, file, or Web page.
-
Use Smart Tag Actions to send a message to a recent Outlook
mail recipient or to find stock quotes and company information.
-
Change the default location in which Excel files are stored.
-
Recover worksheet data after a crash.
-
Save multiple workbooks in a workspace.
-
Discover several "solutions templates" available
from Microsoft.
