KapitalBiz Consulting Course

Data Visualization Masterclass

Data visualisation and charts play an important role in any business, and facilitates the understanding of complex data on all levels of an organisation. Effective data visualisation and dashboards can facilitate and enhance decision-making, as well as drive effective management of complex variables. It is therefore important that all employees who work with data are comfortable with the available tools and charts to effectively, visually represent the complex data.

You will learn how to use Excel’s formatting tools to create compelling visualisations, such as colour-coding and sparklines. The course will also cover more advanced techniques, such as creating interactive charts and adding slicers to allow users to filter data, and also how to use Excel’s Power Query and Pivot Table tools to manipulate and summarize data for use in dashboards.

Additionally, the course will cover how to use Excel’s data validation feature to ensure that data is entered correctly, as well as how to use macros to automate repetitive tasks. Throughout the course you will solve real-world problems, including creating a sales dashboard, a financial dashboard and a project management dashboard. By the end of the course, you will have the skills and knowledge to create appealing and effective dashboards for a variety of applications.

Local Fee R 17,999

International Fee $ 1,300

What it’s all about

Why you should attend

On completion of this course, you will be able to:

Learn how to develop effective storytelling techniques by utilising the best selection, design, and presentation of charts and graphs
Identify the functions of interactive dashboards in MS Excel and become experts at creating interactive analysis
Improve your Microsoft Excel skills and save yourself hours per day and eliminate stress

Understand the procedure for setting up, formatting and maintaining an interactive dashboard
Master the importance of visual perception in the process of presenting information and the advantages of infographics in MS Excel

01 Introduction to Data Visualisation

• Why use Excel
• Getting the data into a usable format (cleaning, tools, etc.)
• Understanding the different types of charts
• Using the chart that is best suited for your data and your goals
• Using the fancy charts, but not forgetting about the basic charts
• Looking for trends in the data
• Ensuring that the charts are user-friendly and scalable
• Avoiding “chart junk”– unnecessary visual elements that can crowd charts
• Using colour and white spaces effectively to improve comprehension

02 Conditional Formatting

• Conditional Formatting: Visualising data based on conditions specified
• Data bars, colour scales, icon sets, highlight cell rules, etc.
• Changing the appearance of a cell range based on the condition (or criteria)
• Conditional formatting taking precedence above normal formatting
• Using functions and formulas in conditional formatting to add flexibility
• Selecting data to attach conditions

03 Sorting & Decision Functions

• Introduction to sorting functions
• Creating filters with SUMPRODUCT
• Filtering on excel tables
• Data aggregation
• Table sortin

04 Advanced Formulas for Dashboards & Decisions

• Lookup functions
• How to use VLOOKUP
• How to use Index/Match
• Combining formulas
• How to use array formulas
• Array formulas demo

05 Creating and Formatting Charts

• Waterfall chart
• Tornado chart
• Sunburst chart
• Treemap chart
• Radar chart
• Step chart
• Stock chart
• Scatter chart
• Filled map
• Combo and progress charts
• Pivot Tables, Pivot Charts and Slicers

06 Dashboard Capabilities

• Combining a variety of charts – from more basic to more advanced, in line with what suits the data
• Hyperlinking
• Inserting shapes to attach a hyperlink
• Inserting icons to use in dashboards
• Pictographs

07 Data Validation

• Limiting entries into a cell
• Creating a dropdown list
• Data validation and functions

08 Forecast Sheets

• Forecasting future values based on past data
• Dates/times in the historical data at consistent intervals
• Averaged data points with same date stamps

Ideal Participants for This Program

Who should attend

This training course is aimed at intermediate to advanced Microsoft Excel users looking to take their skills to the level of presenting clean, focused and impactful information. Participants should be able to create, edit and manipulate spreadsheets containing formulae and functions. They should be able to create a basic chart and pivot table.

Those with titles like Head of Finance, Financial Manager, Accountant, Financial Analyst, Program Manager, Internal & External Auditors, Business Analytics Developer, Data Scientist, Marketing Executive, Marketing Manager, Sales Executive, Sales Manager, HR Executive, HR Officer, HR Manager, Data Analysts and Business Analysts who want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & gain a competitive advantage over their colleagues.

Head of Finance
Financial Manager
Accountant
Financial Analyst
Program Manager
Internal & External Auditors

Business Analytics Developer
Data Scientist
Marketing Executive / Marketing Manager
Sales Executive / Sales Manager
HR Executive / HR Officer / HR Manager
Analysts and Business Analysts who want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & gain a competitive advantage over their colleagues.

KapitalBiz Consulting Course

Data Visualization Masterclass

What it’s all about

Why you should attend

Ideal Participants for This Program

Who should attend

Book Your Spot

Data Visualization Masterclass

Recommended Courses

Project Portfolio Management

3 – 6 June

NH Hotel Sandton / Live Online

Predictive Maintenance & Reliability Course

12 – 14 June

Live Online Training

Finance for Engineers & Technical Managers

24 – 26 April

Live Online Training

Our links

Get In Touch

Our links

Get In Touch