Data-Literate

Learn Pivot Table Calculated Fields

SUMIFS vs COUNTIFS

Excel // Slicers & Timeline's Pt 1

Power Query / Remove Duplicates

SQL View

SQL Having Clause

Excel SUMIFS() Formula

Slicers for multiple tables

Stop Static SQL! Pass cell values as SQL parameters!

Automate Business Tasks

Excel // Filter multiple visuals with Slicers Pt. 2

Learn SQL Programming in 30 Minutes - A Beginner's Guide

What's a Data Model?

Power BI - "What if" Parameter

Excel - VBA Refresh All

Excel =INDEX( ) with Example

Pivot Table Quick Tip Remove Blanks

SQL - Import Flat File

Dynamic SQL Queries in Excel

SQL DATEDIFF( ) Function

Excel / Lock & Unlock Protect Cell's w VBA

SQL - Query Multiple Databases

Build out Excel Dashboard from Scratch!

Analyze Data in Excel

Excel - Slicers and Timeline

Using Excel to Streamline Your SQL Scripts

SQL Basics: SELECT, INSERT, UPDATE & DELETE

SQL Case Statement

PowerQuery - Merge Table's

SQL CTE Example

Excel - Data Analysis Business Example