Spreadsheet for Data Analytics (Google Sheet & Ms Excel)

Home » Courses » Spreadsheet for Data Analytics (Google Sheet & Ms Excel)

Course Details

Current Status

Not Enrolled

Price

₦150,000

Get Started

Descriptions:

In this course, you will learn how to use Microsoft Excel and Google Sheets, two popular spreadsheet applications that can help you work with data in various ways. You will learn how to perform calculations, input and edit data, use conditional formatting, create charts and graphs, use formulas and functions, import and export data, work with macros, scripts, and add-ons, and protect and share your workbooks with others.

Course Objectives:

Performing simple and complex calculations using formulas and functions
Sorting, filtering, and formatting data
Using conditional formatting, data validation, and data protection
Creating charts, graphs, pivot tables, and dashboards
Importing and exporting data from different sources and formats
Working with macros, scripts, and add-ons
Collaborating and sharing data with others

Delivery: Online – Weekdays & Weekends

Duration: 1 Month

Pre-requisite:

Course Content

Expand All

Introduction to Data Analytics and Spreadsheets 4 Topics

Expand

Module Content

0% Complete 0/4 Steps

Explain what data analytics is and why it is important

Differentiate between different types of data and data sources

Understand the basics of Microsoft Excel and Google Sheets interface and terminology

Perform simple calculations and use fill handle

Data Manipulation and Analysis 4 Topics

Expand

Module Content

0% Complete 0/4 Steps

Input, edit, and format data

Use sorting and filtering functions

Use conditional formatting and data validation functions

Use basic formulas and functions, such as SUM, AVERAGE, COUNT, IF, VLOOKUP, etc.

Data Visualization and Presentation 4 Topics

Expand

Module Content

0% Complete 0/4 Steps

Create and customize charts and graphs

Create and manipulate pivot tables and slicers

Create and format dashboards and reports

Use sparklines, icons, and images

Data Integration and Automation 4 Topics

Expand

Module Content

0% Complete 0/4 Steps

Import and export data from different sources and formats, such as CSV, XML, JSON, etc.

Use macros, scripts, and add-ons to automate tasks and enhance functionality

Use data protection and sharing features

Collaborate and communicate data with others

Installment payment is available.

Can’t pay at once, we’ve got you covered, choose part payment during the sign up process so you can pay on installments

Refer a friend and get cashback

Get up to N20,000 cashback in your account when your friend registers. No hassle, you and your friend confirms to us and you get paid to your account.

Share with friends