Open a blank Excel workbook and enter the headings Name, Department and Score in cells A1, B1 and C1. Enter...
Identifying the Excel Interface
Open Microsoft Excel and create a blank workbook. Enter your full name in cell B4 and type “Excel Interface Mastery”...
Opening and Confirming Microsoft Excel
Open Microsoft Excel on your computer, create a blank workbook, type your full name in cell A1 and type “Microsoft...
Employee Performance Dashboard and Pivot Chart Project
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...