Wall
Street
Prep:
Excel
Crash
Course
Keyboard
Versus
the
Mouse
Almost
everything
that
can
be
done
in
Excel
using
a
mouse
can
also
be
done
using
the
keyboard
shortcuts
Best
way
to
learn
is
to
disconnect
the
mouse
and
work
through
Excel
using
only
the
keyboard
Name
Box
Tells
you
what
cell
you
are
in
(top
left
below
the
ribbon)
Brainpower
Read
More
Previous
Play
Next
Rewind
10
seconds
Move
forward
10
seconds
Unmute
0:01
/
0:15
Full
screen
Formula
Bar
When
you
insert
a
formula
into
a
cell
and
hit
return,
the
cell
will
show
you
the
output
The
formula
bar,
however,
will
show
you
the
formula
Next
to
"fx"
right
below
the
ribbon
Worksheets
An
Excel
file
is
called
a
workbook;
You
start
with
1
worksheet
but
you
can
add/delete
more
The
active
worksheet
is
highlighted
in
Excel
Moving
Between
Worksheets
Ctrl
+
PageDown/PageUp
(Option
+
RightArrow/LeftArrow) Adding
Worksheets
(Fn
Shift
F11)
Columns
Alphabetically
labeled
(A,
B,
C,
etc.)
Rows
Numerically
labeled
(1,
2,
3,
etc.)
Main
tabs
Although
we
focus
on
shortcuts,
virtually
all
commands,
functions,
and
Excel
features
can
be
accessed
through
the
task-oriented
tabs
which
organize
them
into
nine
logical
categories:
(1)
Home
(2)
Insert
(3)
Draw
(4)
Page
Layout
(5)
Formulas
(6)
Data
(7)
Review
(8)
View
(9)
Developer
How
to
Access
Ribbon
on
Mac
Ctrl
Fn
F2
Use
arrow
keys
to
peruse
the
Mac
ribbon
Mac
Settings
to
Disable
(1)
Function
Keys:
Settings
-
Keyboard
-
Use
F1,
F2,
etc.
keys
as
standard
function
keys
(2)
Mission
Control:
System
Preferences
-
Keyboard
-
Shortcuts
-
Mission
Control
-
Disable
"Move
a
space
left"
and
"Move
a
space
right"
to
use
Ctrl
RightArrow
or
Ctrl
LeftArrow
Using
Function
Keys
Hit
Fn
and
then
the
function
key
to
use
the
function
keys
themselves
on
a
Mac
Open
a
New
Workout
Ctrl
N Cmnd
N
The
File
Tab
Many
Excel
features
(Open
file,
Save
file,
Print
file,
etc.)
are
located
in
this
tab
Excel
also
has
alternative
keyboard
shortcuts
(using
Ctrl)
for
many
of
these
features
Open
a
File:
Ctrl
O
(Cmnd
O)
Save
a
File:
Ctrl
S
(Cmnd
S)
Print
a
File:
Ctrl
P
(Cmnd
P)
Save
a
File
Ctrl
S
Cmnd
S
Print
a
File
Ctrl
P
Cmnd
P
Open
a
File
Ctrl
O
Cmnd
O
Toolbars
Within
each
of
the
main
tabs
you
will
find
all
of
Excel's
features,
grouped
by
commands
Navigating
to
the
Toolbars
Without
the
Mouse
Hit
Alt
and
the
appropriate
letter
(or
use
the
right/left
arrow
keys)
to
get
to
the
desired
tab
Once
there,
use
the
Tab
and
Shift
Tab
keys
to
navigate
around,
the
Space
to
open
a
drop
down,
and
Enter
to
select
Bold
Command
Ctrl
B
Cmnd
B
The
Home
Tab
Includes
most
formatting
properties:
Font
type,
size,
and
color
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Ashley96. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.