>
0 items - $0.00

Your shopping cart is empty

Why not add some items in our Shop
Call Us at +27 21 786 1224

EXCEL DASHBOARD TRAINING COURSE: On-site Services offered at Cape Town, University Estate, Woodstock, Northern Suburbs, Bellville, Brackenfell, Brooklyn, Durbanville, Goodwood, Panorama, Parow, Somerset West, Hout Bay, Southern Suburbs, Bergvliet, Claremont, Constantia, Kenilworth, Newlands, Observatory, Pinelands, Plumstead, Rondebosch, Tokai, Wynberg, South Peninsula, Fish Hoek, Kommetjie, Muizenberg, Gordon’s Bay, Somerset West, Strand, West Coast, Edgemead, Tableview, Paarl, Worcester, Langebaan, Western Cape, Bloemfontein, East London, Durban. Enquire about your location if not listed here.

 

Excel Dashboard Training Course

The Microsoft Excel Training Course – Dashboards

When you analyze raw data and turn that information into meaningful Dashboard Presentations, you can help your organization to identify several scenarios. You can help them cut costs. You might be able to identify trends or sudden changes. You might be able to spot irregular behavior in the data that might require immediate attention. You might also identify new opportunities.
Dashboards allow you to summarize masses of data on one or only a few pages. Dashboard presentations allow you to spot patterns or changes and depict targeted information in a graphical, user-friendly form.

Prerequisites

The course material includes extensive use of Excel. It is designed for users already use Excel on a regular basis.

At minimum, the ideal candidate for this course will have a firm grasp of the following skills:

• Working with data
• Perform calculations and use of formulas
• Being able to link between workbooks
• Create basic charts
• Understand filtering and sorting of data

 

1-Day Workshop

 Course Content

1. Dashboards overview

Design principles

2.  Sources of data

Text files
Other Excell files
Databases

3.  Tools for organising data

Worksheets
Important Functions
Tables
Pivot Tables

4.  Presenting/Visualising data

Charts
Grouping

5.  Making dashboards dynamic

Forms controls
Protecting worksheets
Data validation
Slicers

 

Duration

  • The programme duration is 8 hours and tuition is face-to-face.  The course is presented full-time during the day from 9:00 to 17:00.

Learner Material

  • Course material will be provided

Learners will be issued a Certificate of Completion

 

Pricing:

Registration: 50% Deposit

Workshop Fees:
Per Learner - Minimum 5 learnersR4,500

Please note, to justify our cost, for services delivered outside of Cape Town, a minimum of 5 candidates is required for training. 

 

2-Days Workshop

Course Content

1. Dashboards overview

Design principles

2.  Sources of data

Text files Data
Other Excell files
Web
Databases
Cleaning data

3.  Tools for organizing data

Worksheets
Important Functions
Tables
Pivot Tables

4.  Presenting/Visualising data

Charts
Shapes and dynamic text boxes
Grouping
Subtotals
Spark lines
Conditional formatting

5.  Making dashboards dynamic

Forms controls
Hyperlinks
Protecting worksheets
Data validation
Slicers

 

6.  Practical Session

Using your own data to create a dashboard

Duration

  • The programme duration is 16 hours and tuition is face-to-face.  The course is presented full-time during the day from 9:00 to 17:00.

Note: We have often found that a 1-day workshop can be too much of an overload and so have also included a 2-day workshop outline for your perusal . The benefits of the 2-day course are many, especially the practical section where we work with each individual with their work they are specifically doing.

Learner Material

  • Course material will be provided

Learners will be issued a Certificate of Completion

Pricing:

Registration: 50% Deposit

Workshop Fees:
Per Learner - Minimum 5 learnersR9,000

Please note, to justify our cost, for services delivered outside of Cape Town, a minimum of 5 candidates is required for training. 

 

More areas where services are offered De Waterkant, Foreshore, Gardens, Higgovale, Tamboerskloof, Vredehoek, Kensington, Monte Vista, Atlantic Seaboard, Bantry Bay, Camps Bay, Clifton, Fresnaye, Green Point, Llandudno, Mouille Point, Sea Point, Three Anchor Bay, Bishopscourt, Diep River, Harfield Village, Steenberg, Capri Village, Clovelly, Glencairn, Kalk Bay, Lakeside, Marina da Gama, Noordhoek, Scarborough, Simon’s Town, St James, Sunnydale, Sun Valley, Helderberg, Firgrove, Bloubergstrand, Bothasig, Melkbosstrand, Milnerton, West Beach, Parklands, and Grahamstown, Oudtshoorn.

 

Tag: Excel Dashboard Training,  Microsoft Excel Advanced Training, Advanced Excel Training Course, Microsoft Excel Training, Intermediate Excel Training Course, Computer, Basic Excel Training, Excel Training Courses, Excel Course, Computer Training Courses, Excel Courses, Microsoft Project Training, Computer Courses For Beginners, Pc Training, Online Computer Courses