Finance Club at Virginia Tech
Microsoft Office Skills
-
Powerpoint Tips (Replace Command with CTRL for Windows)
-
F5
-
Presentation mode
-
-
Command Shift +
-
Zoom in
-
-
Command Shift -
-
Zoom out
-
-
Command L in presentation mode
-
Brings up laser pointer
-
-
Make it so each bullet is brought in each time you click enter
-
Allows you to keep audience's attention
-
Can just show the picture or table before all the bullets
-
-
Shift Up/down/left/right arrow keys
-
Change the size of textboxes
-
-
How to get rid of crick in line (when line is not straight)
-
Go to shape format and make height zero
-
-
Command shift c
-
Copy formatting
-
-
Command shift v
-
Paste formatting
-
-
Command shift > and command shift <
-
Alter font size
-
-
Command shift D
-
Duplicates slides
-
-
Shift option
-
Moves the order of bullet points
-
-
Utilize Designer Mode to make slides visually appealing
-
Slide Master
-
Add a picture or page number that will show up on every slide
-
-
-
Excel Tips (Replace Command with CTRL for Windows)
-
Control shift 7
-
Add border to cells
-
-
Command shift T
-
Create Sum formula for the cells above current cell
-
-
Control shift 4
-
Format cell with Currency formatting
-
-
Command R
-
Copies to the right
-
-
Command D
-
Copies down
-
-
Command 1
-
Format cell box
-
-
F4 function
-
Repeats your most recent action
-
-
Can reference cell and use & “text” to add text to cell
-
Ex. C4&" Inches"
-
-
Command Alt V
-
Paste special
-
-