Reading Assignment Study how Excel functions are used in financial reporting and sales analytics. Research Assignment Research the differences between VLOOKUP and XLOOKUP and explain why XLOOKUP is preferred in modern Excel. Hands-On Practice Task A supermarket chain wants to analyze its weekly sales performance across multiple branches. You are given a dataset containing product […]
Class Activity 1
A retail company has provided a dataset containing product names, sales values, and product IDs. Students should: Calculate total sales using SUM Determine average sales using AVERAGE Count total transactions using COUNT Classify sales using IF Retrieve product prices using VLOOKUP or XLOOKUP
Assignment 2
Reading:Study industry benchmarks for social media analytics and reporting from HubSpot. Research:Compare pricing structures of leading social media marketing agencies across different regions. Hands-on Assignment: You have been hired by a startup named “NovaTech Solutions” to manage its social media presence. Develop a comprehensive client readiness portfolio including KPI selection, a monthly report template, an […]
Class Activity 2
Create a professional monthly social media report, define KPIs, prepare a client onboarding checklist, and design a three-tier pricing model for a hypothetical brand.
Assignments 2
Reading Assignment Read about the importance of data preparation in analytics and how it improves decision-making accuracy. Research Assignment Research how companies use conditional formatting and filtering in dashboards and reporting systems. Hands-on Assignment A retail chain operating across multiple cities in Nigeria wants to analyze its regional performance. The dataset includes city, product category, […]
Class Activity 2
A company has provided a cleaned dataset containing: Customer NameCityProductSales Amount Students should: Sort the dataset by sales amount Filter data for a specific city Apply conditional formatting to highlight high sales Use data validation to control product entries
Assignments 1
Reading Assignment Read about the importance of data cleaning in business intelligence and how poor data quality affects decision-making. Research Assignment Research different data cleaning techniques used in large organizations and compare them with Excel-based cleaning methods. Hands-on Assignment A financial company discovered inconsistencies in its transaction dataset, including duplicate transactions, missing amounts, and incorrectly […]
Class Activity 1
A company has provided a messy dataset containing customer names, phone numbers, sales values, and dates. Students should: Identify missing values Remove duplicates Split combined columns Use Flash Fill to extract patterns Format all data correctly