Overview

Learn to perform Data Analytics using excel in this course. This free course has been designed to prepare you for meaningful opportunities in the future pertinent to Data Analytics. The course starts with the Introduction to Data Analytics and explains the phases of the Data Analytics project. It will further guide you to use different functions of excel with regard to Data Analytics like Sort and Filter, Lookup functions, conditional formatting, Pivot tables, and more. The final phase of this course will cover Data Visualization, in which you will be able to learn how to represent data using pictorial charts and tables. Using various examples, the instructor explains Data Visualization in the course. Attend a quiz after completing the course that lets you test your knowledge and claim your course certificate once you pass it. Launch your Data Analytics career by extending your knowledge with the best Data Analytics Courses. Learn the foundations and advanced concepts to secure a job in the industry.

Syllabus

Data Cleaning

Moving further in this Data Analytics using Excel course, you will learn about Data Cleaning, the first phase of Data Analytics. The instructor will explain the process with the help of examples to make it easier for you to grasp. Also, know why Data Cleaning is important for the business.

Introduction to Data Analytics

This module will introduce you to Data Analytics, which is nowadays everywhere. It is becoming increasingly important to analyze the data in different industries, which is why it is great for you to learn Data Analytics and how we can do it using excel. This module will only introduce you to the importance of learning Data Analytics.

Phases of Data Analytics Project

This module will be focused on the journey of processing raw data into meaningful data. This process is divided into various phases of Data Analytics: Data cleaning, Data Analysis, and Data Visualization. Understand each phase in detail and learn how you can take critical decisions using data in a business.

Data Validation

Let's just move into Data Validation in this module. It is a very interesting tool that lets you control certain values in the spreadsheet. Here you will learn how to manage data using Data Validation.

Pivot Tables

Pivot tables are used to sort, count, total or reorganize the data stored in a table. Pivot tables are one of the most powerful features in Excel for Data Analytics. In this module, understand what Pivot tables are used for and how they are used by looking into examples shared by the instructor.

Functions - Data Analytics using Excel

This module will have an emphasis on the functions of Excel, which are predefined formulas in the spreadsheet for a specific purpose. Here, you will learn the types of functions you can use in Excel for Data Analytics to save your time and effort.

Sort and filter

Discover the Sort and Filter functions in excel in this module with the help of examples. Sort and Filter options make our job a little easier when we analyze the data for some specific purpose.

Lookup Functions

This module revolves around Lookup functions. Examples are being used in the module in order to make it more understandable and practical. Understand how VLOOKUP and HLOOKUP functions work for finding specific information in a spreadsheet.

Conditional formatting

The module will let you acquire knowledge about Conditional formatting. Conditional formatting allows you to format cells based on certain conditions. Know how you can use conditional formatting in the cells to fulfilling the main purpose of data analysis. The instructor has explained it quite clearly with the help of examples to make you understand how it works.

Data Visualization using excel

After the data analysis is done, then comes Data Visualization into the picture. Data Visualization is the representation of data using pictorial charts. Here, in this module, you will understand how you can represent your data for better clarity and decision-making purposes.

Data Analytics using ChatGPT with Excel

This module uses the Car-MPG dataset as a case study to introduce data analysis using ChatGPT and Excel. Regression modelling, univariate analysis, summary statistics, and data preparation will all be practiced by students.