Spreadsheet: Excel & Google Sheet (Beginner to Intermediate)

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

Spreadsheet: Excel & Google Sheet (Beginner to Intermediate)
Spreadsheet: Excel & Google Sheet (Beginner to Intermediate)

Spreadsheet: Excel & Google Sheet (Beginner to Intermediate) udemy course

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

What you'll learn:

Microsoft Excel and Google Sheets for Data Analysis

  • Knowledge of all the essential Microsoft Excel and Google Sheets functions
  • Master Microsoft Excel and Google Sheets’ most popular lookup functions such as Vlookup, Hlookup, Index, and Match
  • Become proficient in Microsoft Excel and Google Sheets data tools like Sorting, Filtering, Data validations, and Data importing
  • Harness the  potential of Microsoft Excel and Google Sheets by creating Pivot tables with slicers
  • Visually enchant viewers using Bar charts, Scatter Plots, and Histograms in Microsoft Excel and Google Sheets.
  • Make great presentations using the Conditional and Table formatting options in both Microsoft Excel and Google Sheets

Requirements:

  • You will need a PC with a working internet connection

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:

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

Who this course is for:

Course Details:

  • 7.5 hours on-demand video
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Spreadsheet: Excel & Google Sheet (Beginner to Intermediate) udemy free download

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

Demo Link: https://www.udemy.com/course/spreadsheet-excel-google-sheet/