Master Excel From Scratch: Excel 2024 Challenge

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

Excel mastery From Scratch 2024: Empower yourself with essential skills, advanced techniques and real power of Excel.

1. Day 1 Introduction

1. Starting with Excel

2. Excel Basics- I

3. Excel Basics- II

4. Excel Basics- III

2. Day 2 Basic Formulas

1. Data Entry- I

2. Data Entry- II

3. SUM

4. 5 Basic Formulas

3. Day 3 Sorting and Filter

1. Sort

2. Filter- I

3. Filter- II

4. Advance Filter

5. Macro- I

6. Macro- II

4. Day 4 Data Validation

1. Data Validation- I

2. Data Validation- II

3. Data Validation- III

5. Day 5 Conditional Formatting

1. Conditional Formatting- I

2. Conditional Formatting- II

3. Conditional Formatting- III

6. Day 6 Text to Column and Flash Fill

1. Text to Column

2. Flash Fill

7. Day 7 Remove Duplicates and Paste Special

1. Remove Duplicates

2. Paste Special- I

3. Paste Special- II

4. Paste Special- III

5. Paste Special- IV

6. Paste Special- V

7. Paste Special- VI

8. Day 8 IF Formula [IF, AND, OR]

1. IF Formula

2. IF with AND Formula

3. IF with OR Formula

4. IF Nested

9. Day 9 Statistical Formulas

1. COUNTIF & SUMIF

2. SUMIFS & COUNTIFS

10. Day 10 More Formulas

1. Index & Match

2. Date

3. DatedIF

11. Day 11 VLOOKUP & HLOOKUP

1. VLOOKUP & HLOOKUP

2. row & column formulas

12. Day 12 Text Formulas in Excel

1. UPPER, LOWER & PROPER

2. 5 Text Formulas

3. MID

13. Day 13 Professional Printing and Pivot Table

1. Printing in Excel- I

2. Printing in Excel- II

3. Pivot Table

4. Pivot Chart

5. Slicer

6. Timeline

14. Day 14 ChatGPT & XLOOKUP

1. ChatGPT

2. XLOOKUP- I

3. XLOOKUP- II

15. Day 15 Financial Functions

1. Filter Formula

2. Sort Formula

3. Financial Functions

16. Additional Content Old Videos of Excel for Revision

1. Information.html

2. Lesson 1- What is Excel

3. Lesson 2- Open-Input-Save

4. Lesson 3- Customization

5. Lesson 4- Interface

6. Lesson 5- Formula-Status-Bar

7. Lesson 6- Tabs

8. Lesson 7- Navigation

9. Lesson 8- Shortcuts

10. Lesson 9- Basic Formulas- I

11. Lesson 10- Basic Formulas- II

12. Lesson 11- Basic Formulas- III

13. Lesson 12- Basic Formulas- IV

14. Lesson 13- Basic Formulas- V

15. Lesson 14- Basic Formulas- VI

16. Lesson 15- Find and Replace

17. Lesson 16- Advanced Find and Replace

18. Lesson 17- Assignment- I

19. Lesson 18- Solution- I

20. Lesson 19- Data Formatting

21. Lesson 20- Copying External Data

22. Lesson 21- Organize Data

23. Lesson 22- Arrange Data

24. Lesson 23- Text Conversion

25. Lesson 24- Text to Columns

26. Lesson 25- Relative Reference

27. Lesson 26- Assignment- 2

28. Lesson 27- Absolute Reference

29. Lesson 28- Mixed Referencing

30. Lesson 29- Data Validation

31. Lesson 30- Types of Data Validation

32. Lesson 31- Ask Y or N

33. Lesson 32- Data Validation Example

34. Lesson 33- Conditional Formatting

35. Lesson 34- Conditional Formatting Example

36. Lesson 35- Practice

37. Lesson 36- Upper-Lower

38. Lesson 37- Proper-Trim

39. Lesson 38- Proper-Trim Editing

40. Lesson 39- VLOOKUP

41. Lesson 40- Index-Match

42. Lesson 41- Task- I

43. Lesson 42- SUMIFS

44. Lesson 43- AVERAGEIFS

45. Lesson 44- Task- II

46. Lesson 45- WORKDAY.INTL

47. Lesson 46- Task- III

48. Lesson 47- Presenting Data

49. Lesson 48- Choose

139,000 تومان

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

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

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

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