-
Use highlight
cells rules
-
Clear rules
-
Use top and bottom
rules
-
Apply data bars, color
scales, and icon sets
-
Create, edit, and
manage formatting rules
-
Create, navigate, move,
& select a table
-
Change the table style
options
-
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, and 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
-
Change chart type
-
Print charts
-
Select, resize, and
move a chart element
-
Change the layout of
chart elements
-
Format chart elements
