SUMIFS vs COUNTIFS

Build out Excel Dashboard from Scratch!

Excel SUMIFS() Formula

Analyze Data in Excel #Dataliterate #excel

Automate Business Tasks #dataliterate

Power Query / Remove Duplicates

SUMIFS vs COUNTIFS

Excel / Lock & Unlock Protect Cell's w VBA

Power BI - "What if" Parameter

Excel // Filter multiple visuals with Slicers Pt. 2 #shorts

Excel // Slicers & Timeline's Pt 1 #excel #learnexcel #dataliterate #shorts

SQL Having Clause #shorts #dataliterate #excel #sql #learnsql

SQL DATEDIFF( ) Function #dataliterate

PowerQuery - Merge Table's #dataliterate

Excel - VBA Refresh All

Slicers for multiple tables

Excel - Slicers and Timeline

SQL CTE Example

Excel - Data Analysis Business Example

Excel =INDEX( ) with Example

Excel - Best Practice Designing Tables

SQL - Import Flat File

SQL - Query Multiple Databases

SQL Case Statement

SQL View