100+ Excel Formulas-Learn Formulas from beginner to advanced

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

Complete Microsoft Excel Formulas/Functions hands on training with Real Life Practical Examples. Learn & don't memorize!

1 - 01 The Beginning Setting up the Right Way

1 - L01 Housekeeping expectations outline

2 - Sneak peak into the Ms Excel Formula course

3 - L02 Understanding the degree of difficulty of each lesson the star concept

4 - AllCompletedWorkbooks.zip

4 - AllPPT.zip

4 - AllToDoWorkbooks.zip

4 - All Material for Course.html

2 - 02 Formula 101

1 - Test your might Formula 101.html

5 - 02.Formulas101.pptx

5 - 02-Formula101-Completed.xlsx

5 - 02-Formula101-ToDo.xlsx

5 - Material to Download for Section.html

6 - L01 Intro

7 - L02 Excel Formula Syntax

8 - L03 Referencing other Workbooks or Worksheets

9 - L04 Order of Preference in Calculations

10 - L05 Cell Referencing

11 - L06 Hack How to Copy Formulas and reference original range

12 - L07 Common Error types

13 - L08 Formula Auditing Part 1

14 - L09 Evaluate Formula Error Checking

15 - L10 Go to Special Feature

16 - L11 Useful Shortcuts

17 - L12 Formula Shortcuts

18 - L13 Menu Shortcuts

19 - Exceljet-Excel-Shortcuts-160623.pdf

19 - L14 PC Mac Extensive Shortcut List.html

20 - L15 Increase the size of the Text in the Formula Bar

21 - L16 Basic Excel Formulas you need to know

22 - L17 Calculate Percentages correctly

23 - L18 Circular Reference

24 - L19 Data Validation Basics

24 - data validation playlist for advanced users.zip

24 - my youtube channel excel wizard in minutes.zip

25 - L20 Unstack your data with this trick

26 - L21 Transpose to Horizontal

27 - L22 Transpose to Vertical

3 - 03 IF statements Logical Operators

28 - 03-IFstatements-LogicalOperators-Completed.xlsx

28 - 03-IFstatements-LogicalOperators-ToDo.xlsx

28 - 03.IFstatements-LogicalOperators.pptx

28 - Material to download for Section.html

29 - L01 Intro

30 - L02 If Statement

31 - L03 Nested IF Statement

32 - L04 And Or Conditions

33 - L05 Not with IF

34 - L06 IFS statement Emojis trick

34 - conditional formatting rules.zip

34 - my youtube channel excel wizard in minutes.zip

35 - L07 IFerror

36 - L08 Isxxx statements Row coloring trick

37 - L09 IF with partial match Pro trick

4 - All About Stats

38 - 04.AllAboutStats.pptx

38 - 04-AllAboutStats-Completed.xlsx

38 - 04-AllAboutStats-ToDo.xlsx

38 - Material to download for Section.html

39 - L01 Intro

40 - 04-01.Round

40 - L02 Round Normal Up or Down

41 - L03 Popular Stat functions

42 - L04 Ranking Basics

43 - L05 Percentile

44 - L06 Dealing with Randomness

45 - L07 Ratios in Excel

46 - L08 Sumproduct Basic Use

47 - L09 Master Sumproduct

48 - L10 Countifs Sumifs Averageifs

49 - L11 Sumifs with Dates EOMonth formula

50 - L12 Build a Dynamic Mini Dashboard with Sumifs Countifs AverageIf

51 - L13 Identify and Count Duplicates in 1 step Range Name

52 - L14 Sumif with Partial Match

53 - L15 Control Shift Enter

54 - L16 MinIFs MaxIfs Aggregate How to get minmax with conditions

55 - L17 Advanced Ranking No skip

5 - Lookups

56 - 05.Lookups.pptx

56 - 05-Lookups-Completed.xlsx

56 - 05-Lookups-ToDo.xlsx

56 - Material to download for Section.html

57 - L01 Intro

58 - L02 Named Ranges Excel Tables

59 - L03 Vlookup Hlookup

60 - L04 Row Rows Column Columns practical application

61 - L05 Joining Data with Vlookup

62 - L06 Improve your Vlookup with an Excel Table

63 - L07 Troubleshoot your Vlookup

64 - L08 Approximate Match for Vlookup for lookup within boundaries

65 - L09 Index Match Basics

66 - L10 Index Match Advanced

67 - L11 Lookup in different sheets with Indirect

68 - L12 Reverse Lookup problem

69 - L13 Complex Lookup with Index Sumproduct

70 - L14 Xlookup

71 - L15 Cool HR Dashboard with XLOOKUP

72 - L16 Choose Formula and its applications

73 - L17 Offset with Rolling average example

74 - L18 YTD Calculations with Offset Sumproduct

75 - L19 Offset and Charts

76 - L20 Multiple Matches

6 - Dealing with Text

77 - 06.Text.pptx

77 - 06-Text-Completed.xlsx

77 - 06-Text-ToDo.xlsx

77 - Material to download for Section.html

78 - L01 Intro

79 - L02 Flash Fill

80 - L03 Changing the Case of Text

81 - L04 Concatenate Text

82 - L05 Text Extraction

83 - L06 Text Value

84 - L07 Search Find practical application

85 - L08 Combining Search Find with other functions for powerful results

86 - L09 More Complex example with SearchFind

87 - L10 Substitute

88 - L11 System Data

7 - Date Time

89 - 07.Dates.pptx

89 - 07-Dates-Completed.xlsx

89 - 07-Dates-ToDo.xlsx

89 - Material to Download for Section.html

90 - L01 Intro

91 - L02 Dates Basics

92 - L03 Flash fill Format

93 - L04 Today Now

94 - L05 Date fields extraction

95 - L06 Get FirstLast day of the month and First day of the year

96 - L07 YearFrac

97 - L08 Workday WorkdayIntl

98 - L09 Networkdays NetworkdaysINTL Changing holiday list

99 - L10 Weekday DateDif

100 - L11 Count Fridays between 2 days

101 - L12 Define a custom weekend in Networkdays

8 - Formatting with Formulas

102 - 08.Formatting.pptx

102 - 08-Format-Completed.xlsx

102 - 08-Format-ToDo.xlsx

102 - Material to download for Section.html

103 - L01 Intro

104 - L02 Conditional formatting rules with formula

105 - L03 Boring Mod used in a Powerful way

106 - 08-04.ConditionalFormattingwithlogicalops

106 - L04 Conditional formatting with logical operators

107 - L05 Adding icons to your reports

107 - website with all icon codes.zip

108 - L06 Matrix Coloring

9 - Dynamic Array formulas Office 365

109 - 09.ExcelArrays.pptx

109 - 09.ExcelArray-ToDo.xlsx

109 - 09.excelarray-completed.zip

109 - Material to download for Section.html

110 - L01 Intro

111 - L02 The Situation

112 - L03 The Buzz about dynamic arrays

113 - L04 Spill Range

114 - L05 Excel Table to automatically calculate formulas for new data

115 - L06 Important new Excel Functions

116 - L07 Sort

117 - L08 Sortby

118 - L09 Filter

119 - L10 Unique

120 - L11 Filtering non adjacent columns

121 - L12 Creating a dropdown menu

122 - L13 Filtering based on DropDown Menu

123 - L14 Improve your calculations with Dynamic Arrays

124 - L15 Formatting with Dynamic Arrays

125 - L16 Charts with Dynamic Arrays

126 - L17 Sequence

127 - L18 Real life Dashboard with Sequence Filter Sort

128 - L19 Recap of Randarray

129 - L20 Frequency

130 - L21 Create a Matrix with Transpose

131 - L22 Merging Spilled ranges

132 - L23 Simplify your formula with Let

139,000 تومان

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

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

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

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