Sub-Total: $0.00
Posted Notes
Most of our content is published through our website—primarily within posts where it naturally fits the topic. If you’re looking for a full archive to explore, here it is
Defining nomenclature for fields to reduce data issues
Learn how to define a clear nomenclature to make your data instantly more readable and...
Using Remove Duplicates to Find the Latest or Earliest Record in Excel
Learn how to find the latest or earliest customer orders using Remove Duplicates in Excel....
Building Data Sets inside of Outlook
Learn how to build reusable data sets directly inside Outlook. Outlook is often seen as...
Adding data leveraging cross joins
Learn how to quickly assign full schedules to all employees using SQL cross joins. In...
Using date functions to create follow up data
Learn how to save hours on recurring tasks using date functions in Excel. In this...
Leveraging the Advanced Editor in Power Query to share cleaning routines
Learn how to share and reuse your data cleaning routines with the Advanced Editor in...
Using Remove Duplicates to Create Data Sets
Learn how to turn messy order data into clean, usable datasets with Power Query's Remove...
Adding data leveraging cross joins
Learn how to quickly assign full schedules to all employees using SQL cross joins. In...
Using Joins and Update Queries to Create Markers in the Data
Learn how to keep orders organized and accurate with joins and update queries. In this...
Building Date Tables in Power BI/Power Query
Learn how to streamline time-based analysis by building a reusable date table in Power Query....