YoVDO

Data Analytics Using Excel

Offered By: Great Learning via YouTube

Tags

Data Analysis Courses Data Visualization Courses Microsoft Excel Courses Data Cleaning Courses Data Analytics Courses Pivot Tables Courses Data Validation Courses

Course Description

Overview

Dive into a comprehensive 83-minute tutorial on data analytics using Excel. Learn the three main phases of data analytics projects: data cleaning, analysis, and visualization. Master essential Excel functions, including lookup functions, conditional formatting, and data validation. Explore the power of pivot tables for data analysis and discover effective techniques for data visualization in Excel. Gain practical skills to kickstart your data analytics journey and enhance your career prospects in this in-demand field.

Syllabus

Introduction.
Agenda.
Phases of Data Analytics Project.
Data Cleaning.
Functions.
Lookup Functions.
Conditional Formatting.
Data Validation.
Pivot Tables.
Data Visualisation using Excel.
Summary.


Taught by

Great Learning

Related Courses

Data Wrangling with MongoDB
MongoDB via Udacity Getting and Cleaning Data
Johns Hopkins University via Coursera 软件包在流行病学研究中的应用 Using software apps in epidemiological research
Peking University via Coursera Creating an Analytical Dataset
Udacity Implementing ETL with SQL Server Integration Services
Microsoft via edX