Data Analysis Functions and Techniques in Microsoft Excel

Focused View

Janani Ravi

49:43

0 View

1. Logical and Conditional Functions

1. Microsoft Excel Data Analysis Functions Techniques.mp4

00:37

2. Demo - The IF and IFS Logical Functions.mp4

04:03

3. Demo - The SUMIF and COUNTIF Functions.mp4

02:59

4. Demo - The Logical AND and OR Functions.mp4

02:48

02. Lookup and Reference Functions

01. Demo - VLOOKUP in a Single Sheet.mp4

02:23

02. Demo - VLOOKUP with Multiple Sheets and Named Ranges.mp4

03:23

03. Demo - HLOOKUP for Row-wise Lookups.mp4

01:47

04. Demo - Limitations of VLOOKUP.mp4

02:44

05. Demo - Lookup Cells with INDEX.mp4

01:50

06. Demo - Dynamic Lookup with INDEX and MATCH.mp4

02:04

07. Demo - Multicriteria INDEX and MATCH.mp4

02:23

08. Demo - Performing Lookups and Handling Errors with XLOOKUP.mp4

02:31

09. Demo - Partial Matches and Row-wise Lookups with XLOOKUP.mp4

02:22

10. Demo - Dynamic Multicriteria Lookups with Nested XLOOKUP.mp4

02:04

3. Scenarios and What-if Analysis

1. Demo - Goal Seek for Break Even Analysis.mp4

03:04

2. Demo - Using the Scenario Manager for What-if Analysis.mp4

04:20

3. Demo - Sensitivity Analysis with Data Table.mp4

02:57

4. Data Visualizations with Sparklines

1. Demo - Line and Column Sparklines.mp4

03:51

2. Demo - WinLoss Sparklines.mp4

01:33

Description

This course will enable you to implement logical functions, lookup and reference functions, what-if analyses, and visualization with sparklines, using datasets to evaluate sales, credit eligibility, employee data, and investment scenarios.

What You'll Learn?

Excel data analysis skills will help you make informed business decisions.

In this course, Data Analysis Functions and Techniques in Microsoft Excel, you’ll gain the ability to analyze and interpret complex datasets.

First, you’ll explore how to use logical functions like IF, IFS, SUMIF, and NESTED IFS to categorize sales and profit levels, classify products, and evaluate credit eligibility criteria for customers.

Next, you’ll discover how to implement lookup and reference functions such as VLOOKUP, XLOOKUP, INDEX, and MATCH to efficiently find and reference data across single and multiple sheets, with a focus on employee-related data.

Finally, you’ll learn how to perform what-if analysis using Goal Seek, Scenario Manager, and data table functions to assess the impact of various business scenarios, as well as how to visualize data trends and comparisons using sparklines charts.

When you’re finished with this course, you’ll have the skills and knowledge of Excel data analysis needed to confidently analyze, interpret, and visualize data, driving better decision-making in your organization.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Janani Ravi

Instructor's Courses

Janani has a Masters degree from Stanford and worked for 7+ years at Google. She was one of the original engineers on Google Docs and holds 4 patents for its real-time collaborative editing framework. After spending years working in tech in the Bay Area, New York, and Singapore at companies such as Microsoft, Google, and Flipkart, Janani finally decided to combine her love for technology with her passion for teaching. She is now the co-founder of Loonycorn, a content studio focused on providing high-quality content for technical skill development. Loonycorn is working on developing an engine (patent filed) to automate animations for presentations and educational content.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.