If you have a need to analyze your business information such as product sales and pricing into multiple spreadsheets you may find this seminar helpful. During this session you will learn how to modify charts, use the IF and VLOOKUP functions, create an advanced filter; summarize a table using a PivotTable, a PivotChart and slicers; how to restrict data entry, analyze data using tools such as Scenario report, Goal Seek and grouped subtotals and receive an overview of macros.
Bring a laptop installed with 2010 Excel program. Plug-ins available if needed.
Note: Plan to arrive 10 to 20min early for set up. Session starts at 9am sharp. Coffee/Water provided