1. MORE TIME!
  2. Master the top 50 formulas in just 50 minutes!
  3. Understand the essence of these formulas, without memorizing them!
  4. See how each of these formulas is used with real examples!
  5. After this class you will be able to:
  7. Actually SMILE when you open a spreadsheet :-)
  8. Brag to your friends about how you can use Excel formulas and Excel functions confidently!
  9. If you're like me, you use Microsoft Excel on a daily basis for important tasks, text processing, or calculations. Whether it's for business or personal related projects, everyone wants to be able to use these formulas freely and easily.
  11. If you're ready to gain full control of Excel Formulas TODAY, take the “Excel -Master the Top 50 Formulas in 50 minutes from Scratch" course right now and master the following formulas:
  13. Text Formulas:
  14. Concatenate
  15. Find
  16. Left
  17. Len
  18. Lower
  19. Mid
  20. Proper
  21. Rept
  22. Substitute
  23. Trim
  24. Upper
  25. Value
  26. Mathematical Formulas:
  27. Average
  28. Int
  29. Mod
  30. Rand
  31. Round
  32. Sum
  33. Date and Time Formulas:
  34. Day
  35. Hour
  36. Minute
  37. Month
  38. Networkdays
  39. Now
  40. Second
  41. Today
  42. Weekday
  43. Year
  44. Logic Formulas:
  45. And
  46. Countblank
  47. Countif
  48. If
  49. Large
  50. Max
  51. Min
  52. Not
  53. Or
  54. Small
  55. Sumif
  56. Vlookup
  57. Financial Formulas:
  58. Fv
  59. Npv
  60. Pmt
  61. Ppmt
  62. Informational Formulas:
  63. Column
  64. Isblank
  65. Iserror
  66. Isnumber
  67. Istext
  68. Row
  69. More Excel topics are being added monthly! We have partnered up with MyExcelOnline to bring more Excel content to you and make you better in Excel!
  71. POWER BI
  73. We will learn how to create your own report dashboard from your source data! You will learn:
  75. Installing Power BI Desktop for FREE
  76. Getting Data from a data source (Power Query)
  77. Cleaning Data (Power Query)
  78. Creating a Data Model (Power Pivot)
  79. Create cool visualizations and charts (Power View)
  80. Publishing it to your own dashboard online (Power BI Website)
  81. And you will use live source data in creating your own Power BI Dashboard!
  83. CHARTS
  85. In this section we explain the various Charts that are in Excel, like the Bar, Column, Line, Pie, XY Scatter, Bubble, Stock, Smart Art and Sparklines!
  87. ADVANCED - CHARTS
  89. We take it up a notch in this section and showcase the new Charts that were introduced in Excel 2016, like:
  91. • Box and Whisker
  92. • Histogram Chart
  93. • Pareto Chart
  94. • Sunburst Chart
  95. • Treemap Chart
  96. • Waterfall Chart
  98. We also show you how you can combine various Charts in a graph:
  100. • Area Chart: Highlight Chart Sections
  101. • Add an Interactive Vertical Column in Your Excel Line Chart
  102. • Add Marker Options in a Chart
  103. • Overlap Graphs
  104. • Add Trendlines to Charts
  106. EXCEL POWER QUERY / GET & TRANSFORM
  108. We take it up a notch to clean your dirty data and showcase the things you can do in Excel Power Query!
  110. Introduction
  111. - Excel Power Query Editor Ribbon
  113. Transform Data
  114. - Trim in Excel Power Query
  115. - Format Dates and Values in Excel Power Query
  116. - Parsing URLs in Excel Power Query
  117. - Split Text Fields in Excel Power Query
  118. - Group By in Excel Power Query
  119. - Unpivoting Columns
  120. - Pivoting Columns
  121. - Split Columns into Other Columns
  122. - Filtering Rows and adding a "Year" Column
  123. - Sorting Data
  124. - Transform vs Add Columns
  126. From Folder
  127. - Import From Folder in Excel Power Query
  128. - Doing Auto Cleanup in Excel Power Query
  129. - Extract Data from Forms in Excel Power Query
  131. From Workbook
  132. - Extract Multiple Criteria in Excel Power Query
  133. - Extract Multiple Worksheets in Excel Power Query
  135. Joins
  136. - Intro to Joins
  137. - Merging
  138. - Full Outer Join
  139. - Right Anti Join
  141. Tips and Tricks
  143. - Convert Reports into Pivot Tables
  144. - Modulo