Excel 365 – Expert

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

Getting the most out of Excel

1. Introduction

1. Welcome and Introduction

2. Leveraging Worksheet Automation

1. Examining Worksheet Automation

2. Enabling the Developer Tab

3. Understanding Form Controls and ActiveX Controls

4. Examining Starter Worksheets

5. Adding a Spinner Control

6. Adding a Drop-Down Box

7. Adding Option Buttons

8. Adding Check Boxes

3. Consolidating Data for Analysis

1. Consolidating Data with a 3-D Formula

2. Consolidating Data with the Consolidate Feature

4. Enhancing Analysis with Data Types

1. Understanding Organizational Data

2. Using Organizational Data

3. Using Stock Data

4. Using Currency Conversion Data

5. Using Geographic Data

5. Modeling Tables in Power Pivot

1. Understanding Data Modeling

2. Enabling the PowerPivot Tab

3. Understanding Table Relationships

4. Adding Tables to a Model

5. Importing Data

6. Creating Table Relationships Manually

7. Understanding Data Types

8. Formatting Data in a Model

9. Creating PivotTables and PivotCharts

10. Creating Calculated Columns

11. Creating Measures

12. Creating KPIs

6. Using Advanced Lookup Functions

1. Using the OFFSET Function

2. Using VLOOKUP with Multiple Criteria

3. Using Wildcards with VLOOKUP

4. Using FORMULATEXT to Reveal a Formula

5. Using ISFORMULA Function

6. Using the IFNA Function

7. Using the XLOOKUP Function

8. Performing an XLOOKUP Function with an Array

9. Performing a Relative XLOOKUP

10. Performing an XLOOKUP in Reverse Order

11. Using Wildcards with XLOOKUP

12. Using XLOOKUP to Compare Two Lists

13. Combining Content for a Unique Lookup

14. Using XMATCH to Find Rank in a List

7. Using Dynamic Array Functions

1. Understanding Dynamic Arrays

2. Using the UNIQUE Function

3. Using the FILTER Function

4. Using the SORT Function

5. Using the SORTBY Function

6. Using the SEQUENCE Function

8. Analyzing Data with Financial Functions

1. Examining Financial Functions

2. Using the FV Function

3. Using the PV Function

4. Using the PMT Function

5. Examining Forecasting Functions

6. Using the FORECAST Function

7. Using the FORECAST Function with a Visualization

8. Using the TREND Function

9. Using the GROWTH Function

9. Analyzing Data with Statistical Functions

1. Examining Statistical Functions

2. Using the GEOMEAN Function

3. Using the LARGE Function

4. Using the MEDIAN Function

5. Using the MODE Function

6. Using the RANK.EQ and RANK.AVG Functions

10. Performing Advanced What-If Analysis

1. Activating Solver

2. Using Solver

3. Activating the Analysis ToolPak

4. Creating Descriptive Summaries with the Analysis ToolPak

5. Creating a Histogram with the Analysis ToolPak

6. Creating a Histogram using the Newer Chart Types

7. Using Forecast Sheets

11. Conclusion

1. Course Recap

12. Excel 365 Expert Assessment

1. Assessment Test.html

139,000 تومان

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

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

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

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