Data Analysis and Visualisation Training

Languages

English + Hindi + Odia

Batch Size

10-20

Duration

8 hours

Investment

$$$$$

Request Training Proposal

Course Contents

This 8 Hrs course designed for manger and above personnels who plays a key role in Analysis and Visualising or reporting with storytelling format.

Introduction:

Recognizing the spreadsheet Data and Exploring the Types and manipulation of the Format.

Essential Functions:

NETWORKDAYS.INTL, EDATE, EOMONTH, TEXT, DATEDIF, SUMPRODUCT, VLOOKUP, UNIQUE, IF/S, AND, OR, SUMIF/S, COUNTIF, SORT, FILTER

Data Cleansing Techniques:

Text to Column Hacks, Find & replace with Wild Card Usage, usage of AI Tool.

Data Summarization:

Data Summarisation with Pivot Table. Calculated Fields Vs. Items, Statistical Analysis with Data, Designing Dashboards, Working with Multiple Pivot, Multiple Worksheet and Multiple Excel Workbook Analysis

Data Visualisation:

Data Visualisation with Bar, Pie, Waterfall, Combo and Map Charts. Editing and Customizing the same.

Basic knowledge of Excel And some analytical skills are must.

Instructor Profile

PRABHAS PANDA

Corporate consultant having 18 years of Experience caters training on Advance Excel, PowerPoint, Excel VBA and Macro, MS Project, Google Sheets, Google Slides, MS Access, Etc.