Complete Microsoft Advanced Excel Certification

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

Best for Data Analysist, MIS, Finance & Accounting, Data Handling etc. Excel Version 2010, 2013, 2016, 2019 & Office 365

1. Introduction to Microsoft Excel

1. Introduction And Importance of Microsoft Excel

2. Quick Tour of Microsoft Excel Software

2. Microsoft Excel Fundamentals (Basic Excel)

1. Microsoft Excel Layout

2. Data Editing

3. Copy Paste Special

4. Working with Numbers

5.1 References Exercise.xlsx

5. References in Excel

6. Hide And Unhide

7. Advance Fill

8. Text To Column

9. Flash Fill

10. Customized View

11. Comparing data from different sheets

12. Working with Hyperlinks

13.1 Basic Functions (Sum, Average, Count, Max, Min) Exercise.xlsx

13. Basic Functions (Sum, Average, Count, Max, Min)

14. Proofing (Spelling And Thesaurus)

15. Page Layout

3. Microsoft Excel Advance Functions (Advance Excel)

1. Conditional Formatting

2. Advance Table

3. Advance Filter

4. Sort And Subtotal

5. Formulas and Functions - Topic 1 - Text Function

6. Formulas and Functions - Topic 2 - Date Function

7. Formulas and Functions - Topic 3 - Logical functions (If, And, Or)

8. Formulas and Functions - Topic 4 - Statistical Functions

9. Vlookup And Hlookup

10. Vlookup with Match

11. Index And Match Function

12. Working with Array

13. Error Handling

14. Advance Range

15. Data Validation

16. Data Consolidation

17. Solver Add-In

18. Illustrations (Pictures, Shapes, SmartArt)

19. Working with Charts (Graphs)

20. Pivot Table

21. What if Analysis (Goal Seek, Data Table, Scenario Manager)

22. Import And Export

4. Dashboard Creation for Automatic Data handling in Excel

1. Dashboard Creation

5. Microsoft Excel VBA And Macro

1. Introduction to VBA And Macro

2. Recording Macro

3. Working with VBA (Writing a code for Macro)

6. Shortcut Keys in Microsoft Excel

1. Shortcut Keys in Microsoft Excel.html

139,000 تومان

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

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

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

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