Excel: Managing and Analyzing Data
With Oz du Soleil
Liked by 4,777 users
Duration: 3h 42m
Skill level: Intermediate
Released: 9/26/2022
Course details
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.
LinkedIn Learning
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
-
Esther Diora
Esther Diora
Marketing, Communications & Business Development Professional / Mental health & Sustainability advocate
-
-
Hindol Chattaraj
Hindol Chattaraj
Research intern at the Ministry of Commerce || M.A. Economics (Specialisation in Trade and Finance) , IIFT '25 || B.Sc Eco (Hons) , University of…
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