Excel Basics - Wall Street Prep

Excel Basics - Wall Street Prep
Absolute Value - ANS-ABS(cell)
access anything on the ribbon - ANS-atl
auto size cell - ANS-alt h o i
Auto sum - ANS-Alt =
bold - ANS-ctrl b
Borders (Outside Area) - ANS-Ctrl Shift 7
Ceiling - ANS-CEILING(cell, significance) round up to the nearest x, specified by significance
Combinations - ANS-COMBIN(number, number chosen) - numbers of combinations given
number and size of group (number chosen)
Combing Sort & Subtotal - ANS-ALT A B - can add further clarity to data sets
COUNT, COUNTA, COUNTIF - ANS-COUNT(value1, value2,...)counts the number of cells that
contain numbers within the list of arguments. Cell w/ text are ignored.
COUNTA same as COUNT except cell with numbers and text are disregarded.
COUNTIF(range, criteria)counts the number of items in the range that satisfy a specific criteria -
similar to SUMIF function.
Create Drop Down Menu - ANS-ALT + D L
Create new sheet - ANS-ctrl i w
Date function - ANS-(year,month,day) but if you do DATE(Year(cell w/ date to reference)+1,
Month(cell w/ date), Day(cell with date)) makes easier to drag out a list of dates increasing each
year by 1
deleting columns / rows - ANS-ALT H D R / ALT H D C
designate width of box - ANS-alt h o w
did a function and want to repeat - ANS-f4