Advanced Excel Workshop
Saturday, February 1, 2020 | 1 - 3 p.m. | Bow Valley College, South Campus Building, S3018
The Advanced Excel Workshop will cover creating and using functions (IF), linking to workbooks, goal seeking, scenarios and add-ins, SumIf, NPV Function, pivot tables, H&V- LookUp Functions and charts, and more.
Students are highly encouraged to participate in both introductory and advanced workshops.
The Advanced Excel Workshop will cover:
- Creating and Using Functions (IF)
- Linking to Other Workbooks
- Converting Data Types
- Goal Seeking
- Scenarios and Add-Ins
- H & V - LookUp Functions
- SumIf, NPV Function
- Outlining
- Pivot Tables & Charts
- Form Controls & Macros
- Excel Options