Microsoft Excel Tip for DATA ANALYSTS in 2022

One way to ensure DATA CONSISTENCY in Data Entry

Put simply, data analysis is described as the process of collecting, modeling, and analyzing data to extract information that supports decision-making or call it data-driven decision-making. The data used as a basis for analysis is captured or entered by either the data analyst or data personnel somewhere in some data room. The accuracy of the result of the analysis is determined by the accuracy of the source data (like they say Garbage In, Garbage Out). However, one of the issues that I have encountered in my line of work that can easily distort accurate reporting is the failure by data workers to enter or capture repeating data items in a consistent manner. Thankfully Microsoft Excel 2016 provides users the automatic drop-down list feature to control consistency in data entry. To Initiate an AUTOMATIC DROP-DOWN List is simple but uncommon trick using the keyboard short-cut ALT + ↓ (the ALT key + Down Arrow key). Let me show you how this works in the short video in the link below using an example from the health sector

INITIATING AUTOMATIC DROP-DOWN LIST IN EXCEL VIDEO TUTORIAL