TrueschoTruescho
All Courses
Excel Skills for Data Analytics and Visualization
Coursera
Specialization
Unknown

Excel Skills for Data Analytics and Visualization

Macquarie University

This course develops skills in data analytics and visualization using advanced Excel and beginner Power BI to improve work performance and future job prospects.

UnknownEnglish

About this Course

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

What You'll Learn

  • Use advanced Excel functions to create innovative visualizations and automation
  • Transform, link, and analyze data efficiently using Excel and Power BI tools
  • Build charts and interactive dashboards to support decision-making

Prerequisites

  • Basic familiarity with relevant concepts and terminology
  • Willingness to practice through applied exercises or case studies

Instructors

A

Assoc Prof Prashan S. M. Karunaratne

Associate Professor - Teaching & Leadership | SFHEA

N

Nicky Bull

Lecturer and Lead Content Designer

Topics

Business Essentials
Business
Data Analysis
Data Science
Dashboard
Data Cleansing
Data Integration
Data Manipulation
Data Preprocessing
Data Presentation

Course Info

PlatformCoursera
LevelUnknown
PacingUnknown
PriceFree

Skills

أساسيات الأعمال
الأعمال
تحليل البيانات
علوم البيانات
لوحات المعلومات
تنقية البيانات
دمج البيانات
معالجة البيانات
Data Preprocessing
Data Presentation

Start Learning Now