Microsoft Excel And Google Sheets For Data Analysis

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


Homepage