Online Course – Certified Professional Internship in Google Data Mining and Visualization Tools

Discover the power of Excel to analyze your data. Import, visualize, and analyze large, complex data sets using modern Excel tools.

Suggested by: Coursera (What is Coursera?)

Professional Certificate

Intermediate level

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Advanced Excel functions
  • Creative visualizations
  • Powerful automation features
  • Transform, connect, and analyze data
  • Create interactive graphs and dashboards
  • PowerPivot, Get and Transform, and DAX

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • Project Manager
  • Report developer
  • Information Systems Analyst
  • Digital Marketing Manager
  • Sales Manager
  • Business consultant
  • Performance Analyst
  • Software developer
  • Operations Manager

Focus – 3-part course series

As data becomes the modern currency, the ability to analyze data quickly and accurately becomes increasingly important. Data analysis and visualization are two of the most sought-after skills in high-paying professions with strong growth projections for the future.

According to an IBM report, Excel tools for data analysis and visualization are among the 10 skills likely to show double-digit growth in demand. This course will help you develop your analysis and visualization skills so that you not only improve your current job performance, but also expand your future employment options.

What will you learn in the course?

  • Advanced Excel functions
  • Creative visualizations
  • Powerful automation features
  • Transform, connect, and analyze data
  • Create interactive graphs and dashboards
  • PowerPivot, Get and Transform, and DAX

With the power of Excel’s database engine, you can analyze the 1,048,576 row limit, create full automation of data transformations, and develop data models to connect data efficiently.

Hands-on Learning Project

Working with data sets similar to those typically found in business, you will use Excel’s powerful tools to organize the data, create useful visualizations, and populate dashboards and reports to share your results. You will learn to create data flows that validate your analysis and make the results flexible and repeatable.

Details of the courses that make up the specialization

Excel Basics for Data Analysis

Course 1
15 hours
4.8 (3,794 ratings)

What will you learn?

  • Using Excel tools and functions to clean and prepare data for analysis.
  • Using ranges and automatic names to facilitate analysis.
  • Understanding the different data types in Excel and using appropriate functions.
  • Using logical and search functions to transform, link, and classify data.

Skills you will gain

  • Category: Data Analysis
  • Category: Microsoft Excel
  • Category: Data Cleanup

Data visualization in Excel

Course 2
17 hours
4.9 (1,168 ratings)

What will you learn?

In the era of “Big Data,” data visualization is an essential skill. Over five weeks, we’ll explore Excel’s visualization tools with practical case studies.

Topics we will cover

  • Week 1: Dynamic visualizations with conditional formatting.
  • Week 2: Graphing techniques for proper storytelling.
  • Week 3: Creating unique graphs.
  • Week 4: Summarizing and filtering data with pivot tables.
  • Week 5: Creating interactive dashboards.

Skills you will gain

  • Category: Microsoft Excel
  • Category: Data Visualization

Powerful Excel tools for data analysis

Course 3
15 hours
4.9 (1,125 ratings)

What will you learn?

In this course, we will introduce Power Query, Power Pivot, and Power BI, key tools for transforming, analyzing, and presenting data.

Skills you will gain

  • Category: Big Data
  • Category: Data Analysis
  • Category: Microsoft Excel
  • Category: Data Visualization
  • Category: Power BI