Data Analysis Functions and Techniques in Microsoft Excel

سرفصل های دوره

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.

1. Logical and Conditional Functions

1. Microsoft Excel Data Analysis Functions Techniques

2. Demo - The IF and IFS Logical Functions

3. Demo - The SUMIF and COUNTIF Functions

4. Demo - The Logical AND and OR Functions

02. Lookup and Reference Functions

01. Demo - VLOOKUP in a Single Sheet

02. Demo - VLOOKUP with Multiple Sheets and Named Ranges

03. Demo - HLOOKUP for Row-wise Lookups

04. Demo - Limitations of VLOOKUP

05. Demo - Lookup Cells with INDEX

06. Demo - Dynamic Lookup with INDEX and MATCH

07. Demo - Multicriteria INDEX and MATCH

08. Demo - Performing Lookups and Handling Errors with XLOOKUP

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

10. Demo - Dynamic Multicriteria Lookups with Nested XLOOKUP

3. Scenarios and What-if Analysis

1. Demo - Goal Seek for Break Even Analysis

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

3. Demo - Sensitivity Analysis with Data Table

4. Data Visualizations with Sparklines

1. Demo - Line and Column Sparklines

2. Demo - WinLoss Sparklines

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight