SAVE UP TO 20% ON ILLUMEO CPE SUBSCRIPTIONS SAVE NOW

This course is a premium course it can be accessed either by individual purchase or through a premium subscription

Purchase this course | $72

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: August 6, 2023

Included In Certifications

This course is included in the following Certification Programs:

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
5 Reviews (14 ratings)

Reviews

5
Anonymous Author
There are many ribbon icons that have much greater use and depth than I ever realized. I really appreciated learning so much more about those, and the way to explore what will work well for me.

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
Anonymous Author
Very thorough and easy to understand. Examples are great. Definitely recommend.

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 .
Instructor for this course
Course Syllabus
INTRODUCTION AND OVERVIEW
  Chapter 22: External Data Part 121:00
  Chapter 22: External Data Part 29:41
  Chapter 23: Text Files11:17
  Chapter 24: Data Preparation18:45
  Chapter 25: Accounting System Data Part 117:21
  Chapter 25: Accounting System Data Part 25:19
  Chapter 26: Getting Graphic Part 113:40
  Chapter 26: Getting Graphic Part 210:58
CONTINUOUS PLAY
  Using PivotTables and PivotCharts to Prepare External Data1:48:02
SUPPORTING MATERIALS
  Supporting Files: Using PivotTables and PivotCharts to Prepare External DataZIP
  Using PivotTables and PivotCharts to Prepare External Data GlossaryPDF
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam