Descriptions

As data becomes the modern currency, so the ability to quickly and accurately analyse data has become of paramount importance. Therefore, data analytics and visualization are two of the most sought after skills for high paying jobs with strong future growth prospects. According to an IBM report, the Excel tools for data analytics and visualization are among the top 10 competencies projected to show double-digit growth in their demand. This course will help you develop your analytical and visualization skills so that you not only improve your current work performance but also expand your future job prospects.

For those in business and data analysis who want to master advanced Excel and beginner Power BI , that will add an asset to your employability portfolio. Working with datasets similar to those typically found in a business, you will use powerful Excel tools to wrangle the data into shape, create useful visualizations, and prepare dashboards and report to share your results. You will learn to create a data workflow to automate your analysis and make the results flexible and reproducible.

What you’ll learn

• Use Excel tools and functions to clean and prepare data for analysis.
• Use Named Ranges and Tables to automate your analysis.
• Understand the different types of data in Excel and use appropriate functions to work with them.
• Use logical and lookup functions to transform, link and categorise data.

Specificatoin of Excel Skills for Data Analytics and Visualization Specialization

• publisher: Coursera
• Teacher : Dr Prashan S. M. Karunaratne , Nicky Bull
• Language: English
• level: Intermediate
• Number of courses: 3
• Duration: Approximately 4 months to complete
  Suggested pace of 3 hours/week

Content

COURSE 1

Excel Fundamentals for Data Analysis

COURSE 2

Data Visualization in Excel

COURSE 3

Excel Power Tools for Data Analysis

Requirements

• You should have familiarity with the Excel user interface, moving around an Excel workbook, and creating basic formulas

Pictures of Excel Skills for Data Analytics and Visualization Specialization

Sample Video

Installation Guide

Extract the files and watch with your favorite player

Subtitle: English

Quality: 720p

This Specialization contain 3 courses.

Download Link

Course 1 – Excel Fundamentals for Data Analysis

Download Course – 743 MB

Course 2 – Data Visualization in Excel

Download Course – 931 MB

Course 3 – Excel Power Tools for Data Analysis

Download Course – 625 MB

Password file(s): www.downloadly.ir

File size

2.24 GB