Excel Accelerate – Reveal the Story Hidden in your Data

REIM Training Solutions

Excel Accelerate – Reveal the Story Hidden in your Data

133 133 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

 

Enquire Now

 

Date And Time

-
 

Location

Online event
 

Event Category

 
Download Events iCal

Share With Friends

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

Scroll to Top