Limited space is still available for the February 27 session. Please call Leila at 613-234-2020 ext. 18 or email email@example.com to check availability and to register.
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.
By the end of this seminar, 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
Please follow and like us:
Working with subtotaled lists
More Advanced Functions
Using lookup tables
Using functions to summarize data
Defining the problem
Solving the problem
Data list and Excel table concepts
Modifying PivotTable layouts
Working with PivotTables
Create simple macros
Register for this workshop
Once you register the first attendee, you’ll have the ability to add additional attendees or purchase other workshops
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.
Does This Course Address Your Competency Development Needs?
This training workshop addresses:
• Achievement / Results Orientation
• Computer and Digital Technology
• Document Use
• Planning / Organizing
• Working with Data and Numbers
February 27, 2020 9:00 am - 4:00 pm
Workshop Location 360 Albert Street Suite 720 Ottawa, Ontario - Map