Management
Star icon
Most Popular
Hands on Training icon
Hands On Training
Star icon
Hands on Training icon

Excel Skills for Data Analytics and Visualization Specialization

Course Cover
compare button icon

Course Features

icon

Duration

4 months

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Effort

3 hours per week

icon

Teaching Type

Self Paced

Course Description

Data is becoming the new currency. Therefore, it's vital to be able to analyse and quickly retrieve data. Data analytics and visualization are highly sought-after skills that can lead to high-paying jobs with great future growth prospects. An IBM report shows that Excel tools for data analysis and visualization will be in high demand. They are expected to grow by double-digits according to an IBM report. This course will improve your visualization and analytical skills, which will allow you to not only increase your work performance but also help you expand your job prospects. This course is for those working in data analysis and business who wish to learn advanced Excel and beginner Power BI. This specialization will allow you to use advanced Excel functions, creative visualizations, powerful automation features, and bring data to life. These courses will provide you with the necessary tools to transform, link, and analyse data. This course will teach you how to create interactive dashboards and a wide range of charts. You will also learn how to use PowerPivot and Get and Transform in Excel. We will harness the power of an underpinning database engine to remove the 1,048,576 rows limitation, fully automate data transformation, create data model to link data effectively, and open the portal to Power Business Intelligence.

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Understand the different types of data in Excel and use appropriate functions to work with them

Use Named Ranges and Tables to automate your analysis

Use logical and lookup functions to transform, link and categorise data

Use Excel tools and functions to clean and prepare data for analysis

Course Cover