Infographics & Data Visualization with Excel

Course Outline for Infographics & Data Visualization With Excel

SECTION A: Process and Clean Data

Lesson 1: Introduction to Infographics Design and Data Visualization

• Tools available to design & produce visualizations,
• Tools for designing infographics
• Data Reporting Tools & Techniques

Lesson 2: Advanced Excel Techniques to Clean data using Excel

• Sorting & Filtering
• Functions & Formulas
• Conditional Formatting
• Remove Duplicates
• Macros to Clean Data

Lesson 3: Data Processing & Data Lookups

• Data Validation With Lists etc
• Tables
• Lookup Functions
• Consolidate from Multiple Sheets

SECTION B:  Data Analysis and Data Visualization

Lesson 4: Data Analysis & Data Visualization

• Introduction to Pivot Tables
• Data analysis With Pivot Tables
• Using Slicers
• Pivot Charts

Lesson 5: Using Statistical Functions in Data Analysis

• Using Summary Functions,
• Introduction To Statistical Functions
• Statistical Analysis With Excel

Lesson 6: Visualization With Excel Charts

• Creating Different Chart Types
• Using Maps Charts
• Creating Combo Charts
• Analysis With Histograms

SECTION C:  Data Storytelling

Lesson 7: Creation of Infographics

• Design & Create infographics, and
• Infographic Design
• Standards & Best Practices

Lesson 8: Visual Data Story Telling

• Different Ways to execute visual data storytelling
• Create a complete, compelling Story with Infographics & Visualizations

Objectives of Infographics & Data Visualization With  Advanced Excel Tips & Tricks

After Completing the Infographics & Data Visualisation With Excel Course, Participants will be able to:

• Design and Produce Compelling Visualizations, Infographics and Report for Clients & Management,
• Apply Advanced Excel Techniques to Clean data using Excel,
• Use Excel Formulas & Functions to Process the data & Perform Lookups,
• How to Analyze Data with Excel Tools like Pivot Tables, Slicers,
• How to Visualize data using Excel Tools like Charts & Maps,
• Design & Create infographics, and
• Learn Different Ways to execute visual data storytelling

They will learn to deploy Advanced Excel features to increase productivity and improve efficiency by streamlining the workflow.

Participants will learn to use advanced features and functions of Office 365 / Excel 2019 to improve productivity, improve data storytelling through the use of infographics and data visualizations, and process data with Pivot Tables, Macros, Charts, Functions & Formulas easily.

What are the Pre-Requisites For Attending The Infographics & Data Visualization With Excel Course?

Basic knowledge of Microsoft Excel is sufficient for you to attend the Advanced Excel training program.

You must know how to start the Excel program, key in numbers, and text, and do simple formatting. You should know some of the Basic Excel functions like Sum, Count, Average etc.

Advanced Functions and features of Excel will be taught in this Excel workshop.

A laptop with the right Excel version pre-loaded is provided for use in the Advanced Excel Tutorial class.

Notes in folders, along with multiple Exercise files to practice and learn Advanced Excel Features and Functions, are provided in the class too.

Microsoft Advanced Excel Tips & Tricks used to Create Infographics and Visualization are covered step by step in this comprehensive Excel course.

This program is most suitable for you if you use Microsoft Excel in your day-to-day work and know the basics of Excel pretty well.

You should be keen to extend your knowledge of the more advanced features & functions of Excel to become more productive and make the most of Microsoft Excel Office 365 to analyze and visualize data.

If you would like to learn the following, join this course:

• How to write VLOOKUP in Excel,
• How to Summarize Data using Pivot Tables, or
• How to Use the Infographics or Data Visualization Tools in Excel,

This Advanced Excel course on Infographics and data visualization is best suited for you.