Excel: Managing and Analyzing Data

5.0 /5

(1 Rating)

Offered byLinkedin Learning

Excel: Managing and Analyzing Data
at
Linkedin Learning
Overview

Ready to start working with spreadsheets like a pro

Duration	4 hours
Total fee	₹1,400
Mode of learning	Online
Difficulty level	Intermediate
Credential	Certificate

Excel: Managing and Analyzing Data
at
Linkedin Learning
Highlights

Earn a certificate of completion from LinkedIn Learning

Excel: Managing and Analyzing Data
at
Linkedin Learning
Course details

Skills you will learn

Excel Conditional Formatting Vlookup Data analysis Forecasting

More about this course

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
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

Excel: Managing and Analyzing Data
at
Linkedin Learning
Curriculum

Introduction

Managing and analyzing data in Excel

Checking Data Quality

The importance of checking data quality

Use the UNIQUE function to investigate data and data quality

Check data quality with a PivotTable

Check for duplicates with formulas

Find duplicates and stray values with Conditional Formatting

Deciding if your data is ready for use

Splitting Columns for Data Clean-Up

Splitting columns with Flash Fill

Splitting columns with Dynamic Arrays

Splitting columns with Power Query

Splitting columns into rows

Data Preparation

Structure data for optimum usage in Excel

The power and majesty of Excel's Tables

Using COUNTA to evaluate and monitor your data

Power Query: Unpivot

Convert an array to a column with TOCOL

Convert a report to raw, useful data

Working with Multiple Data Sets

Find and retrieve data with VLOOKUP and XLOOKUP

Import and combine data sets in Power Query

Append data sets

Overview of Power Query joins

Using the Power Query joins feature

Power Query vs. XLOOKUP

Sorting and Filtering Data

Sort with multiple criteria

Sort by cell color, font color, or cell icon

Sort by custom list

Sort in Power Query

Use Dynamic Arrays: SORT, SORTBY

Use the FILTER dynamic array function

Use text, numeric, and date filters

Filter in Power Query

Filter table data interactively with slicers

Other Data Analysis Tools and Methods

SUMIFS, COUNTIFS, and related functions for data analysis

A quick word about PivotTables

Using PivotTables for basic analysis

Using tables to support PivotTable integrity

Identify top or bottom values with Conditional Formatting

Conclusion

Continue your data stewardship

Excel: Managing and Analyzing Data
at
Linkedin Learning
Faculty details

Oz du Soleil

He has been working with data and Excel for many years, and have developed a passion for clean data and reliable reporting. An even greater passion is that of teaching, sharing knowledge and empowering people to do handle their data more efficiently and with greater skill to turn their data into useful information.