Excel your knowledge with MS Excel

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

Mastering Excel: From Basics to Advanced Techniques

1 - Formatting in Excel

1 - 1.Basic-Formatting.xlsx

1 - Basic Formatting

2 - 2.Conditional-Formatting.xlsx

2 - Conditional Formatting

2 - Mathematical Functions

3 - Mathematical Functions Part1

3 - Mathematical-Functions-Part-1.xlsx

4 - Mathematical Functions Part2

4 - Mathematical-Functions-Part-2.xlsx

5 - Mathematical Functions Part3

5 - Mathematical-Functions-Part-3.xlsx

6 - Mathematical Functions Part4

6 - Mathematical-Functions-Part-4.xlsx

3 - Statistical Functions

7 - Statistical Functions Part1

7 - Statistical-Functions-Part-1.xlsx

8 - Statistical Functions Part2

8 - Statistical-Functions-Part-2.xlsx

9 - Statistical Functions Part3

9 - Statistical-Functions-Part-3.xlsx

10 - Statistical Functions Part4

10 - Statistical-Functions-Part-4.xlsx

4 - Text Functions

11 - Text Functions Part1

11 - Text-Functions-Part-1.xlsx

12 - Text Functions Part2

12 - Text-Functions-Part-2.xlsx

13 - Text Functions Part3

13 - Text-Functions-Part-3.xlsx

14 - Text Functions Part4

14 - Text-Functions-Part-4.xlsx

5 - Date and Time Function

15 - Date and Time Functions Part1

15 - Date-and-Time-Functions.xlsx

16 - Date and Time Functions Part2

6 - Lookup Functions Vlookup Hlookup Lookup Index and Match Function

17 - Lookup Functions Part1

17 - Vlookup-Hlookup-and-Lookup.xlsx

18 - Lookup Functions Part2

19 - Lookup Functions Part3

20 - Index-and-Match.xlsx

20 - Lookup Functions Part4

7 - Logical Functions

21 - 1.Logical-Function-Part-1.xlsx

21 - Logical Function Part1

22 - Logical Function Part2

23 - 2.Logical-Function-Part-2-and-3.xlsx

23 - Logical Function Part3

8 - Data analysis using Pivot Table

24 - Pivot Table Part1

24 - Pivot-Table.xlsx

25 - Pivot Table Part2

26 - Pivot Table Part3

9 - Data Cleaning and Analyzing Data in Excel

27 - 1.Sort-Filter-Find-and-Replace.xlsx

27 - Sort

28 - Filter Find and Replace

29 - 2.Text-to-column.xlsx

29 - Text to column

30 - 3.Flashfill.xlsx

30 - Flashfill

31 - 4.Remove-Duplicate.xlsx

31 - Remove Duplicate

32 - 5.Data-Validation.xlsx

32 - Data Validation

33 - 6.Advanced-Worksheet-Protection.xlsx

33 - Advanced Worksheet Protection

34 - 7.Consolidation.xlsx

34 - Consolidate

35 - 8.What-if-Analysis.xlsx

35 - What if Analysis

36 - 9.Forecast-Sheet.xlsx

36 - Forecast Sheet

37 - 10.Group-Ungroup-and-Subtotal.xlsx

37 - Group Ungroup and Subtotal

10 - Various types of Errors in Excel

38 - Common Errors in Excel

38 - Various-types-of-Errors-in-Excel.xlsx

139,000 تومان

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

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

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

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