Introduction to Business Analysis Using Spreadsheets: Basics

Overview

Class Central Tips

In this 1-hour 30-mins long project-based course, you will learn the responsibilities of a Business Analyst such as Learn the basic concepts of data analysis and descriptive statistics. Learn how to manipulate, analyze, and visualize data in Google Sheets using functions, aggregation functions, and logical aggregation functions. and present data using different types of charts. This course works best for learners who wish to learn about Business Analysis and wish to learn about the role of a Business Analyst. Note: This project works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Syllabus

Project Overview

By the end of this project, you will be able to identify the basics of the spreadsheet software and apply the functions to do mathematical operations using aggregation and logical functions such as SUM and COUNTIF if to learn how to deal and manipulate data. you will be able to create tables and functions to summarize and analyze your data sets. Finally, you will apply to manage your presentation by learning data virtualization using charts. For this project, we will be using free online software called Google sheets. If you do not have a Gmail account navigate to https://www.google.com/gmail/ to set up your account.