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

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX