Excel Accelerate – Reveal the Story Hidden in your Data
Excel Accelerate – Reveal the Story Hidden in your Data
19 19 people viewed this event.
This workshop is ideal for learners who are comfortable with the basics of Excel but want to master some of the more advanced functionality like Pivot Tables and Lookups; and want to present data with charts. Learners will discover how to incorporate data from various sources and collaborate with others in Excel.
Choice of Flexible Delivery Options:
~ 1 Day of Training
~ 2 Mornings / 2 Afternoons / 2 Evenings
Organiser
REIM Training Solutions
Who Should Attend
This course is ideal for those who have a basic working knowledge of Microsoft Excel and are ready to learn some of the more advanced features like Pivot Tables, Lookups and Data Visualisation.
Learning Objectives
Upon completion of this course learners will be able to competently:
- Use sum/sumif and count/countif functions
- Use Logical, Lookup, Text and Date/Time functions
- Sort, filter, clean and subtotal data
- Visualise data using charts (including Pivot charts)
- Create and modify tables
- Manipulate Pivot tables and create Pivot table reports
- Use Slicers and Timelines to filter data
Prerequisites
Learners should have a basic working knowledge of Microsoft Excel and be able to comfortably manage workbooks and perform basic calculations. They should also be comfortable working in a Microsoft Windows computer environment.
Course Outline
- Functions and Advance Calculations
- Managing Data Lists and Tables
- Visualising Data using Charts including Pivot Charts
- Pivot Table Reports and Pivot Charts
