Excel

Explore in-depth topics and key concepts in Data Analytics — e.g., Introduction to Data Hygiene, Filtering and Sorting, Understanding Data Quality Issues.

Topics Covered

Introduction to Data Hygiene

Key Concepts: definition of data hygiene, importance of clean data, common data errors

Read Now →

Filtering and Sorting

Key Concepts: Understanding filters, Applying filters based on criteria, Sorting data alphabetically and numerically

Read Now →

Understanding Data Quality Issues

Key Concepts: types of data quality issues, impact of incorrect data entry, examples of inconsistent data formats

Read Now →

Data Hygiene

Key Concepts: importance of data hygiene, common data issues, techniques for cleaning data

Read Now →

Database Functions

Key Concepts: AVERAGEIF, SUMIFS, COUNTIFS, understanding criteria

Read Now →

Chart Types

Key Concepts: Valid chart types, Creating different chart types, Choosing the right chart for data

Read Now →