Excel 365 From Beginner To Advanced

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

1 - Introduction

1 - 1.Excel-NoSol.xlsx

1 - 11 Introduction

2 - 12 Format Cell

3 - 13 Format Text in the Cell

4 - 14 Format Number in the Cell

5 - 15 Formula

6 - 16 Copy Paste

7 - 17 Exercise 1

8 - 18 Exercise 2

9 - 19 Exercise 3

10 - 110 Exercise 4

11 - 1.Excel-Solved.xlsx

11 - 111 Exercise 5

2 - Table and Pivot Table

12 - 2.Table-NoSol.xlsx

12 - 21 Sort Filter and Subtotal

13 - 22 Excel Table Ctrl T

14 - 23 Custom Sort and other Filter options

15 - 24 Introduction to Pivot Table

16 - 25 Pivot Table Existing Sheet

17 - 26 Pivot Table Refresh

18 - 27 Pivot Table Calculated Field

19 - 28 Pivot Table Average and Other Functions

20 - 29 Pivot Table Count

21 - 2.Table-Sol.xlsx

21 - 210 Excersises

3 - Basic Charts Formulas and Functions

22 - 3.IF-NoSol.xlsx

22 - 31 Charts Column Chart

23 - 32 Charts Table and Column Bar Chart

24 - 33 Charts Line Chart

25 - 34 Charts Pie Chart

26 - 35 Pie Chart and Pivot Table

27 - 36 Basic Functions

28 - 37 Find

29 - 38 IF function

30 - 3.IF-Sol.xlsx

30 - 39 Vlookup function

4 - Array Formulas

31 - 4.Array-NoSol.xlsx

31 - 41 Introduction to Array Formulas

32 - 42 Basic Principles Behind Array Formulas

33 - 43 Filter the data using Array Formulas

34 - 44 DataTime and Array Formulas

35 - 45 IF and Array Formulas

36 - 46 Sumifs

37 - 47 Isnumber

38 - 4.Array-Sol.xlsx

38 - 48 Countifs

5 - Text Date and Lookup Formulas

39 - 5.Text-NoSol.xlsx

39 - 51 Application Quadratic Equation

40 - 52 Custom Number Formats

41 - 53 Application Arythmetic Operation Results

42 - 54 Creating Custom Formula Using Text Functions

43 - 55 Left Right and Middle

44 - 56 Last Word From The Sentence

45 - 57 Textjoin

46 - 58 Match

47 - 59 Xlookup

48 - 510 Datediff

49 - 511 Vlookup Approximate Match

50 - 5.Text-Sol.xlsx

50 - 512 Workdays and Networkdays

6 - Financial Applications

51 - 6.Fin-NoSol.xlsx

51 - 61 Simple and Compound Interest

52 - 62 Payment PMT

53 - 63 Loan Amortisation Schedule

54 - 64 Goal Seek

55 - 65 Data Table

56 - 66 Solver

57 - 67 Net Present Value NPV

58 - 68 Forecast

59 - 69 Conditional Formatting

60 - 610 Loan Scenario

61 - 6.Fin-Sol.xlsx

61 - 611 Profit and Loss Scenario

7 - Data Analysis

62 - 7.0ISETCL-Data-NoSol.xlsx

62 - 71 Relationships

63 - 7.2Relationships-OrdersTable.xlsx

63 - 72 Analysing Orders

64 - 7.2ValidationTable.xlsx

64 - 73 Data Validation

65 - 74 Protect and Hide

66 - 7.5ValidationTable.xlsx

66 - 75 Create Table with Validations

67 - 76 Indirect formula

68 - 7.7Offset.xlsx

68 - 77 Offset formula

69 - 78 Combining Offset and Indirect

70 - 7.9ExRates.xlsx

70 - 79 Combining Offset and If

8 - Business Inteligence BI Tools in Excel

71 - 8.1Excel-PowerPivotAndQuery.xlsx

71 - 81 Power Query and Power Pivot

72 - 8.2SalesData.rar

72 - 8.2Sales-DAX.xlsx

72 - 82 Coma Separated Values CSV

73 - 8.3FXSales.xlsx

73 - 83 Import From Web

74 - 8.4GoogleForms.xlsx

74 - 84 Import from Google Forms

139,000 تومان

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

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

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

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