Using Remove Duplicates to Find the Latest or Earliest Record in Excel

A woman working on a computer.

Using Remove Duplicates to Find the Latest or Earliest Record in Excel You will learn how to leverage multi sort options to retrieve the appropriate record for your data analysis and/or reporting. Learn How To Use Remove Duplicates The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills,…

Read More

Auditing Data and Spreadsheets

A woman working on a computer.

Auditing Data and Spreadsheets One keyway to ensure privacy and protection is to audit the files. Look at the file a way another might. Let’s uncover ways to audit a file quickly by using the built in formula auditing tools for the purpose of privacy and protection. Learn How To Audit Data and Spreadsheets The…

Read More

Visualizing data sets in Outlook

A woman working on a computer.

Visualizing data sets in Outlook People are constantly trying to build calendars. Knowing that Outlook reads data in the form of calendars has allowed me for decades to look over time in a calendar view – way before the project ever started. Sure we have systems in place for projects once they are real –…

Read More

Building Data Sets inside of Outlook

A woman working on a computer.

Building data sets inside of Outlook Having my data skills means that I look at every program I use as a data machine. That means I am going to put data in it; and take data out of it. Outlook is a key form of communication, and it is a ton of data that you…

Read More

Mapping Data into Other Software Tools

A woman working on a computer.

Mapping Data into Other Software Tools Data everywhere – and plenty of places to put it. A key to data survival and well data quality is being able to leverage data for other places without rekeying it in. Learn core concepts for what to look for when importing and exporting data from and to other…

Read More

Designing relationships for databases

A woman working on a computer.

Designing relationships for databases Learn how to design relationships for a basic database. If you can understand how to create relational designs, then you will understand how to read great designs and deal with bad designs. Learn How To Design Relations for Databases The Data Skills Survival Kit Series If you’re a data analyst, you’ve…

Read More

Creating a SharePoint back end from a database

A woman working on a computer.

Creating a SharePoint back end from a database Learn how to get the most of a relational design and a live database backend at the same time. Not everything you will do will get a large budget, but this technique can be amazing for your process and your project. Learn How To Create a Sharepoint…

Read More

Creating tables and joins to recode data

A woman working on a computer.

Creating tables and joins to recode data There are times where you can’t write a enough replace commands, or conditional statements to clean bad data. Learn how to create a control table to clean data in mass. Learn How To Recode Data The Data Skills Survival Kit Series If you’re a data analyst, you’ve no…

Read More

Merging data and building basic calculations into a data set

A woman working on a computer.

Merging data and building basic calculations into a data set Learn how to merge data from different sources and build basic calculations into a dataset. See how to analyze data by creating a comprehensive dataset for further analysis. Learn How To Merge and Calculate Data The Data Skills Survival Kit Series If you’re a data…

Read More

Adding data leveraging cross joins

A woman working on a computer.

Adding data leveraging cross joins We use joins in data to effectively report on data, but have you ever considered using them to create data? When faced with adding repetitive data for a project that applies across the board learn to leverage cross joins. Learn How To Leverage Cross Joins The Data Skills Survival Kit…

Read More