Excel Workshop: Working With Tables and What-If Analysis
December 14 @ 1:00 pm - 2:30 pm
Learn how to organize data in Excel: define a range as a table, create data validation rules to restrict the type of data entered, use simple and multiple sorts, create custom sorts, and use simple and advanced filters to find sets of data. Also, we’ll demonstrate the three What-If Analysis tools: scenarios, data tables, and Goal Seek. These features allow users to see how using different numbers will affect the results.
Presented by Judy Beaver
Pre-registration is required and can be done HERE
Free for all CNC members, Non members $10.00