Macquarie University
Excel Skills for Data Analytics and Visualization Specialization
Macquarie University

Excel Skills for Data Analytics and Visualization Specialization

Unleash the Power of Excel to Analyse Your Data. Import, visualize, and analyze huge and complex datasets using modern Excel tools.

Dr Prashan S. M. Karunaratne
Nicky Bull

Instructors: Dr Prashan S. M. Karunaratne

Sponsored by Abu Dhabi National Oil Company

93,336 already enrolled

Get in-depth knowledge of a subject
4.8

(3,446 reviews)

Intermediate level

Recommended experience

1 month
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
4.8

(3,446 reviews)

Intermediate level

Recommended experience

1 month
at 10 hours a week
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

See how employees at top companies are mastering in-demand skills

Placeholder

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from Macquarie University
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

Specialization - 3 course series

Excel Fundamentals for Data Analysis

Course 115 hours4.8 (3,878 ratings)

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.

Skills you'll gain

Category: Excel Formulas
Category: Data Analysis
Category: Microsoft Excel
Category: Spreadsheet Software
Category: Data Integration
Category: Data Mapping
Category: Productivity Software
Category: Data Transformation
Category: Data Wrangling
Category: Data Processing
Category: Business Logic
Category: Extract, Transform, Load
Category: Information Management
Category: Data Engineering
Category: Data Validation
Category: Data Manipulation
Category: Data Science
Category: Office Administration
Category: Data Cleansing

Data Visualization in Excel

Course 217 hours4.9 (1,199 ratings)

What you'll learn

Skills you'll gain

Category: Microsoft Excel
Category: Spreadsheet Software
Category: Pivot Tables And Charts
Category: Excel Formulas
Category: Data Visualization Software
Category: Data Analysis
Category: Productivity Software
Category: Dashboard
Category: Excel Macros
Category: Data Visualization
Category: Data Storytelling
Category: Data Presentation
Category: Business Intelligence
Category: Statistical Analysis
Category: Data Science
Category: Interactive Data Visualization
Category: Statistical Visualization
Category: Office Administration

Excel Power Tools for Data Analysis

Course 315 hours4.9 (1,163 ratings)

What you'll learn

Skills you'll gain

Category: Business Intelligence Software
Category: Data Analysis Software
Category: Data Visualization Software
Category: Power BI
Category: Data Analysis Expressions (DAX)
Category: Data Wrangling
Category: Data Transformation
Category: Data Manipulation
Category: Business Analytics
Category: Data Presentation
Category: Data Analysis
Category: Dashboard
Category: Business Intelligence
Category: Data Integration
Category: Extract, Transform, Load
Category: Analytics
Category: Microsoft Excel
Category: Pivot Tables And Charts
Category: Spreadsheet Software
Category: Data Import/Export

Instructors

Dr Prashan S. M. Karunaratne
Macquarie University
28 Courses1,379,074 learners

Offered by

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Placeholder

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy