Excel Power Tools for Data Analysis

  • 4.8
Approx. 15 hours to complete

Course Summary

This course teaches you how to effectively use Excel's power tools to analyze and manipulate data. You'll learn how to use macros, pivot tables, and Power Query to simplify your workflow and save time.

Key Learning Points

  • Learn advanced Excel techniques to analyze and manipulate data
  • Become proficient in macros, pivot tables, and Power Query
  • Save time and streamline your workflow with Excel's power tools

Job Positions & Salaries of people who have taken this course might have

    • USA: $67,000
    • USA: USD
    • India: ₹4,80,000
    • India: INR
    • Spain: €32,000
    • Spain: EUR
    • USA: $67,000
    • USA: USD
    • India: ₹4,80,000
    • India: INR
    • Spain: €32,000
    • Spain: EUR

    • USA: $61,000
    • USA: USD
    • India: ₹4,20,000
    • India: INR
    • Spain: €28,000
    • Spain: EUR
    • USA: $67,000
    • USA: USD
    • India: ₹4,80,000
    • India: INR
    • Spain: €32,000
    • Spain: EUR

    • USA: $61,000
    • USA: USD
    • India: ₹4,20,000
    • India: INR
    • Spain: €28,000
    • Spain: EUR

    • USA: $81,000
    • USA: USD
    • India: ₹6,00,000
    • India: INR
    • Spain: €38,000
    • Spain: EUR

Related Topics for further study


Learning Outcomes

  • Master advanced Excel techniques for data analysis
  • Streamline your workflow and save time with Excel's power tools
  • Become proficient in macros, pivot tables, and Power Query

Prerequisites or good to have knowledge before taking this course

  • Basic knowledge of Excel
  • Access to Microsoft Excel 2016 or higher

Course Difficulty Level

Intermediate

Course Format

  • Online self-paced course
  • Video lectures
  • Hands-on exercises

Similar Courses

  • Excel for Business Analysts
  • Advanced Excel for Data Analytics
  • Excel Skills for Business: Intermediate I

Related Education Paths


Notable People in This Field

  • Chandoo
  • Mynda Treacy
  • Jon Acampora

Related Books

Description

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, analysing and presenting data.

Outline

  • Welcome and critical information
  • Welcome to Excel Power Tools for Data Analysis
  • Course goals and weekly learning objectives
  • Important information about versions and regions
  • Get and Transform (Power Query)
  • Week 1 Introduction
  • Introduction to Power Query
  • Get and transform data from Excel
  • Get data from a database
  • Get data from a folder
  • Append queries with 2 datasets
  • Append queries with 3 or more datasets
  • Merge queries — Left Outer join
  • Merge queries — Inner and Anti joins
  • Read me before you start: Quizzes and Navigation
  • Download the Week 1 workbooks
  • Week 1 Practice Challenge
  • Week 1 Toolbox
  • Introduction to Power Query
  • Get and transform data from Excel
  • Get data from a database
  • Get data from a folder
  • Append queries with 2 datasets
  • Append queries with 3 or more datasets
  • Merge queries — Left Outer join
  • Merge queries — Inner and Anti joins
  • Transforming data in the Query Editor
  • Week 2 Introduction
  • Applying transformations with the Query Editor
  • Unpivoting data
  • Pivoting data in the Query Editor
  • Grouping data
  • Working with columns in Office 365
  • Working with columns in Excel 2016
  • Download the Week 2 workbooks
  • Working with columns — difference in versions
  • Week 2 Practice Challenge
  • Week 2 Toolbox
  • Applying transformations with the Query Editor
  • Unpivoting data
  • Pivoting data in the Query Editor
  • Grouping data
  • Working with columns
  • Test your skills: Weeks 1 and 2
  • Power Pivot and the Data Model
  • Week 3 Introduction
  • Adding data to the Data Model
  • Data Modelling
  • Analysing data with Power Pivot
  • Visualising data with Power Pivot and Cube Functions
  • Introduction to DAX measures
  • Applying Time Intelligence and CALCULATE
  • Download the Week 3 workbooks
  • Week 3 Practice Challenge
  • Week 3 Toolbox
  • Adding data to the Data Model
  • Data Modelling
  • Analysing data with Power Pivot
  • Visualising data with Power Pivot and Cube Functions
  • Introduction to DAX measures
  • Applying Time Intelligence and CALCULATE
  • Test your skills: Week 3
  • Visualising Data with Power BI
  • Week 4 Introduction
  • Introducing Power BI
  • Adding a Calendar using DAX
  • Creating a Power BI report
  • Working with reports
  • Adding time intelligence
  • Sharing Power BI reports
  • Download the Week 4 workbooks
  • Week 4 Practice Challenge
  • Week 4 Toolbox
  • Introducing Power BI
  • Adding a Calendar using DAX
  • Creating a Power BI report
  • Working with reports
  • Adding time intelligence
  • Sharing Power BI reports
  • Test your skills: Week 4

Summary of User Reviews

This Excel Power Tools course has received high praise from many users for its comprehensive content and practical application. One key aspect that many users thought was good is the course's focus on real-world examples and exercises that help learners apply the tools and techniques in their work. Overall, the course has received positive reviews from users.

Pros from User Reviews

  • Comprehensive content that covers a wide range of Excel tools and techniques
  • Real-world examples and exercises that help learners apply the tools and techniques in their work
  • Engaging and knowledgeable instructors who provide clear explanations and demonstrations

Cons from User Reviews

  • Some users found the course to be too basic and not challenging enough
  • The course is quite lengthy and may require a significant time commitment
  • The course may not be suitable for advanced Excel users who are already familiar with many of the tools and techniques covered
English
Available now
Approx. 15 hours to complete
Nicky Bull, Dr Prashan S. M. Karunaratne
Macquarie University
Coursera

Instructor

Nicky Bull

  • 4.8 Raiting
Share
Saved Course list
Cancel
Get Course Update
Computer Courses