Microsoft Excel Guide


In a data-driven world, you need an understanding of data manipulation, data summarization, and automation through Excel. This step-by-step guide equips you with beginner to expert level techniques on how to tell a story with your data and provides you with practice scenarios to solidify what you have learned.  Listed below are more details of what the guide includes.

  • Utilize data manipulation, data cleansing, and data pre-processing formulas.
  • Utilize data summarization and data visualization techniques including vlookups, pivot tables, and pivot charts.
  • Utilize automation and data aggregation through macros.