125 Excel Tips and Shortcuts

Here are 50 Essential Excel Tips, from scribd.com, providing step-by-step instructions on how to do many things using Excel. This Excel tips document is available in both .pdf and .doc formats and is 20 pages in length. These shortcuts and techniques will teach you how to use many of Excel’s features and how to be more productive with this spreadsheet application. Also, here is another Excel Tips document from Techrepublic offering 75 Excel Tips (free registration required for this one).


Table of Contents of 50 Excel Tips:

 - Customizing your workspace
 - Change default worksheet options
 - Opening multiple windows
 - Creating a workspace in Excel
 - Change the default currency
 - Faster access to worksheets
 - Keep a cleaner desktop when multitasking
 - Opening a workbook at startup
 - Saving time with Custom Views
 - Using shared workbooks
 - Clear out all comments
 - Take a few shortcuts
 - Delete personal information from a worksheet
 - Editing, layout, and printing
 - Hiding duplicate records
 - Copying styles between workbooks
 - Printing formulas
 - Quickly setting a print area
 - Print worksheet column labels on every page
 - Modify Excel print margins with the mouse
 - Don’t use AutoFormat on an entire worksheet
 - Keep track of changes
 - Highlight urgent items
 - Using Goal Seek
 - Change automatic page breaks
 - Entering and working with data
 - Use calculated fields in data entry forms
 - Speed up data entry with these keyboard shortcuts
 - Creating custom lists
 - Create a list box to ensure data entry accuracy
 - Increase data entry accuracy with drop-down lists
 - Create a custom Auto Fill list
 - Catching data entry errors
 - Format cells as you type
 - Analyzing external data in Excel
 - Copy subtotals
 - Summarize data with grouping
 - Simplify data entry with Excel’s built-in form
 - Conditional formatting
 - Lock cells to prevent overwriting
 - Point to value thresholds in a cell
 - Ensure proper data entry with validation
 - Check for numbers stored in a text format
 - Formulas, functions, and code
 - Use natural language formulas
 - Counting the days via cell subtraction
 - Compare values in text fields using DCOUNTA
 - Perform calculations with Paste Special
 - Use auditing to troubleshoot
 - Customizing “division by 0″ error messages
 - Hide formula cells
 - Web tricks
 - Easy data-posting to the Web
 - Open Web pages right in Excel
 - Hyperlink to a specific cell

Popularity: 19% [?]