100+ Excel Formulas-Learn Formulas from beginner to advanced

Focused View

Rami Abou Jaoude

9:41:50

251 View

1 - 01 The Beginning Setting up the Right Way

1 - L01 Housekeeping expectations outline.mp4

05:33

2 - Sneak peak into the Ms Excel Formula course.mp4

05:13

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

00:47

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.mp4

02:06

7 - L02 Excel Formula Syntax.mp4

08:49

8 - L03 Referencing other Workbooks or Worksheets.mp4

05:09

9 - L04 Order of Preference in Calculations.mp4

04:27

10 - L05 Cell Referencing.mp4

07:21

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

02:58

12 - L07 Common Error types.mp4

06:56

13 - L08 Formula Auditing Part 1.mp4

04:57

14 - L09 Evaluate Formula Error Checking.mp4

03:48

15 - L10 Go to Special Feature.mp4

01:41

16 - L11 Useful Shortcuts.mp4

06:33

17 - L12 Formula Shortcuts.mp4

04:14

18 - L13 Menu Shortcuts.mp4

02:33

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.mp4

01:47

21 - L16 Basic Excel Formulas you need to know.mp4

07:37

22 - L17 Calculate Percentages correctly.mp4

08:13

23 - L18 Circular Reference.mp4

02:44

24 - L19 Data Validation Basics.mp4

06:53

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.mp4

05:20

26 - L21 Transpose to Horizontal.mp4

04:09

27 - L22 Transpose to Vertical.mp4

03:39

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.mp4

01:42

30 - L02 If Statement.mp4

05:49

31 - L03 Nested IF Statement.mp4

03:54

32 - L04 And Or Conditions.mp4

03:59

33 - L05 Not with IF.mp4

03:09

34 - L06 IFS statement Emojis trick.mp4

09:09

34 - conditional formatting rules.zip

34 - my youtube channel excel wizard in minutes.zip

35 - L07 IFerror.mp4

01:56

36 - L08 Isxxx statements Row coloring trick.mp4

06:55

37 - L09 IF with partial match Pro trick.mp4

05:59

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.mp4

01:58

40 - 04-01.Round.mp4

05:03

40 - L02 Round Normal Up or Down.mp4

06:07

41 - L03 Popular Stat functions.mp4

07:30

42 - L04 Ranking Basics.mp4

05:48

43 - L05 Percentile.mp4

06:46

44 - L06 Dealing with Randomness.mp4

08:08

45 - L07 Ratios in Excel.mp4

04:46

46 - L08 Sumproduct Basic Use.mp4

02:47

47 - L09 Master Sumproduct.mp4

10:58

48 - L10 Countifs Sumifs Averageifs.mp4

08:14

49 - L11 Sumifs with Dates EOMonth formula.mp4

06:49

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

06:23

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

03:49

52 - L14 Sumif with Partial Match.mp4

05:55

53 - L15 Control Shift Enter.mp4

06:44

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

10:10

55 - L17 Advanced Ranking No skip.mp4

08:51

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.mp4

02:04

58 - L02 Named Ranges Excel Tables.mp4

05:27

59 - L03 Vlookup Hlookup.mp4

08:31

60 - L04 Row Rows Column Columns practical application.mp4

09:53

61 - L05 Joining Data with Vlookup.mp4

06:51

62 - L06 Improve your Vlookup with an Excel Table.mp4

02:18

63 - L07 Troubleshoot your Vlookup.mp4

03:59

64 - L08 Approximate Match for Vlookup for lookup within boundaries.mp4

02:45

65 - L09 Index Match Basics.mp4

08:17

66 - L10 Index Match Advanced.mp4

06:13

67 - L11 Lookup in different sheets with Indirect.mp4

05:10

68 - L12 Reverse Lookup problem.mp4

05:02

69 - L13 Complex Lookup with Index Sumproduct.mp4

06:18

70 - L14 Xlookup.mp4

09:22

71 - L15 Cool HR Dashboard with XLOOKUP.mp4

11:11

72 - L16 Choose Formula and its applications.mp4

06:54

73 - L17 Offset with Rolling average example.mp4

04:48

74 - L18 YTD Calculations with Offset Sumproduct.mp4

09:16

75 - L19 Offset and Charts.mp4

07:24

76 - L20 Multiple Matches.mp4

05:47

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.mp4

01:18

79 - L02 Flash Fill.mp4

03:27

80 - L03 Changing the Case of Text.mp4

03:21

81 - L04 Concatenate Text.mp4

06:02

82 - L05 Text Extraction.mp4

04:15

83 - L06 Text Value.mp4

06:05

84 - L07 Search Find practical application.mp4

02:49

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

01:54

86 - L09 More Complex example with SearchFind.mp4

03:47

87 - L10 Substitute.mp4

02:07

88 - L11 System Data.mp4

04:41

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.mp4

01:17

91 - L02 Dates Basics.mp4

03:21

92 - L03 Flash fill Format.mp4

02:34

93 - L04 Today Now.mp4

01:25

94 - L05 Date fields extraction.mp4

01:28

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

03:19

96 - L07 YearFrac.mp4

02:33

97 - L08 Workday WorkdayIntl.mp4

03:59

98 - L09 Networkdays NetworkdaysINTL Changing holiday list.mp4

03:56

99 - L10 Weekday DateDif.mp4

04:45

100 - L11 Count Fridays between 2 days.mp4

03:35

101 - L12 Define a custom weekend in Networkdays.mp4

02:35

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.mp4

00:48

104 - L02 Conditional formatting rules with formula.mp4

06:39

105 - L03 Boring Mod used in a Powerful way.mp4

13:38

106 - 08-04.ConditionalFormattingwithlogicalops.mp4

03:05

106 - L04 Conditional formatting with logical operators.mp4

03:36

107 - L05 Adding icons to your reports.mp4

03:48

107 - website with all icon codes.zip

108 - L06 Matrix Coloring.mp4

04:19

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.mp4

01:51

111 - L02 The Situation.mp4

00:48

112 - L03 The Buzz about dynamic arrays.mp4

03:34

113 - L04 Spill Range.mp4

04:04

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

02:10

115 - L06 Important new Excel Functions.mp4

02:09

116 - L07 Sort.mp4

04:22

117 - L08 Sortby.mp4

02:12

118 - L09 Filter.mp4

05:51

119 - L10 Unique.mp4

01:58

120 - L11 Filtering non adjacent columns.mp4

06:43

121 - L12 Creating a dropdown menu.mp4

01:44

122 - L13 Filtering based on DropDown Menu.mp4

01:18

123 - L14 Improve your calculations with Dynamic Arrays.mp4

01:33

124 - L15 Formatting with Dynamic Arrays.mp4

02:08

125 - L16 Charts with Dynamic Arrays.mp4

02:58

126 - L17 Sequence.mp4

01:22

127 - L18 Real life Dashboard with Sequence Filter Sort.mp4

04:27

128 - L19 Recap of Randarray.mp4

01:24

129 - L20 Frequency.mp4

05:24

130 - L21 Create a Matrix with Transpose.mp4

04:03

131 - L22 Merging Spilled ranges.mp4

03:08

132 - L23 Simplify your formula with Let.mp4

05:58

Description

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

What You'll Learn?

EFFICIENCY: Learn to work SMARTER in Ms Excel not HARDER
DONT MEMORIZE: Microsoft Excel Formulas are like Cooking. Learn the structure to write dynamic and powerful functions from 0
PRACTICAL: Learn Formula that you will use in real life (text manipulation, counting, summing, conditions, lookups)
PRO: Get Access to tips and tricks that will stay with you forever
EXPERIENCE: FROM EX HARVARD, MCKINSEY CONSULTANT & HEAD OF ADVANCED ANALYTICS IN BIG INSTITUTIONS
ALL LEVELS: Get access to a well structured course that goes from NOOB to Expert / Advanced level with Dynamic Array Formulas that you find in Office 365
FUN: Straight to the point yet entertaining lectures
LIFETIME: Access to HOURS of material such as lectures, practice sheets, quizzes and others

Who is this for?

Course is designed to go from no knowledge about formulas to advanced levels - No matter your level, you will benefit from the different sections

Beginners will learns to write a formula for the first time

Advanced Excel users will learn the new Dynamic Array formulas in Excel 2021 & OFFICE 365

More details

Description
Why learn Microsoft Excel Formulas:Â Today, Ms Excel is becoming the tool of choice in companies (in the USA alone, more than 500,000 companies actively use Excel) to be able to perform analysis and present data in a Quick way. 90%+ of the work won't require complicated models. In addition, Excel is becoming more and more similar to tools such as Power BI, albeit with lower computing power. Learning (advanced level) Excel will help you learn the other tools quickly!

Work Smarter not Harder:Â With the advance of technology and information, jobs are becoming more and more challenging. In addition, data and analysis are becoming more and more accessible with time. The difference in productivity between a NOOBÂ in Excel and an advanced User is more than 10X. Imagine completing a task in 1 h vs 10h!
Why this course:
Formulas are the bread and butter of everything you do in Excel. You need them to perform your analysis
Unlike many courses, this course teaches you how to use formulas in real life - You will see examples you can relate to in addition to a selection of the most important formulas you will require
This course teaches you how to understand formulas and not memorize them - This will enable you to use any formula in the future
Course is designed for all levels: Whether you want to learn from scratch or deepen your understand in Excel with new Office 365 formulas, you are at the right place!
Â 4. Curriculum - Practical Hands on Excel formulas &Â functions training:
Formula structure, shortcuts, cell referencing and formula auditing tools
Conditional operators such as IF, IFs, multiple ifs, and, Or
Statistical formulas such as Sumif, averageif, random numbers
Lookup such as Vlookup, Hlookup, Xlookup, Offset, Choose and named ranges
Text manipulation functions
Date and Time functions such as Today, Now and Networkdays
Formatting in Conditional formatting with a function
New Dynamic Array formulas for Excel 2021 &Â Office 365!Â That will revolutionize how Excel works
Many tricks such as transposing data, and building dynamic graphs &reports
Â 5. What you will learn:
How to use the most common formulas in Excel in a practical way
How to save time while performing your data analysis
How to build dynamic reports
New Dynamic Array formulas
How to use formulas such as Sumproduct in unconventional ways
How to become pro at lookups with tricks such a reversed lookup, advanced lookups combining the basic index & match concepts
How to Manipulate text like a pro which is key in data cleansing
How to play with dates to extract metrics such as Turnaround Time
How to automate repetitive tasks with no VBA (and multiple other tricks)
How to troubleshoot and fix your formulas
Â 6. About me:
Harvard MBA
Extensive consulting experience with McKinsey &Â Co, having learned the ability to dissect problems and perform complex analysis in no time
11+ years as a Vice President in a bank heading analytical and strategy teams
Built the whole analytics department of a 3500+Â employee share services subsidiary
Degree in Computational Sciences among others
Well versed in Data and Artificial intelligence, having built chatbots
Passion for teaching Excel as a backbone to increasing productivity
Who this course is for:
Course is designed to go from no knowledge about formulas to advanced levels - No matter your level, you will benefit from the different sections
Beginners will learns to write a formula for the first time
Advanced Excel users will learn the new Dynamic Array formulas in Excel 2021 & OFFICE 365

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Formulas and Functions

Rami Abou Jaoude

Instructor's Courses

Who is Rami Abou Jaoude?1) First of all Rami brings with him a wealth of experience with 4 years spent in McKinsey & Co, a top tier consultant company resolving the biggest issues faced by top clients in multiple industries. This always requires an analytical mindset and an ability to be able to dissect problems like a doctor, bring data and find the best course of action2) In addition, Rami served 11 years as a Vice President in one of the most prestigious banks in the Middle East taking up roles in strategy and analytics. Rami has built the whole Analytics infrastructure for the shared service subsidiary of the bank and started the journey towards having decisions based on analytics rather than anecdotes. Rami has also touched the artificial intelligence space having built chatbots to address queries related to HR and defaulted customers3) In terms of Education, Rami has an MBA from Harvard business school and multiple degrees in Economics, Computational Sciences and Finance. This enables him to understand business and IT at the same time and to bring all parties together under a common language4) Well before the buzz in data, Rami had a drive to use data. His Moto in Life is work SMARTER not HARDER. The idea was to combine knowledge in Computer Science with the ability to understand businesses. For this, he has built hundreds of models, tools and dashboards way before the Agile term come into play!5) Rami is all about passion. A passion for adrenaline sports, normal sports and art (like playing piano). For this purpose, he wants to share his knowledge with others in all the fields that he has mastered!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.