Description
Create, format and audit workbooks at an advanced level using database functions, macros, templates, web tools, multiple workbooks, imported/exported data, data tables, scenario management, Solver and VBA.
Grading Basis
Graded
Prerequisites
Course Learning Outcomes
Core Topics
- Designing databases to meet specified business needs
- Exploring table functions and options
- Utilizing form features
- Importing external data
- Defining relationships
- Refining information presentation
- Integrating with other applications
- Performing calculations
- Creating macros and modules
- Exploring visual basic for applications