Create, Edit, and Format Tables
and Spreadsheets How
to Use This Guide |
Format Cells
(Number, Alignment, Font, Border)
 |
- Apply Fill Colors to Data
à
Microsoft Excel Help
à
Type apply or remove cell shading
in Search Box
|
- Alignment of Data
à
Open and login to
Atomic Learning
à
Type
alignment of
data in the Search box and choose PC in the
Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
à
Microsoft Excel Help à
Type reposition data in a cell in
Search Box
|
- Wrap Text within Cells
à
Open and login to
Atomic Learning
à
Type
wrap text
in the Search box and choose PC in the
Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
à
Microsoft Excel Help à
Type wrap text in a cell in Search Box
|
- Use Format Painter
à
Open and login to
Atomic Learning
à
Type
format painter
in the Search box and choose PC in the
Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
à
Microsoft Excel Help à
Type copy formatting or format
painter in
Search Box
|
| Add/Modify Charts
|
- Create Charts
à
Open and login to
Atomic Learning
à
Type
create charts
in the Search box and choose PC in the
Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
à
Microsoft Excel Help à
Type create charts in Search Box
|
- Modify Chart Labels
à
Open and login to
Atomic Learning
à
Type
chart labels
in the Search box and choose PC in the
Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
à
Microsoft Excel Help à
Type add or remove labels in a chart or edit
titles or labels in a chart in Search Box
|
| Sort
and Filter Data |
- Find and Select
à
Open and login to
Atomic Learning
à
Type
find, or
select
in the Search box and choose PC in the
Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
à
Microsoft Excel Help
à
Type find and select or find and
replace in Search Box
|
- Filter Data
à
Open and login to
Atomic Learning
à
Type
filter data
in the Search box and choose PC in the
Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
à
Microsoft Excel Help à
Type filter data, or reapply a filter,
or
clear a filter in Search Box
|
- Paste Special and Fill
à
Open and login to
Atomic Learning
à
Type
autofill, fill, or
paste special in the Search box and choose PC in the
Platforms dropdown menu à
To filter further choose
Excel
from the Applications drop down menu
à
Search
suggestions
à
Microsoft Excel Help à
Type paste special, or fill in Search Box
|
|
Formulas
|
Basic Formulas (sum, countif,
min, max, avg)
à
Open and login to
Atomic Learning
à
Type
formulas in
the Search box and choose PC in the Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
à
Microsoft Excel Help
à
Type formulas, or sum, or count
if, etc.
in Search Box |
|
Merge/Split
Cells
|
- Merge Cells
à
Open and login to
Atomic Learning
à
Type
merge cells
in the Search box and choose PC in the
Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
- Splitting Cells
à
Open and login to
Atomic Learning
à
Type
split cells
in the Search box and choose PC in the
Platforms drop
down menu à
To filter further choose Excel
from the
Applications drop down menu
à
Search suggestions
|
| Page
Layout
(Themes, Margins, Print Area)
|
- Page Setup
à
Open and login to
Atomic Learning
à
Type
page layout, or
page setup in the Search box and choose PC in the
Platforms dropdown menu à
To filter further choose
Excel
from the Applications drop down menu
à
Search
suggestions
à
Microsoft Excel Help à
Type page setup in Search Box
|
- Set, Print and Clear Print Areas
à
Open and login to
Atomic Learning
à
Type
set print area,
or clear print area in the Search box and choose PC in the
Platforms drop down menu à
To filter further choose Excel
from the Applications drop down menu
à
Search suggestions
à
Microsoft Excel Help à
Type preview worksheet pages before
printing, or define,
or print or clear a print area on a worksheet
in
Search Box
|
-
Set Page Margins and Worksheet Alignment
à
Open and login to
Atomic Learning
à
Type
margins, page
margins, alignment in the Search box and choose PC in
the Platforms drop down menu à
To filter further choose
Excel
from the Applications drop down menu
à
Search
suggestions
à
Microsoft Excel Help à
Type set page margins in Search Box |
-
Print Titles
à
Open and login to
Atomic Learning
à
Type
print titles in the
Search box and choose PC in the Platforms drop down
menu à
To filter further choose Excel
from the Applications
drop down menu à
Search suggestions
à
Microsoft Excel Help à
Type print titles in Search Box
|
|
à
Microsoft Excel Help
à
Type repeating row in Search Box
|
-
Create Headers and Footers
à
Open and login to
Atomic Learning
à
Type
headers, or
footers in the Search box and choose PC in the
Platforms dropdown menu à
To filter further choose
Excel
from the Applications drop down menu
à
Search
suggestions
à
Microsoft Excel Help à
Type headers, or footers in Search Box
|
|
|
Technology
Integration
