Introduction to Excel and how we use the tool for Real World Data Analytics

In the real world, #Excel is a Microsoft Office tool that is used for basic data entry, analysis and modelling of the data. On basic data entry, Excel is used to input data in cells. The types of data that can be input include texts, numbers, dates, special characters, and text strings that include numeric, special characters and numbers. Input of data can happen inside the cell or at the formular bar. We can also change font type and font size, bold (CTRL+B) and italicized (CTRL+I), highlight and fill values in the cells, change the background color, align the cells, wrap texts and merge cells. On data analysis, we have data cleaning and data validation. Data cleaning is used to check if the data is consistent throughout the worksheet. Here, we check on any missing values, duplicates, blanks, and inconsistent data types. Where there are missing values or blanks, we replace (CTRL+H) the values using pseudo blanks i.e. Null, Unknown, Not Provided, N/A. Please note that on each category,