A project focuses on generating insights for HR generalist based on attendance sheet of past three months.

XLS to XLSX is an online tool that converts documents created in Microsoft Excel or other spreadsheet processing formats into XLSX (Microsoft Excel Spreadsheet XML) files.

💡 You can easily extract photos 📸 from an Excel 📊 cell using this Python script. But wait, there's more! These photos can also be saved with names created by given cells. To discover how to make the most of this powerful tool, follow the steps below or watch the video guide. Happy extracting! ✨🔍

A web application developed for the data collection team at the University of the Free State. The app, named MARS combines weekly attendance register files into a single bulk/aggregated attendance file.

Analysis of the rate of turnover of IBM Employees from last year.

Practicing the basics of Pandas, including sorting, grouping, plotting and more.

Health Analysis Report based on money spent on health and its impact on life expectancy.

A case study on Weather Analysis during World War 2 by Machine Learning.

Fraud Check Analysis by Random Forest.

Excel has now become an important part of our professional as well as personal life because it can use easily and it provides many functions in one single tool. Here is another assignment based on very important, very interesting and very attractive feature i.e. Pivot Table and Pivot Charts.

Data Analysis of iPhone Purchase Records by KNN.

Company Data Analysis by Random Forest.

Travel Data Analysis by ARIMA.

Emulates the loading of customer orders in a hamburger restaurant system. Saving the data of the orders and customers in an Excel file and saving the names of the employees who entered and left the system in a text file.

Excel is an important tool in the field of Data Science. It provides us with so many formulas and makes our time consuming and complicated calculations easy. So, here are some questions based on formulas like Sum, Sumif, Sumifs, Count, Countif, Countifs.

Prediction model for Delivery Time by Simple Linear Regression

Predict salary of new employee by Polynomial Regression.

Data Analysis of Bank by Logistic Regression.

Data Analysis of burned area of forest by Support Vector Machine.

Gain valuable insights into retail sales with the "Walmart Retail Performance Dashboard" in Microsoft Excel. This user- friendly tool facilitates an in-depth analysis of key sales metrics, providing a comprehensive view of Walmart's performance. Make data-driven decisions for informed and strategic business outcomes.