Certificate in Data Visualisation using MS Excel

Data may be just another word for information. However, it only calls for the right processes to convert this data into insights for business growth. These insights inform you about the past performance of the business as well as help in forecasting its future through data analysis and visualisation. While data analysis helps you explore and examine data, data visualisation allows you to present the result of data analysis using visuals like charts.

Despite the availability of different platforms in the analytics field, Excel is a great option, as it offers a variety of tools for creating visualisations other than charts.

The Learning and Development Academy is pleased to announce the launch of its training programmeme called ‘Certificate in Data Visualisation using MS Excel’. This course provides a comprehensive understanding of the various tools and techniques of MS Excel for analysis and visualisation.

Learning objectives

To acquaint the participants with the tools and techniques for working effectively on MS Excel.
To train participants in logical thinking and make them understand how to model a real-world problem in a spreadsheet.
To provide clarity on the concepts of handling an extensive amount of data and derive logical conclusions.
To teach participants how to present the data robustly and dynamically using charts leveraging form control objects.
To help the participants develop skills related to VBA macros and build flexible charts and automated reports.

programmeme coverage

Brush-up of MS Excel tools

Understanding cell referencing, conditional formatting, including data bars
Defining and using range names
Creating in-cell drop-down using data validation
Working with lookup functions (conventional VLOOKUP vs new-age XLOOKUP)
Logical and conditional functions (IF, IFS, COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS)
Working with dates (DAY, DATE, MONTH, YEAR, YEARFRAC, EDATE, EOMONTH)
Text-based functions (LEFT, RIGHT, MID, LEN, FIND, SEARCH, TEXT, TEXTBEFORE, TEXTAFTER, TEXTSPLIT, TEXTJOIN)
Getting the largest and smallest value from a list (LARGE, SMALL)

Charts and form controls

Data presentation through different types of charts, including column charts, bar charts, line charts, pie charts, doughnut charts, and waterfall charts.
Combining different charts and using a secondary axis.
Using form controls, including a combo box and an option button, to create flexible charts.

Pivot tables, slicers, and timelines

Using Pivot tables to manage data
Grouping data in Pivot tables
Inserting a slicer and a timeline
Including data composition for better analysis
Adding calculated fields
Using the Pivot table output for creating dashboards

VBA macros

Macros overview, including record macro and deciphering code
Saving MS Excel file with the appropriate file type to store VBA code
Writing VBA code, including sub-procedure and function procedure
Using InputBox for getting user inputs and MsgBox for displaying outputs
Conditional statements and creating customised functions
Application of loops and building flexible charts using the check box form control
Understanding event-driven codes to build automated reports

programmeme deliverables

20 hours of learning content – Live online sessions
Access to Grant Thornton-LMS for one year
Essential course material
Quiz and final assessment
Post-training support
Certificate of completion post assessment

Who should attend

Business analysts
Entrepreneurs
Students
Data scientists
Business intelligence managers
Professionals
Project managers

Fees

programmeme fees: INR 10000 plus taxes

Schedule

City	Schedule
Online Live Through Cisco WebEx	26^th, 27^th August, 2^nd & 3^rd September 2023

Cancellation and refund policy

The refund policy in case of withdrawal of nomination would work as follows:-

A refund of 50% of the fee would be provided for cancellation requests received up to five working days before the training start date
Participants who cancel in less than five working days or do not show up on the training date are liable to pay the full course fee and would not be entitled to refunds

Cancellations must be made via emails only. However, desirous participants can be accommodated in future batches of the programmeme without paying an extra amount. It is requested that the willingness to attend any future programmeme should be communicated at the earliest convenience.