Dec 1: Winter Bootcamp Application Deadline. Apply Now In Just 10 Mins

Data Analysis

Using Spreadsheets

Details

PREREQUISITES

None

LENGTH

3 Hours

LOCATION

Live Online

STUDENT PROFILE

All levels interested in expanding their ability to leverage data they have available in the workplace for business decisions

Course Description

This 3 hour live online course reinforces your company’s data-driven culture by teaching non-technical employees how to review and organize data with spreadsheet applications. They’ll become more comfortable with data analysis, without needing to involve your analytics team. Here’s how: we’ll practice cleaning, exploring, analyzing, and visualizing data using spreadsheet tools like Google Sheets and Excel. Plus, we’ll support further learning in business intelligence and analysis. We’ll end our course by exploring practical applications of our data in real-world scenarios.

Course Outcomes

Upon completion of the course, attendees should be able to:

Use spreadsheets to clean, explore, analyze, and aggregate data

Work with a variety of functions to prepare and manage reports

Build charts to organize statistics and visualize data for presentation

Uncover valuable insights to support better business decisions

Training Content

CHAPTER 1:

Introduction to Google Sheets

Discuss what can be accomplished using spreadsheet applications

Open, create, and save a spreadsheet

Determine types of data points

CHAPTER 2:

Working with Functions

Build out basic numerical, date, and string functions

Write functions that create summary statistics

Use absolute and relative cell references.

CHAPTER 3:

Working with Conditional Functions

Build out conditional functions using if else statements across multiple cells

Create conditional functions such as if statements, and/or statements, and nested if statements

Create functions that work across multiple values

CHAPTER 4:

Vlookups and Index Matching

Perform a vlookup to find corresponding values

Use index matching to find values from corresponding columns

Learn advanced vlookup capabilities

CHAPTER 5:

Sorting and Filtering

Sort and filter data according to specific questions

Basic sorting and filtering 

Advanced sorting and filtering

CHAPTER 6:

Pivot Tables

Build a pivot table that summarizes data according to categories and statistics

Learn advanced pivot table functionalities

CHAPTER 7:

Building Charts in Excel

Build charts that summarize data according to categories and statistics

Create charts using Google Sheets

Introduction to formatting charts

CHAPTER 8:

Data Validation and Formatting

Find and remove unnecessary duplications

Restrict value ranges

Highlight, format, and create borders/tables for best presentation of data

More Courses for Your Team

Details

PREREQUISITES

None

LENGTH

3 Hours

LOCATION

Live Online

STUDENT PROFILE

All levels interested in expanding their ability to leverage data they have available in the workplace for business decisions