1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
Excel: Managing and Analyzing Data (2022) Preview

Excel: Managing and Analyzing Data (2022)

With Oz du Soleil Liked by 6,010 users
Duration: 3h 44m Skill level: Intermediate Released: 9/26/2022

Start my 1-month free trial Buy for my team

Course details

Ready to start working with spreadsheets like a pro? Join Excel MVP Oz du Soleil as he shares how to clean, organize, and analyze large amounts of data with ease using commands, features, and functions within Microsoft Excel. Instead of focusing on pure analysis (forecasting, running regressions, etc.), Oz covers how to use built-in Excel tools to prepare your data for analysis and extract the information that supports your mission.

Oz dedicates the first portion of the course to an often-overlooked part of data analysis: checking data quality. He then steps through how to prepare your data for analysis by setting it up into sortable, filterable columns and rows. Next, Oz shares how to work with multiple data sets at once; sort and filter data; and use functions to isolate and analyze data. Plus, learn how to work with the newest features in Excel, including Power Query and dynamic arrays, which make it so much easier to get what you need from your data without clumsy, complicated, and delicate formulas. With these techniques, you'll be prepared to quickly and effectively extract important information from even your largest spreadsheets.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.8 out of 5

5,070 ratings
  • 5 star
    Current value: 4,161 82%
  • 4 star
    Current value: 723 14%
  • 3 star
    Current value: 147 3%
  • 2 star
    Current value: 15 <1%
  • 1 star
    Current value: 24 <1%
  • Raghunandan S Raghunandan S

    Raghunandan S

    --

    5/5 March 26, 2025
    Super
    Helpful · Report
  • Jamie Stone Jamie Stone

    Jamie Stone

    Area Operations Controller G4s

    4/5 March 24, 2025
    Very informative coarse
    Helpful · Report
  • Taimur Ahmed Taimur Ahmed

    Taimur Ahmed

    Project Manager, Quality Management, Supply Chain Management, AI for Project Managers, Financial Management, Human Resource Development, Leadership &…

    5/5 March 21, 2025
    i have already submitted my concerns and its regarding Chapter 2&3, PQs, the Excel interface which the instructor is using is different than in Excel 365 and Excel 2016, compatibility and feature mismatch issue. also the instructor should update these lectures as per the features available on Excel 365.
    Helpful · Report

Contents

What’s included

  • Practice while you learn 1 exercise file
  • Learn on the go Access on tablet and phone
  • Stay up to date Continuing Education Units

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play