Overview
The course teaches about data analysis and business intelligence basics using Excel Power Tools. The learning outcomes include understanding data types, proper data sets, Excel tables, sorting, filtering, and logical tests. The course covers skills such as defining proper data sets, using Excel tables for dynamic data, sorting data, filtering and extracting data, and applying AND and OR logical tests. The teaching method involves video lectures with practical demonstrations. The course is intended for individuals interested in learning about data analysis and business intelligence using Microsoft Power Tools.
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