Microsoft Excel And Google Sheets For Data Analysis

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

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

Requirements

You will need a PC with a working internet connection

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 courseSetting up MS Excel and Google SheetsAll essential functions such as mathematical, textual, logical, Lookup etc. in both MS Excel and Google SheetsData visualization using popular charts and graphs in both MS Excel and Google SheetsData 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 SheetsNew topics such as dynamically importing data from PDFs and websitesData 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.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!

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Excel and Google Sheet basics

Lecture 2 Getting started with Excel

Lecture 3 Getting started with Google Sheet

Lecture 4 Course Resources

Lecture 5 Worksheet Basics in Excel

Lecture 6 Worksheet Basics in Google Sheet

Lecture 7 Entering values and Formulas in Excel

Lecture 8 Entering values and Formulas in Google Sheet

Lecture 9 Data Formats in Excel

Lecture 10 Data Formats in Google sheet

Lecture 11 Data Handling Basics - Cut, Copy and Paste in Excel

Lecture 12 Data Handling Basics - Cut, Copy and Paste in Google Sheet

Lecture 13 Saving and Printing in Excel

Lecture 14 Saving and Printing in Google Sheet

Section 3: Essential Excel & Google Sheet functions

Lecture 15 Basic Formula Operations in Excel

Lecture 16 Basic Formula Operations in Google Sheet

Lecture 17 Mathematical Functions in Excel - Part 1

Lecture 18 Mathematical Functions in Excel- Part 2

Lecture 19 Mathematical Functions in Google Sheet- Part 1

Lecture 20 Mathematical Functions in Google Sheet - Part 2

Lecture 21 Textual Functions in Excel - Part 1

Lecture 22 Textual Functions in Excel - Part 2

Lecture 23 Textual Functions in Google Sheet - Part 1

Lecture 24 Textual Functions in Google Sheet - Part 2

Lecture 25 Logical Functions in Excel

Lecture 26 Logical Functions in Google Sheet

Lecture 27 Date-Time Functions in Excel

Lecture 28 Date-Time Functions in Google Sheet

Lecture 29 Lookup Functions ( V Lookup, Hlookup, Index-Match )

Lecture 30 Lookup Functions in Google Sheet

Section 4: New! XLookup - only for Excel 2021 and office 365

Lecture 31 XLookup as a replacement of Vlookup

Lecture 32 Handling #NA and Approximates match in Xlookup

Lecture 33 Wildcard matching in XLookup

Lecture 34 Search modes in XLookup

Section 5: Data Tools

Lecture 35 Data Tools in Excel part - 1

Lecture 36 Data Tools in Excel part - 2

Lecture 37 Data Tools in Google Sheet

Section 6: Formatting data and tables

Lecture 38 Formatting data and tables in Excel

Lecture 39 Formatting data and tables in Google Sheet

Section 7: Pivot Tables

Lecture 40 Pivot Tables in Excel

Lecture 41 Pivot Tables in Google Sheet

Section 8: Charts

Lecture 42 Excel Charts - Categories of messages that can be conveyed

Lecture 43 Elements of charts

Lecture 44 The easy way of creating charts in Excel

Lecture 45 The easy way of creating charts in Google Sheet

Lecture 46 Bar and column charts in Excel

Lecture 47 Bar and column charts in Google Sheet

Lecture 48 Formatting charts in Excel part -1

Lecture 49 Formatting charts in Excel part - 2

Lecture 50 Formatting charts in Google sheet

Lecture 51 Line Charts in Excel

Lecture 52 Line Charts in Google Sheet

Lecture 53 Area Charts in Excel

Lecture 54 Area Charts in Google Sheet

Lecture 55 Pie and Doughnut Charts in Excel

Lecture 56 Pie and Doughnut Charts in Google Sheet

Lecture 57 Why we should avoid Pie charts

Lecture 58 Scatter plot or XY charts in Excel

Lecture 59 Scatter plot or XY charts in Google Sheet

Lecture 60 Frequency Distribution and Histograms in Excel

Lecture 61 Frequency Distribution and Histograms in Google Sheet

Lecture 62 Sparklines in Excel

Lecture 63 Sparklines in Google Sheet

Section 9: Pivot Chart

Lecture 64 Pivot Charts in Excel

Lecture 65 Pivot Charts in Google Sheet

Section 10: Map Charts

Lecture 66 Map charts in Excel

Lecture 67 Map charts in Google Sheet

Section 11: Special purpose charts

Lecture 68 Stock charts in Excel

Lecture 69 Stock charts in Google Sheet

Lecture 70 Radar charts in Excel

Lecture 71 Radar charts in Google Sheet

Lecture 72 Heatmaps in Excel

Lecture 73 Heatmaps in Google Sheet

Section 12: Named Ranges

Lecture 74 Named Ranges in Excel

Lecture 75 Named Ranges in Google Sheet

Lecture 76 Indirect Functions in Excel

Lecture 77 Indirect Functions in Google Sheet

Section 13: Shortcuts

Lecture 78 Shortcuts in Excel

Lecture 79 Shortcuts in Google Sheet

Section 14: Macros

Lecture 80 Macros in Excel

Lecture 81 Macros in Google Sheet

Section 15: New! Importing data from PDF and websites

Lecture 82 Importing tables from PDF - Excel 2021 and office 365

Lecture 83 Importing tables from PDF - Google Sheet

Lecture 84 Importing data from Website - Excel 2019 and above

Lecture 85 Importing data from Websites - Google Sheet

Section 16: Advanced Excel

Lecture 86 Advanced Excel: Analytics in Excel

Lecture 87 Solving a transportation problem using Excel

Section 17: Add-ons in Google sheet

Lecture 88 Add-ons in Google Sheet

Lecture 89 Sharing in Google Sheet

Section 18: Congratulations & about your certificate

Lecture 90 The final milestone!

Lecture 91 Bonus Lecture

Anyone curious to master Microsoft excel and Google Sheets from beginner to advanced in short span of time