https://www.stuvia.com/user/allatopnotch
2026-09-08https://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch
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
Excel Basics - Wall Street Prephttps://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch https://www.stuvia.com/user/allatopnotch
, https://www.stuvia.com/user/allatopnotch
2026-09-08https://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch
Fill Highlighted Area Right / Down - ANS-ctrl r / ctrl d
Fill Multiple Cells at Same Time - ANS-Highlight Cells; Type in Info; Cntrl + Enter
Fill Right / Fill Down - ANS-Ctrl+R / Ctrl+D
find and replace - ANS-ctrl h
find which boxes hardcoded - ANS-F5 ALT SOX
First/Last Used Cell in Worksheet - ANS-CTRL Home/End
Floor - ANS-Floor(cell, significance) round down to the nearest x, specified by significance
Format Painter - ANS-You can use Ctrl+Shift+Cto copy a format, and Ctrl+Shift+Vto paste a
format.
formatting - ANS-ctrl 1
freeze pane - ANS-alt w f f
To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the
worksheet scrolls.
Freeze Panes - ANS-[Alt],[W],[F],[F]
FV - ANS-FV(rate, nper, pmt, fv, type) - Returns the future value of an investment based on
constant and interest rate
rate - interest rate per period
nper - total number of payment periods
pmt - payment made during each period (cannot be changed)
fv - future value
type - indicates when a payments are due (0 or omitted = end of period; 1 = beginning of period)
go inside cell to clear specific info - ANS-ALT h e
go inside cell to see functions - ANS-F2
highlight all columns next - ANS-ctrl shift > / <
highlight column - ANS-ctrl space
Highlight from active cell to last used cell in worksheet - ANS-CRTL Shift End
Excel Basics - Wall Street Prephttps://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch https://www.stuvia.com/user/allatopnotch
2026-09-08https://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch
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
Excel Basics - Wall Street Prephttps://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch https://www.stuvia.com/user/allatopnotch
, https://www.stuvia.com/user/allatopnotch
2026-09-08https://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch
Fill Highlighted Area Right / Down - ANS-ctrl r / ctrl d
Fill Multiple Cells at Same Time - ANS-Highlight Cells; Type in Info; Cntrl + Enter
Fill Right / Fill Down - ANS-Ctrl+R / Ctrl+D
find and replace - ANS-ctrl h
find which boxes hardcoded - ANS-F5 ALT SOX
First/Last Used Cell in Worksheet - ANS-CTRL Home/End
Floor - ANS-Floor(cell, significance) round down to the nearest x, specified by significance
Format Painter - ANS-You can use Ctrl+Shift+Cto copy a format, and Ctrl+Shift+Vto paste a
format.
formatting - ANS-ctrl 1
freeze pane - ANS-alt w f f
To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the
worksheet scrolls.
Freeze Panes - ANS-[Alt],[W],[F],[F]
FV - ANS-FV(rate, nper, pmt, fv, type) - Returns the future value of an investment based on
constant and interest rate
rate - interest rate per period
nper - total number of payment periods
pmt - payment made during each period (cannot be changed)
fv - future value
type - indicates when a payments are due (0 or omitted = end of period; 1 = beginning of period)
go inside cell to clear specific info - ANS-ALT h e
go inside cell to see functions - ANS-F2
highlight all columns next - ANS-ctrl shift > / <
highlight column - ANS-ctrl space
Highlight from active cell to last used cell in worksheet - ANS-CRTL Shift End
Excel Basics - Wall Street Prephttps://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch https://www.stuvia.com/user/allatopnotch
