Spreadsheet: Excel & Google Sheet (Beginner to Intermediate)

Learn how to create, manipulate, visualize and analyze data with Microsoft Excel & Google Sheet

4.50 (36 reviews)
Udemy
platform
English
language
Microsoft
category
Spreadsheet: Excel & Google Sheet (Beginner to Intermediate)
1,792
students
7.5 hours
content
Feb 2022
last update
$44.99
regular price

What you will learn

Spreadsheet 101-Understand the concepts of Spreadsheet software

How to create, organize, analyze, manipulate data with Microsoft Excel and Google sheet

How to use Autosum, Subtotal, IF function to perform simple and complex calculations

How to sort and filter data with Microsoft Excel and Google sheet

How to use chart and pivot table to analysis data

How To Automate Repetitive Task With Macro

And more

Why take this course?

Do you want to master the Ins and Out of top 2 spreadsheet software in use today, Microsoft Excel and Google Sheet?

Spreadsheet is one of the top office productive tools used in the business world today, it's also one of the top in-demand skills for jobs, professional or career excellence.

This course is designed to take you from a beginner to an intermediate level when it comes to spreadsheet software.

You will learn the environment of the top 2 spreadsheet software that is often used in the workspace today, with insights and skills on these top 2 spreadsheet software you will be able to deal with every other spreadsheet tool that comes your way.

This course is divided into 2 major modules:

1. Microsoft Excel Spreadsheet

In this module, you will learn how to organize, manipulate and analyze data with Microsoft Excel. The lectures in the Microsoft excel module are created with Microsoft Excel 2013 version, but with any version of Microsoft office from 2010 to the latest version will be able to follow through this course.

2. Google Sheet

In this Module, you will learn how to organize, manipulate and analyze data with Google Sheet.

More Concepts and guides delivered in this course:

  • Understanding the environment of Microsoft Excel and Google Sheet

  • How to create, save, and open a workbook.

  • Data entry, cell formatting, working with multiple worksheets and

  • Discover how to format dates and numbers.

  • Discover the essentials of using formulas and functions.

  • How to rename, insert, move, and reference an Excel worksheet.

  • Discover how to create charts and graphs

  • Learn practical methods to sort and filter your data

  • Learn visualize data with chart and SmartArt

  • Discover how to analyze data with a Pivot table and pivot chart

  • And more

Screenshots

Spreadsheet: Excel & Google Sheet (Beginner to Intermediate) - Screenshot_01Spreadsheet: Excel & Google Sheet (Beginner to Intermediate) - Screenshot_02Spreadsheet: Excel & Google Sheet (Beginner to Intermediate) - Screenshot_03Spreadsheet: Excel & Google Sheet (Beginner to Intermediate) - Screenshot_04

Reviews

Yousra
January 18, 2024
It was a good match for me. It is informative and helpful. It was easy to follow the instructions; however, some were repetitive. There was a technical issue in the first part of this course. The videos after video # 11 don't work properly even after I open my account on my laptop. The part of the Google sheet was working very well. Overall, it is perfect and helpful. Thank you!

Charts

Price

Spreadsheet: Excel & Google Sheet (Beginner to Intermediate) - Price chart

Rating

Spreadsheet: Excel & Google Sheet (Beginner to Intermediate) - Ratings chart

Enrollment distribution

Spreadsheet: Excel & Google Sheet (Beginner to Intermediate) - Distribution chart

Related Topics

4435874
udemy ID
12/8/2021
course created date
12/10/2021
course indexed date
Bot
course submited by