Excel Tips and Tricks

·         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)