Data for Analysis with Microsoft Excel

Overview

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.