Posts Tagged ‘Paid Subscription Required’
Using Remove Duplicates to Find the Latest or Earliest Record in Excel
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 MoreAuditing Data and Spreadsheets
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 MoreVisualizing data sets in Outlook
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 MoreBuilding Data Sets inside of Outlook
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 MoreMapping Data into Other Software Tools
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 MoreDesigning relationships for databases
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 MoreCreating a SharePoint back end from a database
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 MoreCreating tables and joins to recode data
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 MoreMerging data and building basic calculations into a data set
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 MoreAdding data leveraging cross joins
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