| |Microsoft Excel 2010 Level 3 Databases
| |
ID: SAE102 | Course Length: 1 |  |
|
| | |
Module 0: Course Details |
| | | - Duration:1 Day Webinar Or Instructor-led Classroom Setting
- Prerequisite
- This Course Assumes Intermediate Experience with Excel
- Objectives:this Course Will Cover
- Give a Brief Overview of All the Tabs in the Ribbon
- Work with Databases Functions
- Create Pivot Tables
|
 |
| | |
Module 1: Working with Data |
| | | - What Is a Database
- Designing a Database
- Create a Database
- Data Validation
- Using Sparklines
|
|
| | |
Module 2: Sorting and Filters |
| | | - Sorting Databases
- Auto Filters and Advanced Filters
|
|
| | |
Module 3: Linking, Consolidating, and Combining Data |
| | | - Linking Cells
- Linking Worksheets
- Linking Workbooks
- Consolidating Data
- Using Paste Special
|
|
| | |
Module 4: Protecting Data |
| | | - Protect Cells
- Protecting Worksheets
- Protecting Workbooks
- Protecting Files
|
|
| | |
Module 5: Outlining and Grouping Data |
| | | - Using Automatic Outlining
- Displaying and Collapsing Levels
- Grouping Data Manually
- Creating Subtotals
|
|
| | |
Module 6: Pivot Tables |
| | | - What Is a Pivottable
- Creating a Pivottable
- Rearrange a Pivottable
- Format a Pivottable
- Create a Pivotchart
- Using Slicer Filter
|
|
| | |
Module 7: What-if Analysis |
| | | - Using Scenarios
- Using Goal Seek
- Using Data Tables
|
|
| | |
Module 8: Get External Data |
| | | - Importing From An External Data Source
|
|
| | |
Module 9: Lab |
| | |
|
|