Data Analytics Bootcamp : Excel, Google Sheets And Tableau

Data Analytics masterclass, Start with using Excel and Google Sheets then create awesome dashboards in Tableau.

4.62 (29 reviews)
6 hours
Apr 2022
last update
regular price

What you will learn

Confidently Showcase your Data Analytics skills to the world and Add it in your Resume.

Create Interactive Dashboards in Tableau and Excel.

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

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

Get Experienced in Data Analysis and Analytical thinking.

Learn from basics to Advance MS Excel and Spreadsheet

Learn to clean, prepare and Visualize data.

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


**Amazing updates and class projects coming soon**

This is a Condensed course that will teach you all you need to know about how to get started and get going with data analysis we will start with learning how to use Excel and spreadsheet then use Tableau 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 learning how to use Excel and Spreadsheet then we will learn the various steps for doing data analysis which are data cleaning, preparation and finally data visualization after which we will use all of these learned skills to create a real interaction dashboard for our projects in Tableau. This course should prepare you to utilize Excel, Spreadsheet and Tableau 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 6 hours of content.

  • This course is made using the latest versions of Excel, Spreadsheet and Tableau 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 Tableau 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 Spreadsheet, Excel and Tableau.

With ZERO prior experience, you may begin your journey to become experienced at Excel, Google Sheets and Tableau!

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


Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Screenshot_01Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Screenshot_02Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Screenshot_03Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Screenshot_04




SpreadSheet and Excel Part -1

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

Spreadsheet and Excel Part- 2

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 And Additional features

Quick Recap
Pivot Tables
Creating Different Chart and Map Visualizations
Creating Pivot table and Charts in Excel
Creating Dashboard In Excel
Using Macros
Congratulations for Completing Part 1

Tableau Part 1: Data Analysis and Data cleaning and Preparation Steps

What is data Analysis and how to gather information?
Dashboards and Its Types
Blueprinting your Dashboards
Let's Download Tableau
Let's load our data in Tableau
Combining Data in Tableau
Let's Clean our Data
Preparation of our data

Data Visualisation

Let's Create our First Visualisation
Let's Create our first map visual
Advanced Tableau features For creating Territories in Tableau
Using The Marks Card
Let's Create Some filters

Final Project

Let's Complete First few Tasks( Data cleaning, Preparation and some charts)
Let's Create our Hollow pie Chart
Let's Create the Highlight Table
Let's Create Map with Drilldowns


Dashboard Interface
Let's start Creating dashboard
Using various Filters to make our dashboards more Interactive and Dynamic
Additional Content and How to download and Share your Dashboards


July 3, 2022
An amazing class! The teacher explained everything about data analytics in great details with lots of examples. It is very easy to follow and I learnt a lot from this class.
June 6, 2022
Awesome class with a lot of practical examples. Recommended to anyone who wants to gain understanding on Excel, Google Sheets and Tableau!
June 5, 2022
As promised, this course has a lot of information on Excel, Google Sheets and Tableau. Learning a lot with each lecture.
June 5, 2022
This is a great course to learn and develop your Excel skills and then take it one step further with Google Sheets and Tableau
April 23, 2022
The course was the thing I needed to learn the skills I wanted in my data Analytics journey. Looking forward to the future courses
April 23, 2022
I have very less idea about data Analytics , this course helped me get experienced in it also learned several software in detailed manner In a very concise way
April 20, 2022
The course is for anyone who want to get experienced in the domain of data visualisation. Really enjoyed the course and would recommend anyone who want to learn these softwares
April 19, 2022
The course is perfect for anyone who want to get experienced in these software. really loved the course
April 19, 2022
Started from someone who has no idea about these software to now I am really confident in my skills and can create good dashboard and projects. Thank you :)
April 19, 2022
Course structure was really good being a beginner it helped a lot in understanding everything in a very simplified manner
April 19, 2022
The course was very nice for someone who wants to learn data visualization. I loved each and every lecture and found them really informative



Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Price chart


Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Ratings chart

Enrollment distribution

Data Analytics Bootcamp : Excel, Google Sheets And Tableau - Distribution chart
udemy ID
course created date
course indexed date
course submited by