| Excel 2016 |
| 02 01 What is Excel used
for HOW TO Excel 2016 Tutorials |
| 02 02 Using the menu
system HOW TO Excel 2016 Tutorials |
| 02 03 Using the Quick
Access Toolbar HOW TO Excel 2016
Tutorials |
| 02 04 Understanding
workbooks and worksheets HOW TO Excel
2016 Tutorials |
| 02 05 Using the Formula
bar HOW TO Excel 2016 Tutorials |
| 02 06 Using the Status
bar HOW TO Excel 2016 Tutorials |
| 02 07 Using navigation
tools HOW TO Excel 2016 Tutorials |
| 02 08 Using shortcut menus
and the Mini toolbar HOW TO Excel
2016 Tutorials |
| 02 09 Creating new
workbooks HOW TO Excel 2016 Tutorials |
| 02 10 Using Excel
Help HOW TO Excel 2016 Tutorials |
| 03 01 Exploring data entry
and editing techniques HOW TO Excel
2016 Tutorials |
| 03 02 Entering data with
AutoFill HOW TO Excel 2016 Tutorials |
| 03 03 Working with dates
and times HOW TO Excel 2016 Tutorials |
| 03 04 Using Undo and
Redo HOW TO Excel 2016 Tutorials |
| 03 05 Adding comments HOW TO Excel 2016 Tutorials |
| 03 06 Using Save or Save
As HOW TO Excel 2016 Tutorials |
| 04 01 Creating simple
formulas HOW TO Excel 2016 Tutorials |
| 04 02 Copying a formula
into adjacent cells HOW TO Excel 2016
Tutorials |
| 04 03 Calculating
yeartodate totals HOW TO Excel 2016
Tutorials |
| 04 04 Creating a
percentagechange formula HOW TO Excel
2016 Tutorials |
| 04 05 Working with
relative, absolute, and mixed references
HOW TO Excel 2016 Tutorials |
| 04 06 Using SUM and
AVERAGE HOW TO Excel 2016 Tutorials |
| 04 07 Using other common
functions HOW TO Excel 2016 Tutorials |
| 05 01 Exploring font
styles and effects HOW TO Excel 2016
Tutorials |
| 05 02 Adjusting row
heights and column widths HOW TO
Excel 2016 Tutorials |
| 05 03 Working with
alignment and Wrap Text HOW TO Excel
2016 Tutorials |
| 05 04 Designing
borders HOW TO Excel 2016 Tutorials |
| 05 05 Exploring numeric
and special formatting HOW TO Excel
2016 Tutorials |
| 05 06 Formatting numbers
and dates HOW TO Excel 2016 Tutorials |
| 05 07 Using conditional
formatting HOW TO Excel 2016
Tutorials |
| 05 08 Creating and using
tables HOW TO Excel 2016 Tutorials |
| 05 09 Inserting shapes,
arrows, and other visual features HOW
TO Excel 2016 Tutorials |
| 06 01 Inserting and
deleting rows and columns HOW TO
Excel 2016 Tutorials |
| 06 02 Hiding and unhiding
rows and columns HOW TO Excel 2016
Tutorials |
| 06 03 Moving, copying, and
inserting data HOW TO Excel 2016
Tutorials |
| 06 04 Finding and
replacing data HOW TO Excel 2016
Tutorials |
| 07 01 Exploring the Page
Layout tab and Page Layout view HOW
TO Excel 2016 Tutorials |
| 07 02 Previewing page
breaks HOW TO Excel 2016 Tutorials |
| 07 03 Working with Page
Setup and printing controls HOW TO
Excel 2016 Tutorials |
| 08 01 Creating charts HOW TO Excel 2016 Tutorials |
| 08 02 Exploring chart
types HOW TO Excel 2016 Tutorials |
| 08 03 Formatting
charts HOW TO Excel 2016 Tutorials |
| 08 04 Working with axes,
titles, and other chart elements HOW
TO Excel 2016 Tutorials |
| 08 05 Creating incell
charts with sparklines HOW TO Excel
2016 Tutorials |
| 09 01 Freezing and
unfreezing panes HOW TO Excel 2016
Tutorials |
| 09 02 Splitting screens
horizontally and vertically HOW TO
Excel 2016 Tutorials |
| 09 03 Collapsing and
expanding data views with outlining
HOW TO Excel 2016 Tutorials |
| 10 01 Displaying multiple
worksheets and workbooks HOW TO Excel
2016 Tutorials |
| 10 02 Renaming, inserting,
and deleting sheets HOW TO Excel 2016
Tutorials |
| 10 03 Moving, copying, and
grouping sheets HOW TO Excel 2016
Tutorials |
| 10 04 Using formulas to
link worksheets and workbooks HOW TO
Excel 2016 Tutorials |
| 10 05 Locating and
maintaining links HOW TO Excel 2016
Tutorials |
| 11 01 Using IF functions
and relational operators HOW TO Excel
2016 Tutorials |
| 11 02 Getting approximate
table data with the VLOOKUP function
HOW TO Excel 2016 Tutorials |
| 11 03 Getting exact table
data with the VLOOKUP function HOW TO
Excel 2016 Tutorials |
| 11 04 Using the COUNTIF
family of functions HOW TO Excel 2016
Tutorials |
| 12 01 Exporting tables to
Excel Microsoft Access 2016
Training Tutorial |
| 12 01 Unlocking cells and
protecting worksheets HOW TO Excel
2016 Tutorials |
| 12 02 Protecting
workbooks HOW TO Excel 2016 Tutorials |
| 12 03 Assigning passwords
to workbooks HOW TO Excel 2016
Tutorials |
| 12 04 Sharing
workbooks HOW TO Excel 2016 Tutorials |
| 12 05 Tracking
changes HOW TO Excel 2016 Tutorials |
| 13 01 Sorting data HOW TO Excel 2016 Tutorials |
| 13 02 Inserting subtotals
in a sorted list HOW TO Excel 2016
Tutorials |
| 13 03 Using filters HOW TO Excel 2016 Tutorials |
| 13 04 Splitting data into
multiple columns HOW TO Excel 2016
Tutorials |
| 13 05 Splitting and
combining columnar data with Flash Fill
HOW TO Excel 2016 Tutorials |
| 13 06 Removing duplicate
records HOW TO Excel 2016 Tutorials |
| 13 07 Using validation
tools HOW TO Excel 2016 Tutorials |
| 14 01 Using Goal Seek HOW TO Excel 2016 Tutorials |
| 14 02 Using Solver HOW TO Excel 2016 Tutorials |
| 14 03 Using Scenario
Manager HOW TO Excel 2016 Tutorials |
| 14 04 Using data
tables HOW TO Excel 2016 Tutorials |
| 15 01 Creating
PivotTables HOW TO Excel 2016
Tutorials |
| 15 02 Manipulating
PivotTable data HOW TO Excel 2016
Tutorials |
| 15 03 Grouping by date and
time HOW TO Excel 2016 Tutorials |
| 15 04 Grouping by other
factors HOW TO Excel 2016 Tutorials |
| 15 05 Using slicers to
clarify and manipulate fields HOW TO
Excel 2016 Tutorials |
| 15 06 Using
PivotCharts HOW TO Excel 2016
Tutorials |
| 16 01 Exploring the need
for macros HOW TO Excel 2016
Tutorials |
| 16 02 Creating a simple
macro HOW TO Excel 2016 Tutorials |
| 16 03 Running a macro HOW TO Excel 2016 Tutorials |
