·
Edit Selected Cell – F2
·
Go To Specific Cell – F5
·
Check Spelling – F7
·
Create Chart – F11
·
Enter Current Time – Ctrl + Shift + ;
·
Enter Current Date – Ctrl + ;
·
Insert New Work Sheet – Alt + Shift + F1
·
Open the Excel® formula window – Shift + F3
·
Search Box – Shift + F5
·
Select All Data – Ctrl + A
·
Copy Selected Items – Ctrl + C
·
Cut Selected Items – Ctrl + X
·
Paste Items – Ctrl + V
·
Paste items – Shift + Insert
·
Words in Bold – Ctrl + B
·
New Document – Ctrl + N
·
Open Options – Ctrl + O
·
Open Print Window – Ctrl + P
·
Open Find Window – Ctrl + F
·
Word in Italicize – Ctrl + I
·
Fill Cell – Ctrl + D
·
Insert Hyper Link – Ctrl + K
·
Find & Replace – Ctrl + F5
·
Find & Replace – Ctrl + H
·
Go To Options – Ctrl + G
·
Under Line Cell – Ctrl + U
·
Strike Through The Cell – Ctrl + 5
·
Minimize Current Window – Ctrl + F9
·
Maximize Current Window – Ctrl + F10
·
Move Between Excel Sheets – Ctrl + Page
Up/Page Down
·
Create Formula For Above Cells – Alt + =
·
Format Number in Comma Format – Ctrl + Shift
+!
·
Format Number in Currency Format – Ctrl +
Shift +$
·
Format Number In Date Format – Ctrl + Shift
+#
·
Format Number In Percentage Format – Ctrl +
Shift +%
·
Format Number In Scientific Format – Ctrl +
Shift +^
·
Format Number In Time Format – Ctrl + Shift
+@
·
Select Enter Column – Ctrl + Spacebar
·
Select Enter Row – Shift + Spacebar
·
Close Window – Alt + F4
·
Close Window – Ctrl + W
Excel Functions:
| Excel Function | Description |
|---|---|
| SUM | Calculates the sum of a group of values |
| AVERAGE | Calculates the mean of a group of values |
| COUNT | Counts the number of cells in a range that contains numbers |
| INT | Removes the decimal portion of a number, leaving just the integer portion |
| ROUND | Rounds a number to a specified number of decimal places or digit positions |
| IF | Tests for a true or false condition and then returns one value or another |
| NOW | Returns the system date and time |
| TODAY | Returns the system date, without the time |
| SUMIF | Calculates a sum from a group of values, but just of values that are included because a condition is met |
| COUNTIF | Counts the number of cells in a range that match a criteria |
Excel Error Messages to Get to Know:
| Error | Meaning |
|---|---|
| #DIV/0! | Trying to divide by 0 |
| #N/A! | A formula or a function inside a formula cannot find the referenced data |
| #NAME? | Text in the formula is not recognized |
| #NULL! | A space was used in formulas that reference multiple ranges; a comma separates range references |
| #NUM! | A formula has invalid numeric data for the type of operation |
| #REF! | A reference is invalid |
| #VALUE! | The wrong type of operand or function argument is used |
Excel Cell References Worth Remembering:
| Example | Comment |
|---|---|
| =A1 | Complete relative reference |
| =$A1 | The column is absolute; the row is relative |
| =A$1 | The column is relative; the row is absolute |
| =$A$1 | Complete absolute reference |
Excel Text Functions You'll Find Helpful:
| Function | Description |
|---|---|
| LEFT | Extracts one or more characters from the left side of a text string |
| RIGHT | Extracts one or more characters from the right side of a text string |
| MID | Extracts characters from the middle of a text string; you specify which character position to start from and how many characters to include |
| CONCATENATE | Assembles two or more text strings into one |
| REPLACE | Replaces part of a text string with other text |
| LOWER | Converts a text string to all lowercase |
| UPPER | Converts a text string to all uppercase |
| PROPER | Converts a text string to proper case |
| LEN | Returns a text string’s length (number of characters) |
