We may earn an affiliate commission when you visit our partners.
Course image
Nicky Bull and Dr Prashan S. M. Karunaratne

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.

Read more

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.

Upon completing this specialization, you will be able to bring data to life using advanced Excel functions, creative visualizations, and powerful automation features. These courses will equip you with a comprehensive set of tools for transforming, linking, and analysing data. You will master a broad range of charts and create stunning interactive dashboards. Finally, you will explore a new dimension in Excel with PowerPivot, Get and Transform, and DAX. Harnessing the power of an underlying database engine, we will remove the 1,048,576 row limitation, completely automate data transformation, create data models to effectively link data, and open the gateway to Power Business Intelligence.

Enroll now

Share

Help others find Specialization from Coursera by sharing it with your friends and followers:

What's inside

Three courses

Excel Fundamentals for Data Analysis

(0 hours)
As data becomes the modern currency, the ability to analyze it quickly and accurately has become paramount. Excel, with its broad range of features, is one of the most widely used programs for doing this. In this course, you will learn the fundamentals of Excel for data analysis, including how to clean and prepare data, automate analysis, and use logical and lookup functions to transform, link, and categorize data.

Data Visualization in Excel

(0 hours)
In an age driven by "big data," data visualization is an increasingly important skill. Visualizations need to present data in an easy-to-understand and attractive way, but they must also provide context and tell a story. Excel has many rivals in this space, but it is still an excellent choice, particularly if it's where your data resides.

Excel Power Tools for Data Analysis

(0 hours)
Welcome to Excel Power Tools for Data Analysis. In this four-week course, we introduce Power Query, Power Pivot, and Power BI, three power tools for transforming, analyzing, and presenting data. Excel's ease and flexibility have long made it a tool of choice for doing data analysis, but it does have some inherent limitations. In this course, we will learn how to use Power Query to automate the process of importing and preparing data for analysis.

Save this collection

Save Excel Skills for Data Analytics and Visualization to your list so you can find it easily later:
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser