In person class.
Pre-registration is required.
This course explores intermediate-level features and tools in Excel that can help you create, process, analyze and calculate complex business data. It is expected that the Introduction to Excel course has been completed before moving on to this course. Introductory topics such as starting Excel and entering and formatting data, will not be covered.
Session 1, Text to columns, Sorting, Filtering
Session 2, Simple formulas, Relative vs Absolute Cell References
Session 3, Complex formulas like VLookup and If/Then
Session 4, Pivot Tables