Excel Logical Functions & SQL Subqueries

Statistics- Descriptive Stats

Quick Introduction to Descriptive Statistics

Descriptive statistics are used to summarize and describe data. Mean, median, mode are examples of descriptive statistics.

Excel- True or False

Logical Functions

Functions that return either TRUE or FALSE are called logical functions. These are pretty commonly used in excel.

Basic summary Statistics in Excel

SQL- Introduction to Subqueries

SQL Subqueries

A query inside a query is called a sub query. Usually entry level data analysts don't write subqueries at work but some jobs might expect you to have a basic understanding of sub queries- so it does not hurt to learn. For advanced analysts, its definitely a useful skill to have.

Data in Action

Practice Exercises