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
2010? Do you want to learn tips for navigating a worksheet, finding
information in your worksheets, and entering data more easily?
-
Freeze the headings on your worksheet so that they remain
visible as you scroll.
-
Split a worksheet into multiple panes or windows (to view
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 view.
-
View calculated values in the status bar.
-
Customize the information that displays in the status bar.
-
Control the way data you copy and paste is formatted.
-
Find cells that contain constant values or formulas.
-
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.
-
Save multiple workbooks in a workspace.
