Data Analysis Using Excel and Google Sheets : Ultimate Guide

Learn Excel and Google Sheets from beginner's to Advanced Masterclass to create amazing visualization.

4.35 (24 reviews)
Udemy
platform
English
language
Other
category
instructor
31
students
3 hours
content
Apr 2022
last update
$19.99
regular price

What you will learn

Learn from basics to Advance MS Excel and Spreadsheet

Create Amazing Dashboards in Excel.

Confidently Showcase your skills to the world and Add It in your Resume.

Create Drop down list, Check boxes, Freeze Row and Column, Concatenate strings and Extract data from strings

Learn to Format, Analyse, Visualise and Automate your Data in Excel and Spreadsheet.

Get Experienced in Data Analysis and Analytical thinking.

Create Amazing graphs and Map visualization alongside some great advanced Excel and Spreadsheet features

Finding Out insights from Data and Turning them into assets for the organization

Description

This is a Condensed course that will teach you all you need to know about how to get started and get going with Excel and Spreadsheet for Data analysis. This course is made for anyone who wants to learn the art of Data analysis and data visualization. We will begin by exploring the basic interface of Excel and Spreadsheet then move on to formatting our data and table in Spreadsheet and Excel after which we will learn how to do Data analysis in this software and use various functions, after all of this we will move on to create visualisations in these software and learn a lot more additional features. This course should prepare you to utilize Excel and Google Sheets to do your next analysis with confidence. You will be able to proudly showcase your skills to the world and add it to your resume.

==================================================

You will receive the following benefits as a result of taking this course:

  • Full free lifetime access to all the lecture videos

  • More than 2.5 hours of content with extra bonus videos.

  • All subsequent upgrades and supplementary lectures will always be free.

  • This course is made using the latest versions of Excel and Google Sheets so it will be great for any future version.

  • Confidently add your skills to your resume

  • Udemy offers an unconditional 30-day money-back guarantee. - However, I am confident that you would enjoy the course:)

Why this Course:

  • I have tried to create the video and explain it in view short and crisp manner.

  • The course structure is such a way that you go through Excel and Google Sheets and understand all concepts in the most structured way.

  • The course is segmented into various sections to help the student’s individual section in-depth and in a step-by-step manner.

  • The course has used learn by doing method which is best for software like Excel and Google Sheets.

With ZERO prior experience, you may begin your journey to becoming experienced in Excel and Google Sheets!

Looking forward to seeing you on the other side with me in your Data Analysis journey.

Content

Introduction

Introduction

Basics and Formatting Our Data

Basic and Spreadsheet and Its Interface
Basics, Referencing and Autocompleting your Data
Formatting your Data
Formatting our Tables to make them More appealing
Using Conditional Formatting
Excel

Analyzing Our Data

What's In this Section
Filter/Sorting Our Data
Data Validation(Creating Drop down List), Formulas and Functions
Combining Data And Extracting Data from cells
Using IF Function
Vlookup Function and Data Cleaning
Excel : Using Checkbox, Slicer and All other features

Visualizing Our Data

Quick Recap
Pivot Tables
Creating Different Chart and Map Visualizations
Creating Pivot table and Charts in Excel
Creating Dashboard In Excel

Additional Features

Using Macros
Congratulations

Screenshots

Data Analysis Using Excel and Google Sheets : Ultimate Guide - Screenshot_01Data Analysis Using Excel and Google Sheets : Ultimate Guide - Screenshot_02Data Analysis Using Excel and Google Sheets : Ultimate Guide - Screenshot_03Data Analysis Using Excel and Google Sheets : Ultimate Guide - Screenshot_04

Reviews

Steven
July 3, 2022
The class is well-structured, very comprehensive, organized and easy to understand. By far, this is one of the best data analysis class that I have come across. Highly recommend!
Saad
May 15, 2022
I started as a beginner. But after completing these, I'm very confident about my skills. I highly recommend the course to all. Thank you so much for this course
Raito
April 19, 2022
the course was well explained each and every concept was very simplified and explained in a detailed and concise manner
Rakesh
April 18, 2022
The course help me understand how to use spreadsheet when I had no knowledge of it at the same time all the lectures were clear and concise which helped me get started with spreadsheets real quick
Riffat
April 17, 2022
I tried various online resources to learn excel but couldn't find any structure anywhere which led me to search for a course on udemy and found this course. It's a great course for anyone who wants to learn about MS Excel and Google Spreadsheet
Jake
April 17, 2022
Course structure was really amazing helped me understand everything about excel and Google sheet in very detail
Talat
April 17, 2022
This course is actually the course to go for If you want to learn Excel or spreadsheet. every concept is well explained in a condensed manner

Charts

Price

Data Analysis Using Excel and Google Sheets : Ultimate Guide - Price chart

Rating

Data Analysis Using Excel and Google Sheets : Ultimate Guide - Ratings chart

Enrollment distribution

Data Analysis Using Excel and Google Sheets : Ultimate Guide - Distribution chart
4625104
udemy ID
4/3/2022
course created date
4/20/2022
course indexed date
Bot
course submited by