ASSIGNMENT CONTENT Employee NameDepartmentSalaryAlice JohnsonHR120000Bob SmithIT95000Chidi OkoroSales110000Damilola AdeFinance87000Esther GeorgeHR102000Farouk BelloIT98000Grace LiuSales115000In this assignment, you will practice protecting and sharing Excel data.Enter the...
Ensuring Data Accuracy Using Data Types in Power Query
Assignment Title:Ensuring Data Accuracy Using Data Types in Power QueryAssignment Content:You are provided with a dataset (e.g., Sales_Data.csv) containing columns...
Clean and Combine Sales Data Using Power Query
Assignment Content:DItemQuantityPriceTotalTransaction IDcake224TXN_1961373coffee4ERROR12TXN_4977031Error41ERRORTXN_4271903Cookie2510TXN_7034554saladERRORUnknown4TXN_3160411UNKNOWN5420TXN_2602893smoothie339TXN_4433211UNKNOWN4416TXN_6699534Sandwich5315Using the provided dataClean the data by:Removing blank rowsRenaming columnsEnsuring that all data type headers are correct Step 4:...
Build Your First Excel Dashboard
Data Visualization Step 1: Practice DatasetOpen a new sheet and type this table:MonthSalesExpensesProfitJanuary500000300000200000February600000350000250000March550000320000230000April700000400000300000May650000370000280000June720000410000310000👉 This dataset will help you practice charts, formatting,...
Practical Task: Conditional Formatting
ASSIGNMENT CONTENTStudent NameScoreAlice Johnson85Bob Smith45Chidi Okoro72Damilola Ade90Esther George60Farouk Bello30Grace Liu95👉 This dataset will help you practice highlighting trends, data bars,...
Advanced Data Analysis Tools
ASSIGNMENT CONTENT ProductPriceQuantityProfit MarginTotal SalesLaptop35000050.251750000Phone25000080.202000000Chair45000120.15540000Desk8000070.18560000Shoes15000200.30300000Bag12000150.25180000Watch30000100.22300000👉 This dataset will help you practice What-If Analysis, Goal Seek, Scenario Manager, Data Tables, and Forecasting. In...
Practical Task: Pivot Tables and Charts
ASSIGNMENT CONTENTEmployee NameDepartmentRegionSalesAlice JohnsonHRNorth120000Bob SmithITSouth95000Chidi OkoroSalesEast110000Damilola AdeFinanceWest87000Esther GeorgeHRNorth102000Farouk BelloITSouth98000Grace LiuSalesEast115000Henry OjoFinanceWest92000👉 This dataset will help you practice Pivot Tables and...
Practical Task: Working with Excel Tables
ASSIGNMENT CONTENTOpen a new sheet and type this table:ProductCategoryPriceQuantityLaptopElectronics3500005PhoneElectronics2500008ChairFurniture4500012DeskFurniture800007ShoesFashion1500020BagFashion1200015WatchFashion3000010👉 This dataset will help you practice tables, structured references, sorting, filtering,...
Practical Task: Date and Time Functions
ASSIGNMENT CONTENTIn this assignment, you will practice date and time functions in Excel.Enter today’s date using TODAY()Enter current date and...
Practical Task: Using IF, AND & OR Functions
ASSIGNMENT CONTENTIn this assignment, you will practice using IF, AND, and OR functions in Excel.Create a table with columns: Name,...