-
Use highlight
cells rules
-
Clear rules
-
Use top/bottom
rules
-
Apply data bars,
color scales, & icon sets
-
Create, edit, &
manage formatting rules
-
Create,
navigate, move, & select a table
-
Change the table
style option
-
Insert and
delete rows and columns
-
Display
calculations in the total row
-
Convert a table
to a range
-
Sort rows by
column(s), cell color, font color, icon, & using a built-in custom
list
-
Create and
remove a custom list
-
AutoFilter a
list and clear an AutoFilter
-
Create a custom
AutoFilter using criteria
-
AutoFilter by
color or icon, top or bottom numbers, above or below average
numbers, and advanced criteria
-
Convert text to
columns
-
Remove
duplicates
-
Manually outline
a worksheet
-
Collapse,
expand, ungroup, & clear an outline
-
Use Auto Outline
-
Create & remove
subtotals & grand totals
-
Link cells by
connecting worksheets
-
Link worksheets
using a connecting formula and a connecting function
-
Link workbooks
using a connecting formula and using a connecting function
-
Return the
current date using TODAY
-
Return the
current date & time using NOW
-
Return any date
using DATE
-
Change the case
of text using UPPER, LOWER, and PROPER
-
Remove excess
spaces using TRIM
-
Repeat text
using REPT
-
Extract with
LEFT, RIGHT, & MID
-
Join text
strings using CONCATENATE
-
Use VLOOKUP &
HLOOKUP
-
Calculate a
payment using PMT
-
Return the
future value using FV
-
Use ROUND,
ROUNDUP, & ROUNDDOWN
-
Truncate a
number using TRUNC
-
Sum cells using
SUMIF
-
Use IF and the
nested IF function
-
Test for
multiple criteria using AND & OR
-
Create,
activate, move, resize, & delete an embedded chart
-
Print charts
-
Select, resize,
and move a chart element
-
Change the
layout of chart elements
-
Format chart
elements
