Description
Learning Topics
Learning Unit 1: Excel formulas
- Overview of formulas in Excel
- =IF
- =VLOOKUP
- =CONCATENATE
Learning Unit 2: Pivot tables
- Create a PivotTable to analyze worksheet data
- Use the Field List to arrange fields in a PivotTable
- Group or ungroup data in a PivotTable
- Filter data in a PivotTable
- Create a PivotChart
Learning Unit 3: External database queries
- Import data from external data sources
- Connect to a data source
- Working with external data connections
- Understanding the basics of data connections
- Finding connections
- Editing connection properties
- Managing connections
- Using external data ranges and properties
- Understanding data source support in Excel and Excel Services
- Understanding data access components
- Using ODBC to connect to data sources
- Refreshing data
- Importing data programmatically and by using functions
Learning Unit 4: Macros
- Basic Principals
- Recording a Macro
- Combining Macros
- Visual-Basic
