Advanced Techniques to Help You Manage Your Data
Excel is a popular tool for creating spreadsheets, analyzing data, and charting information. This advanced level, one-day course is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn about advanced analysis tools like the Scenario Manager, Goal Seek, Solver, and advanced functions. Basic macros will also be covered in this course.
This workshop is offered within organizations for groups of 5 people or more.
Course duration: 1 day
Program Topics
Summarizing Data
• Automatic subtotals
• Working with subtotaled lists
More Advanced Functions
• Using lookup tables
• Using functions to summarize data
• Logical functions
Projecting Figures
• Goal seek
• Data tables
What-If Analysis
• Scenario concepts
• Creating scenarios
• Managing scenarios
Solver
• Solver concepts
• Defining the problem
• Solving the problem
PivotTables
• Data list and Excel table concepts
• PivotTable concepts
• Creating PivotTables
• Modifying PivotTable yayouts
• Working with PivotTables
• Options
• Pivot charts
• Slicers
Macros
• Create simple macros
• Scenario reports
Learning Outcomes
By the end of this workshop, you will be able to:
• Use more advanced functions: VLOOKUP, IF, database functions to summarize data
• Understand concepts of What-If-Analysis: Goal Seek, Data tables, Scenarios and Solver
• Summarize data by using subtotals
• Create and use Pivot Tables and Pivot Charts
• Record basic macros
Who Should Attend?
Experienced Excel users who need to manage large amounts of data using Pivot Tables to summarize and analyze the data. Users will learn more advanced functions and Excel What-If tools to make business decisions.
For more information on this workshop, please contact:
Sophie Gouédard
Tel: 613-234-2020, ext. 21
Email: sgouedard@pmctraining.com