Microsoft Excel – Advanced Excel Formulas & Functions

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

Master Microsoft Excel - Advanced Excel Formulas & Functions, PivotTable, PivotChart and Power Pivot

1. Introduction

1. Introduction

2.1 Excel 1.1 (Advance).xlsx

2.2 Excel 1.1.xlsx

2. Course Excercise Files

2. Excel PivotTables

1. Understanding Excel PivotTables

2. Creating Excel PivotTable In Same Worksheet

3. Creating Excel PivotTables In New Worksheet

4. Grouping PivotTable Data In Excel

5. Formatting PivotTable Data In Excel

6. Modifying PivotTable Calculations In Excel

7. Drilling Down Into PivotTable In Excel

8. Creating PivotChart Base On PivotTable In Excel

9. Filter Option In PivotTable Data In Excel

10. Filtering With Slicer Tool Technique In Excel

11. Excel PivotTable Quiz.html

3. PowerPivot

1. Explaining PowerPivot And Add-In PowerPivot Tab In Ribbon

2. Creating Data Model For PowerPivot In Excel

3. Creating Relationship After Creating Data Model

4. Creating PivotTable Base On Data Model

5. Excel Power Pivot Quiz.html

4. Working With Large Set Of Excel Data

1. Freeze Panes Tool In Excel

2. Grouping (Outline) Data In Excel

3. Linking Worksheet In Excel

4. Linking Worksheet With Consolidate Tool In Excel

5. Print Options For Large Set Of Data In Excel

6. Excel Large Set Quiz.html

5. Working With Excel Conditional Function

1. Working With Name Ranges In Excel

2. Editing Name Ranges In Excel

3. Using If Function In Excel

4. Nesting or Multiple Functions In Excel

5. Using And Function With If Function Together

6. Using CountIf Function In Excel

7. Using SumIf Function In Excel

8. Using IfError Function In Excel

9. Excel Conditional function Quiz.html

6. Working With Lookup Function In Excel

1. Using Vlookup Function In Excel

2. Using Hlookup Function In Excel

3. Using Index Function In Excel

4. Using Match Function In Excel

5. Using Hlookup+Match Function In Excel

6. Excel Lookup Function Quiz.html

7. Working With Excel Text Based Functions

1. Using Left, Right & Mid Function In Excel

2. Using Len Function In Excel

3. Using Concatenate Function In Excel

4. Excel Text Based Quiz.html

8. Working With Formula Auditing In Excel Worksheet

1. Using Trace Precedent In Excel

2. Using Trace Dependents Function In Excel

3. Using Show Formula Function In Excel

4. Using Watch Window Function In Excel

5. Excel Formula Auditing Quiz.html

9. Protecting Excel Worksheets And Workbooks

1. Protecting Complete Or Specific Cell In A Worksheet

2. Protecting The Structure Of A Workbook In Excel

3. Protecting Workbook With Password In Excel

4. Excel Protection Quiz.html

10. Using What-If Analysis Tools In Excel

1. Using Goal Seek Tool In Excel

2. Using Data Table Tool In Excel

3. Using Scenario Manager Tool In Excel

4. Excel What-if Analysis Quiz.html

179,000 تومان

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

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

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

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