Instructor for this course
more
To Access This Course:

This course expands the previous discussion about external data and digs into the details for retrieving data from other sources. We pull data from an Access database using Microsoft Query. We learn how to retrieve data from simple text files as well, and how to prepare data for use with Excel. This session concludes by examining several data visualization tools in Excel, including PivotCharts.

Course Series

This course is included in the following series:

4 CoursesPivotTable Essentials

  1. PivotTable Essentials
  2. How to Use PivotTables instead of Formula-Based Reports
  3. PivotTable Conclusion and External Data Introduction
  4. Using PivotTables and PivotCharts to Prepare External Data

Learning Objectives

  • Explore the process for creating a PivotChart
  • Recognize the option that imports external data directly into a PivotTable
  • Identify which Excel feature creates a chart within a single worksheet cell
Last updated/reviewed: February 04, 2018

Included In Certifications

This course is included in the following Expert Certifications:

9 CoursesExcel for Professional Applications Certification

  1. Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
  2. Excel Training: Skills for Better Workbook Design
  3. Excel Training: Boosting Proficiency with Selected Shortcuts (PC version)
  4. Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
  5. Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
  6. PivotTable Essentials
  7. How to Use PivotTables instead of Formula-Based Reports
  8. PivotTable Conclusion and External Data Introduction
  9. Using PivotTables and PivotCharts to Prepare External Data

3 Reviews (6 ratings)Reviews

5
Member's Profile
Excellent course!! Definitely one of the best offers for it value and how is explained each of these courses.
4
Member's Profile
Contains lots of useful processes for anyone working with accounting data on a daily basis.
5
Member's Profile
Appreciate the thorough review, especially the foray into graphics.

Prerequisites

Course Complexity: Advanced

No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  21:00Chapter 22: External Data Part 1
  9:41Chapter 22: External Data Part 2
  11:17Chapter 23: Text Files
  18:45Chapter 24: Data Preparation
  17:21Chapter 25: Accounting System Data Part 1
  5:19Chapter 25: Accounting System Data Part 2
  13:40Chapter 26: Getting Graphic Part 1
  10:58Chapter 26: Getting Graphic Part 2
CONTINUOUS PLAY
  1:48:02Using PivotTables and PivotCharts to Prepare External Data
SUPPORTING MATERIALS
  ZIPSupporting Files: Using PivotTables and PivotCharts to Prepare External Data
  PDFUsing PivotTables and PivotCharts to Prepare External Data Glossary
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM