Microsoft Excel Cheatsheet reference guide...

Microsoft Excel Cheat Sheet
Microsoft Excel Cheat Sheet

Ctrl + Spacebar - Selects the entire column in a worksheet.
Shift + Spacebar - Selects the entire row in a worksheet.
Copy and Paste
Ctrl + C - Copy selected text.
Ctrl + V - Paste copied text.
Ctrl + Alt + V - Opens Paste Special dialogue box.
Ctrl + D - Uses Fill Down function to copy contents and formatting of top cell to selected cells below.
Ctrl + 1 - Format Cells dialogue box.
Ctrl + Z - Undo
Ctrl + Y - Redo
Ctrl + F2 - Print Preview
Ctrl + F - Find and Replace dialogue box
Alt + Shift + F1 - Inserts new worksheet.
Ctrl + Home - Returns to cell A-1
Ctrl + End - Moves to the last used cell in the worksheet.
Function Keys
F1 - Help
F2 - Edits active cell, puts insertion cursor at end of cell contents.
F4 - Repeat last command or action.
F7 - Spellcheck
F11 - Creates a chart of data in the current selected range.
F12 - Save As...

Formula Components Explained

Cell Expressions
Name of a Cell - Examples: A10 (Column A, Row 10), or F36 (Column F, Row 36)
Multiple Individual Cells - Examples: A9,G22 (Cell A9 and G22), or B12, Z24,AA13 (Cells B12, Z24, and AA13)
Cell Ranges - Examples: C11:C95 (Cells in column C and rows 11-95), or D14:H22 (cells in columns D through H, and cells 14-22)
Formula Writing - All formulas begin with "=", include a function like SUM, and a range of cells. Example: =SUM(A12:A27) will display the sum of all numbers in rows 12-27 in column A.

Common Excel Math Functions

Average - Finds the average value of the selected range. Example: =Average(A2:C14)
Count - Returns the number of cells that contain numbers. Example: If you had numbers in cells A1, A2, and A6 and words in cells A3, A4, and A5, you could use the formula =Count(A1:A6) and it would return 3, since three of the cells in the range are number contents.
Max - Finds the largest value in the selected range. Example: =Max(B2:B88) would find the highest number in that range and display it.
Min - Finds the smallest value in the selected range. Example: =Min(B2:B88) would find the lowest number in that range and display it.
Product - Multiplies numbers in the selected range and returns the answer. Example: =Product(B4,B5) would multiply the values in cells B4 and B5 and display the product.
Sum - Adds the values in the selected range and returns the answer: Example: =Sum(B4,B5) would add the values of B4 and B5 and return the sum.
Trunc - Truncates the number in the selected cell to the designated number of decimal spaces. Example =Trunc(B7, 2) where B7=36.251 would return the value 36.25. =Trunc(B7, -1) would return the value 30.

Read more:

Creating and Using Charts

Excel Tutorial: 2010 Charts
Excel Tutorial: 2010 Charts

As with all versions of Excel, making charts and graphs is easy and there are numerous ways to customize them. The simplest way to create a chart in any version of Excel is to select the data you wish to use and then press the F11 key at the top of our keyboard, which adds a default chart to your worksheet. Creating different types of charts in Excel 2010 is not much more difficult. Simply select the data and go to the Insert tab of the ribbon. In the Charts group, click on the type of chart you want to add and then choose a subtype. Once you have inserted a chart, you will be given even more options, such as chart styles, layouts and colors.
Although the Insert Charts section does provide quite an array of options, you can check out Microsoft Excel tutorials to learn about even more complex charts. For example, you can learn how to make a thermometer chart that will help you track your progress toward a goal. Alternatively, you can learn about creating Pareto charts, which are commonly used in project management. No matter what type of chart you need to make, there is sure to be an Excel tutorial providing the required steps.

Working with Other Applications

An Excel tutorial guide would not be complete without mentioning the seamless integration of Excel 2010 with other Microsoft Office products. For instance, if you have both Excel and Publisher 2010 installed you can import a worksheet into Publisher or PowerPoint, ensuring that your publication will always have the most current data. You can use data in an Excel 2010 worksheet to perform a mail merge in MS Word or Publisher, as well. Excel works well with other Office applications as well, such as Access and OneNote.
Excel Tutorial: 2010 Publisher
Excel Tutorial: 2010 Publisher

Finally, you can use a scaled down version of Excel 2010 - and other 2010 Office products - no matter where you go, provided you have internet access. Microsoft now offers Office Web Apps 2010 online. Best of all, these applications are free to use!

Read more: