Project ContentFull NameDepartmentSalaryBonusPerformance ScoreAlice JohnsonHR1062821296088Bob SmithHR1069491401465Chidi OkoroIT90218515779Damilola AdeHR1140771197687Esther GeorgeSales93104687073Farouk BelloHR100690624065Grace LiuHR802777221100Henry OjoFinance634461268569Isabel OkaforFinance1050531417766Jide LawalHR68186748572Kelvin ObiIT990001000082Linda JamesSales85000720075Musa IbrahimFinance1200001500090Nkechi EzeIT1150001200085Olamide YusufSales97000810078Peter ColeHR102000920081Queen...
Forecasting Sales in Excel
ASSIGNMENT CONTENTEnter the following data in Excel:Month | SalesJan | 2000000Feb | 2100000Mar | 2200000Task 2: Create ForecastSelect the dataGo...
Practical Task: Scenario Analysis
ASSIGNMENT CONTENT Create a table in Excel with the following:Product: Shoes Price: 15000 Quantity: 20Calculate Total Sales manually.Then create two scenarios:Best...
Practical Task: Advanced Data Analysis
ASSIGNMENT CONTENTProductPriceQuantityTotal SalesLaptop350005 Phone2500008 Chair4500012 Desk800007 Shoes1500020 Bag1200015 Watch3000010 In this assignment, you will practice advanced data analysis tools in Excel.Enter the dataset into ExcelCreate a Total...
Practical Task: Macro Button Automation
ASSIGNMENT CONTENTNameAgeScoresBunmi Amoloja6754Rike Aree5667Sola Sholagbade4587Fatai Jubril7878In this assignment, you will practice assigning macros to buttons.Enter the dataset into ExcelRecord a...
Practical Task: Excel Automation
ASSIGNMENT CONTENTEmployee NameDepartmentSalesAlice JohnsonHR120000Bob SmithIT95000Chidi OkoroSales110000Damilola AdeFinance87000Esther GeorgeHR102000Farouk BelloIT98000Grace LiuSales115000In this assignment, you will practice automating tasks using macros.Enter the...
Practical Task: Data Cleaning
ASSIGNMENT CONTENTEmployee NameEmail AddressDepartmentSalaryAlice [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] this assignment, you will practice cleaning data in...
Excel in Business
ASSIGNMENT CONTENTProductSales (₦)Expenses (₦)Rice15000090000Beans12000070000Oil180000110000Bread9000050000Sugar11000060000In this assignment, you will apply Excel in a business scenario.Create a small table with:ProductSalesExpensesCalculate total sales...
Business Decision Analysis
ASSIGNMENT CONTENTIn this assignment, you will apply Excel for business decision-making.Enter the dataset into ExcelCreate a Pivot Table to find...
Practical Task: Data Protection and Collaboration
ASSIGNMENT CONTENT Employee NameDepartmentSalaryAlice JohnsonHR120000Bob SmithIT95000Chidi OkoroSales110000Damilola AdeFinance87000Esther GeorgeHR102000Farouk BelloIT98000Grace LiuSales115000In this assignment, you will practice protecting and sharing Excel data.Enter the...