EXCEL ADVANCED: ANALYTICAL

This course is for the Excel power-user. Be able to work with database functions, forms and validation. Enter the “object zone”, create hyperlinks and build advanced formulas. You will write logical functions and perform data analysis and statistics using advanced functions like IF statements. Use Boolean operators and concatenation. Understand arguments and arrays. Be able to manage a multi-sheet workbook and refer to 3D reference ranges in formulas. Set up conditional formatting, analyze data with PivotTables and record and save macros.

Class size is strictly limited to 18.

Course Facilitator: Ms. Toni Denson
Registration via Computer Course Registration Form
All checks payable to Ms. Toni Denson.