Spreadsheet: Excel & Google Sheet (Beginner to Intermediate)

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

What you'll 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 lots more

Requirements
Basic Computer operation skill
A Computer to practices what you will be learning
Determination and commitment to learning new skills
Ability to follow instructions and guide

Description
Develop your Data Analysis Skills, learn how to create, manipulate, visualize and analyze data with Microsoft Excel & Google SheetSpreadsheet 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 SpreadsheetIn 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 SheetIn 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 SheetHow to create, save, and open a workbook.Data entry, cell formatting, working with multiple worksheets andDiscover 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 graphsLearn practical methods to sort and filter your dataLearn visualize data with chart and SmartArtDiscover how to analyze data with a Pivot table and pivot chartAnd more

Who this course is for:
Graduate and undergraduate who wants to learn Spreadsheet skills and increase employment opportunity in a computer age, Professionals who want to learn how to work with spreadsheet software, Business owners or entrepreneurs who want to learn data analysis with spreadsheet, Anyone that want to learn spreadsheet skills