[Pkg-chromium-maint] PIVOT TABLE AND DASHBOARDS 2010 / 2013 / 2016 ( 2 Day workshop )

Thu Sep 29 13:30:25 UTC 2016

Dear Delegate

PIVOT TABLE AND DASHBOARDS 2010 / 2013 / 2016 ( 2 Day workshop )

  _____  

Objective: The workshop is designed to give an insight into Business
Intelligence (BI) and reporting using Excel. BI can help an organization
identify cost-cutting opportunities, uncover new business opportunities,
recognize changing business environments, identify data anomalies and create
widely accessible reports. By attending the workshop delegates will be able
to:

*         Analyse large amounts of data and report the results in a
meaningful way

*         Get better visibility into data from different perspectives

*         Add interactive controls to show various views

*         Automate repetitive tasks and processes

*         Create eye-catching visualisations

*         Create impressive dashboards and What-If analyses

*         Access external data source sources to expand your message

Requirements: Some experience working with data and familiarity with the
basic concepts of data analysis such as working with tables, aggregating
data and performing calculations. Experience with a strong grasp of concepts
such as table structures, filtering, sorting and using formulas.

Note: the workshop is hands-on with delegates completing exercises in all
modules. Delegates will receive a CD/USB stick with all the exercises
completed in the workshop to practice once they are back in the workplace.

  _____  

Course Outline

MODULE 1: MOVING FROM SPREADSHEETS TO DASHBOARDS

*         Introducing Dashboards

*         Dashboards vs Reports

*         Dashboard design principles

*         Building your Data Model

*         Data Model best practice

*         Excel functions for your data model e.g. VLOOKUP

MODULE 2: EXCEL CHART BASICS

*         Introducing Excel Charts

*         Understanding the different Chart types

*         Working with charts and chart series

*         Formatting and customizing charts

MODULE 3: GOING BEYOND TABLES AND CHARTS

*         Using PivotTables and Pivot Charts

*         Filtering your data e.g. using slicers

*         Introducing and creating Excel Sparkline's

*         Chartless visualization techniques e.g. dynamic labels, text
boxes, formula driven labels

MODULE 4: CREATING ADVANCED DASHBOARD COMPONENTS

*         Components that show trending i.e.

*         Trending Do's and Don'ts

*         Comparative trending

*         Emphasizing periods of time

*         Trending techniques

*         Components that group data i.e.

*         Listing top and bottom values

*         Using histograms to track relationships and frequency

*         Emphasizing top values in charts

*         Components that show performance against a target i.e.

*         Show performance with variances

*         Show performance against organizational trends

*         Create a thermometer style chart

*         Create a bullet graph

NOTE: In this module, we create a sample dashboard using the various
techniques learnt

MODULE 5: AUTOMATING YOUR DASHBOARDS AND REPORTS

*         Macro charged reporting

*         Adding interactive controls to your dashboard

MODULE 6: WORKING WITH THE OUTSIDE WORLD

*         Importing MS Access data into Excel

*         Sharing your workbook with the outside world

  _____  

This is a 2 day workshop scheduled as follows:

City

        Venue

Current Dates

Next Calendar Dates

Windhoek

Kalahari Sands Hotel

4 - 5 October 2016

    20 - 21 October 2016

CAPE TOWN

Southern Sun Hotel 

11 - 12 October 2016

       27 - 28 October 2016

JOHANNESBURG

Focus Rooms Sandton

11 - 12 October 2016

27 - 28 October 2016

Cost : R 10 500.00

COMPLIMENTARY : LENOVO 3G Tablet with Wi-Fi

DURATION : 2days which can be added upon client's request.

  _____  

Mr Webster Chinyani

(Sales Executive)

T: 0027 11 020 0345

T: 0027 11 072 8177

C: 0027 78 126 8728

F: 0027 86 295 9390 

Email:  <mailto:webster at oracle7.co.za> webster at oracle7.co.za or
admin at ashwebgroup.com <mailto:admin at ashwebgroup.com> 

Add: Suite 4 Christine Court, 2 Kings Avenue, Windsor West, Randburg South
Africa

(You are on our database to receive periodic updates on training. If you are
not the correct contact person, or would like to update your details or wish
to be removed from our list altogether, please let me know.)

DISCLAIMER:

This message may contain information which is confidential, private or
privileged in nature. If you are not the intended recipient, you may not
peruse, use, disseminate, distribute or copy this message or file which is
attached to this message. If you have received this message in error, please
notify the sender immediately by e-mail, facsimile or telephone and
thereafter return and/or destroy the original message. 

Please note that the recipient must scan this e-mail and any attached files
for viruses and the like. While we do everything possible to protect
information from viruses, Oracle 7 Africa Investment accepts no liability of
whatever nature for any loss, liability, damage or expense resulting
directly or indirectly from the access and/or downloading of any files which
are attached to this e-mail message.

If you want to be removed from our Database, please
<mailto:unsubscribe at oracle7.co.za?subject=Please%20Unsubcribe%20Me>
UNSUBSCRIBE

  _____  

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-chromium-maint/attachments/20160929/3522c58b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 5245 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-chromium-maint/attachments/20160929/3522c58b/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 5693 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-chromium-maint/attachments/20160929/3522c58b/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 10557 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-chromium-maint/attachments/20160929/3522c58b/attachment-0003.jpg>