O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Excel - Managing Multiple Worksheets

Video Description

In this Microsoft Excel – Managing Multiple Worksheets training course, expert author Erin Olsen teaches you how to manage multiple worksheets in this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel.
You will start by preparing for dispersed data and grouping worksheets. Erin will show you how to properly format multiple worksheets, including creating and applying styles, applying conditional formatting, and creating quick formatting macros. This video tutorial will also teach you how to calculate disperse data, reference and summarize data, and perform data consolidation. Finally, Erin will show you how to bring your data together, edit data links, and create and use Excel views.
By the completion of this computer based training course, you will be fully capable of managing multiple worksheets using the tools available in Microsoft Excel. Working files are included, allowing you to follow along with the author throughout the lessons.

Table of Contents

  1. Overview
    1. Why Worry About Multiple Worksheets And External Data? 00:05:08
    2. What You Will Learn 00:04:03
    3. Learning The Way You Need 00:07:17
    4. About The Author 00:04:21
    5. How To Access Your Working Files 00:02:45
    6. Using The Working Files 00:03:37
  2. Preparing For Dispersed Data
    1. Preparing For Dispersed Data 00:11:35
    2. Worksheet Basics Review - Part 1 00:08:04
    3. Worksheet Basics Review - Part 2 00:10:21
    4. Simplifying References With Names 00:09:21
    5. Grouping Worksheets 00:05:37
  3. Formatting Multiple Worksheets
    1. Formatting Multiple Worksheets - Part 1 00:09:00
    2. Formatting Multiple Worksheets - Part 2 00:10:12
    3. Creating And Applying Styles 00:12:29
    4. Applying Conditional Formatting To Multiple Worksheets 00:10:22
    5. Creating Quick Formatting Macros 00:07:46
  4. Calculating Disperse Data
    1. Calculating Disperse Data - Part 1 00:07:51
    2. Calculating Disperse Data - Part 2 00:06:33
    3. Calculations 101 - Refresher 00:10:09
    4. Referencing Data In Other Locations 00:12:15
    5. Summarizing Data Using 3-Dimensional Formulas 00:06:23
    6. Keeping Track Of Values With The Watch Window 00:07:30
    7. Performing Data Consolidation 00:06:22
  5. Leveraging Data From Other Sources
    1. Leveraging Data From Other Sources 00:12:43
    2. Importing Text Files 00:06:43
    3. Connecting To Access Databases 00:06:13
    4. Using Data From The Web 00:06:37
    5. Populating Worksheets With SharePoint Data 00:05:49
  6. Bringing Data Together
    1. Bringing Data Together 00:09:46
    2. Creating Relationships 00:09:01
    3. Refreshing Linked Data 00:04:41
    4. Editing Data Links 00:07:41
    5. Managing Data Connections 00:06:00
    6. Viewing Data Connection Settings 00:08:33
    7. Creating And Using Excel Views 00:10:02
  7. Course Wrap-Up
    1. What You Now Know 00:05:41