Business Courses

Business Skills Courses

CBM Training provides a range of courses designed to help delegates hone their business skills to improve productivity in the workplace. Our Business Skills Courses are delivered by a faculty of highly qualified consultants who are not merely lecturers but rather specialists consulting in their particular field. They have greater insight into the market and a fuller understanding of delegate needs and deliver Business Courses which are practical in nature and extremely relevant to the current market.
MS Excel Dashboards

Building Powerful, Responsive and Useful MS Excel Dashboards

Many organisations have a wealth of information available to them about customer behaviour, financial performance, production activity, stock levels – the list is endless. Collating and formatting that data into useful information can be a time consuming, resource intensive process. Managers need to have the right information available at the right time, in the right format in order to make decisions that impact their departments and organisations.

Whether you’re a Managing Director, Sales Manager or a Production Manager, setting up custom MS Excel Dashboards displaying and updating your information the way you want it, will solve a lot of management information issues.

This incredibly powerful 2 day dashboards using MS Excel training course will not only teach you how to build the most advanced and responsive dashboards, but also provide you with key insights from an IT, finance and business expert on where you should focus your reporting to ensure you are up to date, not over reporting and consistently making the right business decisions.

Your comprehensive programme includes:

– Using dashboards as a decision making tool
– Deciding what to report on to avoid “analysis paralysis” and choosing the best dashboard format
– Creating pivot tables and charts for your dashboard
– Looking at the other Excel functions and tools you will need to create truly dynamic, useful dashboards
– Using sparklines to gain a graphic representation of data in a single cell, allowing for easy trend analysis
– Methods of effortlessly hyperlinking, importing, and converting data and the exciting MS Excel camera tool
– Building interactivity into your dashboards and bringing in LIVE external data and statistics
– Linking the data behind the dashboard to a time-frame

Do you have 8 or more delegates and want to run this course Onsite?

Click here to request a quote and get more information about our onsite training.


REGISTER

Dates

11-12 March 2019 (JHB), 21-22 May 2019 (CPT)

Duration

2 Days

Venue

Corporate Conference Centre (Dowerglen), The Peninsula Hotel (Cape Town)

Price R4,250.00 excl. 15% VAT

R4,250.00 excl. 15% VAT

PLEASE SELECT OPTIONS TO CONTINUE

Clear
Your Booking
Courses in your City
show blocks helper

Price

Product categories -

Product City

Onsite Enquiry Form:

Complete the form below and our onsite team will be in touch with you shortly.

Please prove you are human by selecting the Cup.

PDI Scholarship Application Form:

 


Personal Details:

Previously Disadvantaged Individual (PDI) Group: Black: AfricanBlack: ColouredBlack: IndianOther


Company Details:

Please prove you are human by selecting the Key.