Excel validation exercise, business analytics
This assignment provides you an opportunity to utilize the functions and tools of Excel to solve a basic analytics scenario: data validation. The purpose of this assignment is to use Excel to quickly identify the possible errors within the database, and not to visually examine all 6,000+ database records. The HR tab in Hospital.xlsx file contains the employee records downloaded from the Human Resource database of a […]