Contents:
| Formulas |
Databases |
| · The Function Wizard |
· Using AutoFilter |
| · Conventions and SYNTAX of Functions |
· Extracting Data with Advanced Filter |
| · Understanding Arguments |
· AND/OR criteria |
| · If() and Lookup() Functions |
· Selecting Filtered Data with GoTo Special |
| · Using Dfunctions () |
· SubTotal Functions |
| · Create and use Nested Functions |
|
| · Working with Array Functions |
Pivot Tables |
| · Enter and Edit Arrays |
· Overview of PivotTable Reports |
| · Circular References and Iteration |
· Design the PivotTable Layout |
| · The Consolidation Command |
· Create a PivotTable Report |
|
· Select different source data |
| Conditional Formatting |
· Apply PivotTable Styles |
| · Monitoring cell values |
· Calculation Types and Field Settings |
| · Applying Conditional Formats |
· Calculated Fields |
| · Using Functions and Cell references with Conditional Formatting |
· Group and Sort Data |
|
· Extracting Detail |
| MS-Query |
· Apply Value Field Formatting |
| · Linking to External Data |
· PivotTable Options |
| · Adding, Moving and Deleting Fields |
|
| · Creating and Saving Queries |
Statistical Analysis |
| · Sorting Data |
· Goal Seek |
| · Specifying Criteria |
· What If Tables |
| · AND/OR Logic |
· 1 Variable Input Tables |
| · Specifying Criteria using Expressions |
· 2 Variable Input Tables |
Target Audience: This course is aimed at experienced Excel users who need to create more complex functions, perform data manipulation utilizing list analysis and wish to create PivotTable reports and charts.
Assumed Knowledge: Prior attendance of the Excel Specifics course.
Duration:
1 Day - Click here to see our course calendar.
Suggested follow-up course: