Advanced Excel Masterclass along with Excel Dashboards

Advanced Excel Masterclass along with Excel Dashboards

What you’ll learn

  • Learn about basic formatting in excel.
  • Learn about sorting and filtering functions in excel.
  • Learn about UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE functions in excel.
  • Learn how to find outliers and missing values in Excel.
  • Learn how to find standard deviation and percentiles in data using Excel.
  • Learn about IF, IF ERROR, COUNTIF, SUMIF and AVERAGEIF functions in excel.
  • Learn about using Color Bars and Color scales in excel.
  • Learn applying VLOOKUP and HLOOKUP functions and merge datasets using them in excel.
  • Learn how to merge datasets using Index and match.
  • Learn making Pivot Tables and Pivot charts in excel.
  • Learn making interactive dashboards in excel.
  • Learn about What-if analysis in excel.
  • Learn how to perform linear regression in excel.
  • Learn about Macros and VBA.
  • Learn basic and advanced Debugging
  • Learn about User-Defined Functions.
  • Learn the working with VBA Forms.
Deal Score0
External links may contain affiliate links, meaning we get a commission if you decide to make a purchase