Home Office Productivity Microsoft Excel for the Data Analyst

Microsoft Excel for the Data Analyst

352
0
Microsoft Excel for the Data Analyst
Microsoft Online Course Highlights
  • 4-6 months
  • 32 – 64 hours of effort
  • Learn for FREE, Ugpradable
  • Self-Paced
  • Taught by: Dany Hoter, Wayne Winston, Liberty J. Munson, Jonathan Sanito, Matthew Minton
  • View Course Syllabus

Online Course Details:

Excel is one of the most widely used solutions for analyzing data. Explore real-world examples and learn how to use the powerful tools built into Excel to analyze more data, with improved visualizations and more sophisticated business logic.

This series of three self-paced courses, hosted by leading experts, teaches you how to use Excel to organize, summarize, analyze, model, and visualize data for use in numerous data analytics and data science applications.

Microsoft’s Microsoft Excel for the Data Analyst XSeries

Introduction to Data Analysis using Excel
  • 2–4 hours per week, for 4 weeks
  • Learn the basics of Excel, one of the most popular data analysis tools, to help visualize and gain insights from your data.
Analyzing and Visualizing Data with Excel
  • 2–4 hours per week, for 6 weeks
  • Develop your skills with Excel, one of the common tools that data scientists depend on to gather, transform, analyze, and visualize data.
Essential Statistics for Data Analysis using Excel
  • 2–4 hours per week, for 6 weeks
  • Gain a solid understanding of statistics and basic probability, using Excel, and build on your data analysis and data science foundation.

What you will learn:

  • Organize and summarize data using Excel tables, pivot tables, and dashboards
  • Analyze data using statistics and probability functions and visualizations built into Excel
  • Gather, transform, model, and visualize data from multiples sources using the Excel data model, DAX, integration with Power BI, and other tools

Take This Online Course