Data, Proper Data Sets, Excel Tables, Logical Tests, More
Offered By: ExcelIsFun via YouTube
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 AnalysisUniversity 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