School Event - All Venues

Dashboards & Pivot Tables

  • CESA Training Centre, Paulshof, Johannesburg, Paulshof
  • Mon 9 September 2019  08:30 to 16:30
  • Tue 10 September 2019  08:30 to 16:30

MICROSOFT OFFICE EXCEL 2010 DASHBOARDS

 

Dashboards reflect, in real time, the heart and pulse of a business in graphic format

A Dashboard is a visual display of the most important information needed to achieve one or more objectives consolidated and arranged on a single screen, so the information can be monitored at a glance

This is usually depicted using one or more of the following charting capabilities of Excel, viz. Basic and advanced charting techniques, Tables, Pivot tables, Pivot Charts, slicers, sparklines and more

OUTCOMES

At the end of this course delegates will be able to

·         Visualizing Data with Basic Charts

·         Be able to use advanced Charting Techniques

·         Be able to analyzing Data with PivotTables, Slicers, and PivotCharts

·         Delegates will also know how to:

o   Use Range Names in Formulas

o   Use Specialized Functions

o   Apply Data Validation

o   Work with Forms and Controls

o   Use Lookup Functions

o   Combine Functions

o   Create Advanced Formulas

o   Automate Workbook Functionality

o   Apply Conditional Logic

As an exercise, delegates will be required to provide the following output, derived from data provided. This information is linked through to a central data base and Pivot tables extracted from this data base

Slicers

Pie, line and Bar charts

 

 


 

Sparklines

Type: Course
CESA Validation Num: CESA-1615-06/2022
CPD Points: 2
Coordinator: Blessings Banda
Fee: R 4 589.47 excl. VAT
CESA member fee: R4 489.47 excl. VAT
Schedules:
  • CESA Training Centre, Paulshof, Johannesburg, Paulshof
  • Mon 9 September 2019  08:30 to 16:30
  • Tue 10 September 2019  08:30 to 16:30