Coursera Plus Annual is 40% Off — Ends July 13.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Data for Analysis with Microsoft Excel

Microsoft via Coursera

Go to class Write review

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis.  Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel. 

Syllabus

  • Excel fundamentals
    • This module introduces essential Excel elements and techniques begininning with the creation and formatting of worksheets. It explores the Excel features that are useful when viewing large data blocks and explains how to create accurate calculations.
  • Formulas and functions
    • This module introduces formulas and functions in Excel. It explores how these are important to data analysis and how these are used in business scenarios.
  • Preparing data for analysis using functions
    • The module introduces common functions that help prepare Excel data for analysis in tools such as Power BI.
  • Final project and assessment: Preparing data for analysis with Microsoft Excel
    • In this module, you will be assessed on the key skills covered in the Course.

Taught by

Microsoft

Tags

Reviews

4.7 rating at Coursera based on 88 ratings

Start your review of Data for Analysis with Microsoft Excel

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.