Data Analytics with Excel

Quarter Academic Credit
2

Discover the many ways data analysis helps organizations optimize their performance, reduce costs and identify more efficient ways of conducting business. Data analytics––the science of dissecting raw data to make conclusions ––is used to discover, interpret and communicate meaningful patterns in data. This entry-level course is designed for professionals looking to add or enhance their data analytics skillset to further their career prospects. Through in-depth lectures, hands-on practice and industry case studies, you’ll learn foundational skills that introduce significant data analysis applications in the healthcare, public services, consumer goods and energy industries. Gain relevant experience to understand the value of the analytics workspace and the importance of data-driven decision-making for any organization.  

Learning Outcomes 

  • Evaluate industry trends  
  • Assess market demand for data analytics, data engineering and data science 
  • Explore data in Excel using relevant tools to process and analyze data 
  • Apply learning to a real-world industry case example 

Skills You’ll Gain 

  • Excel functions related to data preparation, sorting and filtering 
  • Pivot tables, XLOOKUP and VLOOKUP  
  • Business and finance data models  
  • Case-specific analysis, including forecasting analysis, variance analysis and trend analysis 
Course Code
508435