Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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
Showing Class Central Sort
-
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.