Module 1
1.1 Data Analysis Categories
1.2 4-Steps of Data Analysis and Management
1.3 Data Management Tools
1.4 Step 1: Importing Data into Excel
1.5 Practice Exercise #1 – Import an Access Database table into Excel
1.6 Practice Exercise #2 – Import a Comma Separated Value (CSV) text file into Excel
1.7 About External Data Connections
1.2 4-Steps of Data Analysis and Management
1.3 Data Management Tools
1.4 Step 1: Importing Data into Excel
1.5 Practice Exercise #1 – Import an Access Database table into Excel
1.6 Practice Exercise #2 – Import a Comma Separated Value (CSV) text file into Excel
1.7 About External Data Connections
Module 1 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led video(s), at the end of the module the student will be able to:
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led video(s), at the end of the module the student will be able to:
- List the categories of Excel data analysis
- List the various data analysis tools used to clean up, sort, and categorize imported data
- Imitate the instructor’s action necessary for importing a Comma Separated Value data file
- Imitate the instructor’s action necessary for importing a table from Microsoft Access
- Imitate the instructor’s action necessary for importing another Excel table
| You do this: | PowerPoint does this: | Further action to take: |
|---|---|---|
| You open a presentation that was created with PowerPoint 97-2003 | *PowerPoint opens the workbook in compatibility mode and keeps it in PowerPoint 97-2003 file format (*.ppt) | Keep working in compatibility mode if you’re sharing the presentation with people who don’t have PowerPoint 2016. *If you’re not sharing the presentation, convert it to the PowerPoint 2007-2016 file format (*pptx) to take advantage of PowerPoint 2016 features (Using the Backstage View) |
| You save your presentation as an PowerPoint 2016 file | PowerPoint saves the workbook in the PowerPoint 2007-2016 file format (*.pptx) so you can take advantage of PowerPoint 2016 features. | If you plan to share this presentation with people who use an earlier version of PowerPoint, check the presentation for compatibility issues(click File>Info>Check for issues |
| You save your presentation as a PowerPoint 97-2003 file. | PowerPoint automatically checks the file for compatibility issues and shows them for any new PowerPoint 2016 features you used. | Assess any compatibility issues and resolve them before you share the presentation |
FIGURE 2