Deep Excel

Excel is an integral tool in data analytics and visualization. Dive into everything Excel, from cell input to creating pivot tables.



Deep Excel

To truly analyze and create visual data, a deep understanding of Excel is a must. This course will expand your excel toolbox and give you the skills you need to successfully visualize data.

Topics Include:

  • Cell formats, formulas, functions, sorting
  • Data transformation and normalization
  • Comparing data, looking up data in related tables
  • Filtering, sorting, basic pivot tables, exporting and sharing data



Dennis McGrath is an engineer with more than 30 years of experience using data to make better decisions. He received both his Bachelor of Science and Master of Arts degrees from Rutgers University. His career spans multiple sectors including government/military, healthcare, finance, and homeland security. As an engineer for the Naval Air Warfare Center and later with Lockheed Martin, he worked with Navy aircraft and ship-based combat systems. As a researcher at Dartmouth College and Norwich University, he was principle investigator for multiple projects investigating technology for infrastructure protection and disaster response. More recently, he has been a consultant to several New England hospitals using Six Sigma methods to spearhead data-driven process improvements.

Price: $499.00