YoVDO

Data, Proper Data Sets, Excel Tables, Logical Tests, More

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Business Intelligence Courses Data Analysis Courses

Course Description

Overview

Learn essential Excel data analysis skills in this comprehensive 35-minute video tutorial. Explore data types, proper data sets, Excel tables, sorting, filtering, and logical tests. Gain a solid understanding of the difference between data and information, and discover how to effectively use Excel's table feature for dynamic data management. Master sorting and filtering techniques to extract valuable insights from your datasets. Dive into logical tests, including AND and OR operations, to enhance your data analysis capabilities. Download accompanying start and finished files, along with PDF notes, to practice and reinforce your learning.

Syllabus

) Introduction.
) What is Excel? What about the Data in the Cells?.
) What is Data, Raw Data?.
) Understanding the Difference Between Data & Information..
) Define Proper Data Set..
) Tables are not Charts.
) Use Excel Tables For Dynamic Data. Learn about Excel Table Feature..
) Data Types in Proper Data Sets in Various Tools.
) How to Sort Data..
) Filtering & Extracting Data..
) Understand & Use AND Logical Tests and OR Logical Tests.
) Summary.


Taught by

ExcelIsFun

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