Contents:
| Databases |
PivotCharts |
| · Copy from External Source Files |
· Overview of PivotChart Reports |
| · Importing Data from MS Access |
· Create a PivotChart |
| · Importing Text Files |
· Modify Styles and Formats |
| · Text to Columns Wizard |
· Re-arrange Fields |
| · Applying Auto and Advanced Filters |
|
| · Extracting Data with set Criteria |
MS-Query |
| · Selecting Visible Data Only |
· Linking to External Data |
| · Simple and Multi-level Sorting |
· Adding, Moving and Deleting Fields |
| · Applying automatic Subtotals |
· Creating and Saving Queries |
|
· Sorting Data |
| PivotTables |
· Use Criteria to Filter Data |
| · Overview of PivotTable Reports |
· AND and OR Logic |
| · Design the PivotTable Layout |
· Specifying Criteria using Expressions |
| · Create a PivotTable Report |
|
| · Select different source data |
Working with Data |
| · Apply PivotTable Styles |
· Search for Values within a list |
| · Calculation Types and Field Settings |
- VLOOKUP( ) |
| · Calculated Fields |
- HLOOKUP( ) |
| · Group and Sort Data |
· Database Functions |
| · Extracting Detail |
· Array Functions |
| · Apply Value Field Formatting |
· Link with MS Access & Access Queries |
| · PivotTable Options |
· Overview of Online Analytical Processing (OLAP) |
Target Audience: This course is essential for anyone needing to analyse data. It explores the database features of Excel 2007 that simplify the analysis of large amounts of information.
Assumed Knowledge: Attendees must have a thorough understanding of file handling, spreadsheet fundamentals and be confident creating simple functions and formulas.
Duration:
1 Day - Click here to see our course calendar.
Suggested follow-up course: Excel 2007 Specialist