1
.
____________________
____________________
____________________
:
The
most
used
functions
in
Excel
are
the
functions
that
count
and
sum
.
You
can
count
and
sum
based
on
one
criteria
or
multiple
criteria
.
2
____________________
:
Learn
how
to
use
Excel's
logical
functions
such
as
the
IF
,
AND
,
OR
and
NOT
function
.
3
____________________
____________________
:
Cell
references
in
Excel
are
very
important
.
Understand
the
difference
between
relative
,
absolute
and
mixed
reference
,
and
you
are
on
your
way
to
success
.
4
____________________
&
____________________
:
To
enter
a
date
in
Excel
,
use
the
"
/
"
or
"
-
"
characters
.
To
enter
a
time
,
use
the
"
:
"
(
colon
)
.
You
can
also
enter
a
date
and
a
time
in
one
cell
.
5
____________________
:
Excel
has
many
functions
to
offer
when
it
comes
to
manipulating
text
strings
.
6
____________________
&
____________________
:
Learn
all
about
Excel's
lookup
&
reference
functions
such
as
the
VLOOKUP
,
HLOOKUP
,
MATCH
,
INDEX
and
CHOOSE
function
.
7
____________________
:
This
chapter
illustrates
Excel's
most
popular
financial
functions
.
8
____________________
:
An
overview
of
some
very
useful
statistical
functions
in
Excel
.
9
____________________
:
This
chapter
illustrates
three
functions
to
round
numbers
in
Excel
.
The
ROUND
,
ROUNDUP
and
ROUNDDOWN
function
.
10
____________________
____________________
:
This
chapter
teaches
you
how
to
deal
with
some
common
formula
errors
in
Excel
.
11
____________________
____________________
:
This
chapter
helps
you
understand
array
formulas
in
Excel
.
Single
cell
array
formulas
perform
multiple
calculations
in
one
cell
.