Channel Avatar

ExcelPowerTips @UCUKsQ6QelGoYFuinqr0q6-A@youtube.com

556 subscribers - no pronouns :c

My channel will help you learn many varied Excel Power tips

Shorts
SQL COUNT(star) vs COUNT(column name) - Count Non-Null column values #sqltips #sqlforbeginners Excel VALUE Function Convert Text Number to Number #excel #exceltutorial #excelformulasandfunctions SQL Declaring & using Variables Part 4 within IF...BEGIN...END Block #sqltips #sql #sqlforbeginners Excel 365 TRANSPOSE Function vs Any Excel Version Transpose #excel #exceltips #exceltutorial SQL How to Declare use Variables Part 3 (Table Variables INSERT SELECT) #sql #sqltips #sqltutorials SQL How to Declare & use Variables Part 2 (Table Variables) #sql #sqltips #tables #update #sqlserver SQL How to Declare and use Variables in SQL Server Part 1 #sqltips #sqlforbeginners #sql SQL SUM Aggregation with CASE Statement Multiple Columns #sql #sqltips #aggregation #case Excel Hide Chart Data and Stop Chart also Automatically Hiding #excel #exceltips #exceltutorial SQL WHERE Clause (CORRELATED SUBQUERIES vs SUBQUERY JOINS) P4 #sqltips #sqlforbeginners #subquery SQL WHERE Clause Filtering (using SUBQUERIES) Part 3 #sql #sqltips #sqlforbeginners #subquery SQL WHERE Clause Filtering Part 2 #sql #sqltips #sqlforbeginners #sqlserver SQL WHERE Clause Filtering Part 1 #sqltips #sql #sqlforbeginners #sqlserver SQL Basic Aggregation Functions COUNT, SUM, MIN, MAX, and AVG #sqltips #sqlforbeginners #sql Excel VLOOKUP Exact Match vs Approximate Match Examples #excel #exceltips #exceltutorial #vlookup SQL CASE Statement vs SQL IIF Statement Give Same Result #sql #sqltips #sqlforbeginners #sqlserver SQL STRING_SPLIT Function with CROSS APPLY Extract Email Address #sqltips #sql #stringfunctions Excel Perform Fast XLOOKUP Search using its Defaults #excel #exceltips #microsoftoffice #xlookup SQL IIF Function with DATEDIFF calculate Shipping Status Days Difference #sqltips #sqlforbeginners SQL INSERT INTO Full and Partial Record Inserts #sqltips #sqlserver #sqlforbeginners #sqlinterview SQL Three Methods Create Table Copy with or without its Data #sql #sqlserver #sqltips #sqltutorial Excel How to Easily move Rows and Columns in your Data #exceltips #excel #excelforbeginners SQL Refresh SSMS Cache to remove those Red Wavy Lines #ssms #sqlserver #sqlforbeginners #sqltips SQL ISNULL Function replace NULLS with a value #sql #sqlforbeginners #sqltips #sqlserver SQL Order By Month Number not Month Name Trick #sql #sqlforbeginners #sqltips Easy Excel VLOOKUP Wildcard Searching (All Versions) #excel #exceltips #excelforbeginners SQL Analyse Data using SQL COUNT vs COUNT DISTINCT #sql #sqltips #sqlforbeginners #sqlserver SQL Find Duplicate Records with Same Values Across All Columns #sqltips #sqlforbeginners #duplicate Excel Correctly Calculate Time Difference (Same vs Next Day) #excel #exceltips #excelforbeginners Fast SQL SELECT ORDER BY using Field Positions #sql #sqltips #sqlforbeginners Excel VSTACK Header with Fast SORT #excel #excel365 #exceltips #microsoftoffice #exceltricks One Click Clear All Excel Slicers Button - Click Link for Full Lesson #excel #exceltips #slicers Fast Excel 365 UNIQUE Function using Defaults #excel #exceltips #microsoftoffice #exceltricks Excel FILTER Function which Ignores Blanks using a Dropdown List #excelforbeginners #excel365 #excel Excel SUMPRODUCT formula in less than 1 minute #exceltips #excel #exceltricks #sumproduct