|
Welcome Guest (
.
|
.
)
Home
Tips for videos
Home
About Us
Contact Us
Samples
Testimonials
Individual Join
Corporate Join
Tim Owens
Take a class
Microsoft Excel 2016 Intermediate Course
Click a link below to get started
(click to go back)
Unit 1 - Printing
1.
Print repeating columns
2.
Print repeating rows
3.
Remove repeating rows
4.
Remove repeating columns
5.
Print problem #1 solved
6.
Print area set
7.
Print area clear
8.
Print area set #2
9.
Print area clear #2
10.
Print selection
11.
Print multiple copies
12.
Print problem #2 solved
13.
Print active sheet
14.
Print entire workbook
15.
Print page one only
Unit 2 - Advanced Formulas (Formulas #2 of 4)
1.
Multiple worksheet formula
2.
Multiple workbook formula
3.
Insert Function box explained
4.
Insert Function box
5.
Average
6.
Minimum
7.
IF formula
8.
AND formula
9.
Tip and Trick
10.
OR Formula
11.
SUMIF Formula
12.
COUNTIF Formula
13.
NOW TODAY Formula
14.
HLOOKUP approximate
15.
HKLOOKUP exact
16.
VLOOKUP exact
17.
VLOOKUP approximate
Unit 3 - Named Ranges
1.
Named Ranges -What are they
2.
Name a range - first way
3.
Name a range - second way
4.
Use a range in a formula - first way
5.
Use a range in a formula - second way
6.
Named range - rename
7.
Named range - modify
8.
Named range delete
9.
Unit 4 - Tables
1.
Table create a
2.
Table tab
3.
Table drop down arrow
4.
Table filter arrows
5.
Table banded row
6.
Table header row
7.
Table quick styles
8.
Table total row
9.
Sharepoint -export table to
10.
Table filter arrows disabled
11.
Table to no table
12.
Table create table
13.
Table insert row column
14.
Table filtering
15.
Table turn off filtering
16.
Table sort your data
17.
Table top 10 answers
18.
Table filters off
19.
Table multiple columns
Unit 5 - Charts
1.
Chart create
2.
Chart create #2
3.
Chart move a
4.
Chart create #3
5.
Chart larger or smaller
6.
Chart add labels call outs
7.
Chart change the look
8.
Chart change type
9.
Chart change background
10.
Chart change text colors
11.
Chart - chart elements
12.
Chart chart styles
13.
Chart more chart styles
14.
Chart layouts
Unit 6 - Data Analysis / Headers and Footers
1.
Header insert
2.
Header change it
3.
Footer insert
4.
Footer Page x of y
5.
Footer file name / path
6.
Normal view from Header view
7.
Header / footer delete it
8.
Trace precedent
9.
Trace dependent
10.
Formulas - show / hide
11.
Formula - check for errors
12.
Watch window
13.
Watch window show / hide
14.
Data validation error check
15.
Data validation remove
16.
Duplicate entries find
17.
Separate first / last names
18.
Separate dates in a column
19.
Duplicates remove
