Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Data Analytics Using Excel

Great Learning via YouTube

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

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Data Analytics Using Excel

  • Profile image for  Jahanavi Malhotra
    Jahanavi Malhotra
    This class taught me how to use Excel as a tool for facilitating data analysis and to visually present data in a manner that is easily intelligible for not only myself but other users as well. From a data analysis perspective, I learned how to have Excel quickly make many calculations that would a take lot longer if done manually. One of the most interesting, and practical, capabilities I learned was how to define what criteria I want to count out of a raw data list that is not already broken into different categories for me. In regards to presenting raw data visually, I learned how to create both tree chart and map chart.I expect the skill of creating visual representations of data to be particularly helpful.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.