• Post category:StudyBullet-4
  • Reading time:5 mins read




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

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

 

And more

Description

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:


Get Instant Notification of New Courses on our Telegram channel.


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

Note: The full content of this course is over 7 hours long, due to Udemy policy of a maximum of 2 hours for a free course we couldn’t upload all the course content, you can enrol for the course before it is switched to a premium course which will then have the full course lessons uploaded, the good news is that if you enrol to this course right now you will have access to the full course as already enrolled students once is updated.

 

English
language

Content

Introduction

Getting Started
What Is Spreadsheet Software?

Microsoft Excel Spreadsheet

Intro To Microsoft Excel
Overview Of Microsoft Excel
Data entering and Organizing With Excel
How to Modifying Rows, Column and Cell
Text Formatting In Excel
How Access An Existing And New Workbook
Different Ways To Save Workbook In Excel
Working With Multiple Worksheet

Google Sheet

Intro to Google sheet
What Next Now