All Articles
Browse the latest published guides, choose a topic, or search for a specific problem. New here? Follow a practical reading path on Start Here.
Search the articles
Browse by topic
Latest articles
-
SQL Data Types: Choose Meaning Before Converting Values
SQL data types: a practical guide with review steps, an example, common questions and clear limits for client work.
-
SQL IN Statement: Compare a List and Understand NULL Limits
SQL IN statement: a practical guide with review steps, an example, common questions and clear limits for client work.
-
Correlated and Non-Correlated SQL Subqueries: Follow the Dependency
Correlated and non-correlated SQL subqueries: a practical guide with review steps, an example, common questions and clear limits for client work.
-
SQL Window Functions vs. CTEs: Different Jobs in a Query
SQL window functions vs CTEs: a practical guide with review steps, an example, common questions and clear limits for client work.
-
SQL JOIN Queries: Match Keys Without Multiplying Results Unexpectedly
SQL JOIN queries: a practical guide with review steps, an example, common questions and clear limits for client work.
-
SQL HAVING vs. WHERE: Filter Groups and Rows at the Right Stage
SQL HAVING vs WHERE: a practical guide with review steps, an example, common questions and clear limits for client work.
-
Excel AVERAGE Function: Check Blanks, Zeroes and the Denominator
Excel AVERAGE function: a practical guide with review steps, an example, common questions and clear limits for client work.
-
Excel Date Functions: Keep Real Dates Separate from Display Text
Excel date functions: a practical guide with review steps, an example, common questions and clear limits for client work.
-
Excel FIND vs. SEARCH: Case, Wildcards and Missing Text
Excel FIND vs SEARCH: a practical guide with review steps, an example, common questions and clear limits for client work.
-
TEXT Function in Excel: Format a Display Without Losing the Number
TEXT function in Excel: a practical guide with review steps, an example, common questions and clear limits for client work.
-
Excel MATCH Function: Return a Position, Not the Matched Value
Excel MATCH function: a practical guide with review steps, an example, common questions and clear limits for client work.
-
VLOOKUP Excel Formula: Use Exact Matches and Check the Lookup Key
VLOOKUP Excel formula: a practical guide with review steps, an example, common questions and clear limits for client work.