Books & Videos

Table of Contents

Chapter: Overview

Why Worry About Multiple Worksheets And External Data?

05m 8s

What You Will Learn

04m 2s

Learning The Way You Need

07m 17s

About The Author

04m 21s

How To Access Your Working Files

01m 15s

Using The Working Files

03m 36s

Chapter: Preparing For Dispersed Data

Preparing For Dispersed Data

11m 34s

Worksheet Basics Review - Part 1

08m 4s

Worksheet Basics Review - Part 2

10m 20s

Simplifying References With Names

09m 20s

Grouping Worksheets

05m 37s

Chapter: Formatting Multiple Worksheets

Formatting Multiple Worksheets - Part 1

09m 0s

Formatting Multiple Worksheets - Part 2

10m 12s

Creating And Applying Styles

12m 28s

Applying Conditional Formatting To Multiple Worksheets

10m 21s

Creating Quick Formatting Macros

07m 46s

Chapter: Calculating Disperse Data

Calculating Disperse Data - Part 1

07m 51s

Calculating Disperse Data - Part 2

06m 32s

Calculations 101 - Refresher

10m 9s

Referencing Data In Other Locations

12m 15s

Summarizing Data Using 3-Dimensional Formulas

06m 22s

Keeping Track Of Values With The Watch Window

07m 29s

Performing Data Consolidation

06m 22s

Chapter: Leveraging Data From Other Sources

Leveraging Data From Other Sources

12m 42s

Importing Text Files

06m 42s

Connecting To Access Databases

06m 13s

Using Data From The Web

06m 36s

Populating Worksheets With SharePoint Data

05m 48s

Chapter: Bringing Data Together

Bringing Data Together

09m 45s

Creating Relationships

09m 0s

Refreshing Linked Data

04m 40s

Editing Data Links

07m 41s

Managing Data Connections

06m 0s

Viewing Data Connection Settings

08m 33s

Creating And Using Excel Views

10m 2s

Chapter: Course Wrap-Up

What You Now Know

05m 40s