• Post category:StudyBullet-13
  • Reading time:11 mins read


Unlocking the Power of Microsoft Excel and Google Sheets for In-Depth Data Analysis and Visualization

What you will learn

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 full potential of Microsoft Excel and Google Sheets by creating Pivot tables with slicers

Visually enchant viewers using Bar charts, Scatter Plots, Histograms in Microsoft Excel and Google Sheets.

Make great presentations using the Conditional and Table formatting options in both Microsoft Excel and Google Sheets

Description

If you are looking to up your data analysis game and streamline your work with spreadsheets, then this course is for you. Do you struggle with organizing and analyzing large data sets in Microsoft Excel or Google Sheets? Or, are you looking for ways to make your data more visually appealing and easier to understand?

In this course, you will develop advanced skills in both Microsoft Excel and Google Sheets for data analysis. You will learn how to import, clean, and manipulate data, as well as create charts, graphs, and pivot tables to effectively communicate insights.

What’s covered in this course

  • Setting up MS Excel and Google Sheets
  • All essential functions such as mathematical, textual, logical, Lookup etc. in both MS Excel and Google Sheets
  • Data visualization using popular charts and graphs in both MS Excel and Google Sheets
  • Data analysis tools such as Pivot tables, Filtering and sorting, Data formating etc.
  • Advanced topics such as Indirect functions and Macros in both MS Excel and Google Sheets
  • New topics such as dynamically importing data from PDFs and websites

Data analysis is a critical skill in today’s business world, as organizations rely on data to make informed decisions. With the rise of big data, the demand for skilled data analysts has skyrocketed, making it a valuable skill to have in the job market.


Get Instant Notification of New Courses on our Telegram channel.


Throughout the course, you will work with real-world data sets to practice your newly acquired skills. You will also receive hands-on instruction and guidance from an experienced data analyst, ensuring that you receive the best possible education.

What sets this course apart is its focus on both Microsoft Excel and Google Sheets. By learning both tools, you will be well-equipped to handle any data analysis task, no matter what software your organization uses.

Don’t let data analysis stress you out any longer. Enroll in this course now and become a confident and skilled data analyst. Start making data-driven decisions with ease!

English
language

Content

Introduction

Introduction

Excel and Google Sheet basics

Getting started with Excel
Getting started with Google Sheet
Course Resources
Worksheet Basics in Excel
Worksheet Basics in Google Sheet
Entering values and Formulas in Excel
Entering values and Formulas in Google Sheet
Data Formats in Excel
Data Formats in Google sheet
Data Handling Basics – Cut, Copy and Paste in Excel
Data Handling Basics – Cut, Copy and Paste in Google Sheet
Saving and Printing in Excel
Saving and Printing in Google Sheet

Essential Excel & Google Sheet functions

Basic Formula Operations in Excel
Basic Formula Operations in Google Sheet
Mathematical Functions in Excel – Part 1
Mathematical Functions in Excel- Part 2
Mathematical Functions in Google Sheet- Part 1
Mathematical Functions in Google Sheet – Part 2
Textual Functions in Excel – Part 1
Textual Functions in Excel – Part 2
Textual Functions in Google Sheet – Part 1
Textual Functions in Google Sheet – Part 2
Logical Functions in Excel
Logical Functions in Google Sheet
Date-Time Functions in Excel
Date-Time Functions in Google Sheet
Lookup Functions ( V Lookup, Hlookup, Index-Match )
Lookup Functions in Google Sheet

New! XLookup – only for Excel 2021 and office 365

XLookup as a replacement of Vlookup
Handling #NA and Approximates match in Xlookup
Wildcard matching in XLookup
Search modes in XLookup

Data Tools

Data Tools in Excel part – 1
Data Tools in Excel part – 2
Data Tools in Google Sheet

Formatting data and tables

Formatting data and tables in Excel
Formatting data and tables in Google Sheet

Pivot Tables

Pivot Tables in Excel
Pivot Tables in Google Sheet

Charts

Excel Charts – Categories of messages that can be conveyed
Elements of charts
The easy way of creating charts in Excel
The easy way of creating charts in Google Sheet
Bar and column charts in Excel
Bar and column charts in Google Sheet
Formatting charts in Excel part -1
Formatting charts in Excel part – 2
Formatting charts in Google sheet
Line Charts in Excel
Line Charts in Google Sheet
Area Charts in Excel
Area Charts in Google Sheet
Pie and Doughnut Charts in Excel
Pie and Doughnut Charts in Google Sheet
Why we should avoid Pie charts
Scatter plot or XY charts in Excel
Scatter plot or XY charts in Google Sheet
Frequency Distribution and Histograms in Excel
Frequency Distribution and Histograms in Google Sheet
Sparklines in Excel
Sparklines in Google Sheet

Pivot Chart

Pivot Charts in Excel
Pivot Charts in Google Sheet

Map Charts

Map charts in Excel
Map charts in Google Sheet

Special purpose charts

Stock charts in Excel
Stock charts in Google Sheet
Radar charts in Excel
Radar charts in Google Sheet
Heatmaps in Excel
Heatmaps in Google Sheet

Named Ranges

Named Ranges in Excel
Named Ranges in Google Sheet
Indirect Functions in Excel
Indirect Functions in Google Sheet

Shortcuts

Shortcuts in Excel
Shortcuts in Google Sheet

Macros

Macros in Excel
Macros in Google Sheet

New! Importing data from PDF and websites

Importing tables from PDF – Excel 2021 and office 365
Importing tables from PDF – Google Sheet
Importing data from Website – Excel 2019 and above
Importing data from Websites – Google Sheet

Advanced Excel

Advanced Excel: Analytics in Excel
Solving a transportation problem using Excel

Add-ons in Google sheet

Add-ons in Google Sheet
Sharing in Google Sheet

Congratulations & about your certificate

The final milestone!
Bonus Lecture