·
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) |
in the upper right, then select Settings.