Business Productivity Tools, 4th Edition 2016

YouTube Videos for Office 2010 and 2013:

Toolkit

AutoFill Handle

Special Formats

Wrap Text

Formula Bar

Freeze Panes

Protection

Macros

Visual Basic Editor Window - 2013 tutorial

Debugging Macros 2013 tutorial

Mac Help - Video 1

Mac Help - Video 2

Running macros from a validation list (this one is a bit challenging)

VBA Basics Tutorial

Making Decisions In VBA

Creating and Using Loops In VBA

Formulas

Cell References

Formula Bar and Name Box

Lookup Functions

VLOOKUP Function

If Functions

IF and AND

COUNTIF

Filters

Logic Functions

Function Basics

Dialog Box

AutoSum Icon

Rounding

Data Tools

Visible Cells

Advanced Filters

More Data Tools

Form Tool

Dash Boards

Conditional Formatting

Dashboard Formatting

Introduction to Pivot Tables, Charts, and Dashboards for the MAC

Create a checkbox

2010 Speedeometer Dashboard

2013 Speedometer Dashboard

2013 Gantt Chart

2013 Beer Mug DashBoard

2013 Thermometer Chart

Charts

Combination Charts

PowerPoint

Transitions

Slide Master

Combine Images

Pivot Tables

Intro Pivots

Pivot Table Tools

Slicers

Pivot Charts