Basics of Starting with Excel

Introduction to Sets

Append In Python

Write the Equation to Calculate an Average in one line with Operator

Using of Assignments operator and Shorthand

Working with Large Data Sources

Analysing Box Plots

Building Box Plots in Tableau

Project Brief Retail Sector Forecasts

Section Intro

Executive Report is Ready

Creating a Storyline

Trendlines for Power-Insights

Quality Assurance For Table Calculations

Adding a Second Layer Moving Average

1. SELECT within SELECT (Subqueries)

2. Relating Tables Together Using JOINs

3. Joins Continued INNER & OUTER Joins

4. Career Advice

5. Correlated Subqueries with EXISTS & NOT EXIST operators

6. SELF JOIN

7. CROSS JOIN, NATURAL JOIN and the USING CLAUSE

8. EQUIJOIN and NON-EQUIJOINs

9. CASE Statements

Naming & Referencing Cells

Dive into Excel Course