Interactive Excel Exercises

Basic Math and Percentages

Sales Tax Calculation: Calculate the final price including tax for a list of products.
Discounted Prices: Determine the sale price after applying various discount percentages.
Profit Margin Calculation: Calculate profit margins for products based on cost and selling price.
Expense Allocation: Split expenses among multiple categories and calculate percentage allocation.
Budgeting: Create a budget and calculate variances between actual and planned expenses.

Monthly Expenses: Sum the monthly expenses for a household budget.
Project Costs: Calculate total project costs by summing different expense categories.
Total Sales: Sum daily sales figures to find the total sales for the month.
Charity Donations: Sum donations from various sources to get the total amount raised.
Mileage Tracking: Calculate the total miles driven over a period.

Inventory Count: Count the number of different items in stock using COUNT, COUNTA, and COUNTBLANK.
Attendance Tracker: Use COUNTIF to track attendance based on predefined criteria.
Survey Responses: Count the number of responses for each option in a survey using COUNTIFS.
Customer Feedback: Count the number of positive and negative feedback entries.
Employee Absences: Track and count the number of absences for employees over a year.

Grades Calculation: Calculate the average grade for a group of students.
Performance Metrics: Find the average performance score across multiple departments.
Daily Temperatures: Calculate the average temperature over a week.
Sales Performance: Determine the average sales per day over a month.
Budget Variance: Calculate the average variance between budgeted and actual expenses.

Best and Worst Sales Performance: Identify the best and worst sales figures from a dataset.
Temperature Records: Determine the highest and lowest temperatures over a month.
Employee Salaries: Find the minimum and maximum salaries in a company.
Product Ratings: Identify the highest and lowest ratings for products.
Stock Prices: Determine the highest and lowest stock prices over a year.

Pass/Fail Determination: Use the IF function to determine if students passed or failed based on their scores.
Tax Brackets: Apply nested IFs to assign tax rates based on income levels.
Bonus Eligibility: Determine employee eligibility for bonuses based on performance and tenure.
Shipping Costs: Calculate shipping costs based on order amount and shipping destination.
Grade Assignment: Assign letter grades to students based on their numerical scores.

Employee Lookup: Use XLOOKUP to find employee details based on their ID.
Product Price Finder: Implement HLOOKUP to find prices of products in a horizontal list.
Departmental Budget: Use VLOOKUP to allocate budgets to departments based on a predefined table.
Customer Orders: Use INDEX and MATCH to retrieve order details based on customer ID.
Inventory Reorder: Lookup and identify items that need reordering based on stock levels.

Conditional Sums: Calculate total sales for a specific region using SUMIF.
Conditional Counts: Count the number of orders above a certain value using COUNTIF.
Expense Tracking: Use SUMIFS to sum expenses based on multiple criteria like category and month.
Sales Commission: Calculate commission based on sales thresholds using SUMIF.
Customer Segmentation: Count customers in different segments using COUNTIFS.

Sales Analysis: Create a pivot table to analyze sales data by region and product category.
Customer Segmentation: Use pivot tables to segment customers based on purchase behavior.
Employee Performance: Analyze performance metrics by department and job role using pivot tables.
Expense Breakdown: Create a pivot table to break down expenses by category and month.
Market Trends: Analyze market trends over time using pivot tables and charts.

Sales Trend Analysis: Create a line chart to visualize monthly sales trends.

Data Cleansing: Use TRIM, LEFT, RIGHT, MID, and CONCAT to clean and merge data.
Email Extraction: Extract domain names from a list of email addresses using FIND and MID.
Name Formatting: Convert names to proper case, using PROPER, UPPER, and LOWER functions.
Address Parsing: Split addresses into separate columns for street, city, and zip code.
Text Search: Use SEARCH and FIND to locate specific text within a dataset.

Loan Amortization: Calculate monthly payments and interest using PMT and IPMT functions.
Investment Growth: Project future investment values using the FV function.
Depreciation Calculation: Use SLN and DB functions to calculate asset depreciation.
Net Present Value: Calculate the net present value of an investment using the NPV function.
Internal Rate of Return: Determine the internal rate of return for a series of cash flows using the IRR function.
Bond Pricing: Calculate the price of a bond using the PV function.

Project Timeline: Calculate project start and end dates using WORKDAY and NETWORKDAYS.
Age Calculation: Determine ages from birthdates using the DATEDIF function.
Meeting Scheduler: Calculate the number of working days between two dates.
Date Formatting: Convert dates to different formats using TEXT and DATE functions.
Time Tracking: Calculate total hours worked based on start and end times.

Array Formulas: Use array formulas to perform complex calculations over a range of cells.
Dynamic Ranges: Use OFFSET and INDIRECT to create dynamic ranges for charts and tables.
Multi-Criteria Lookups: Use INDEX and MATCH with multiple criteria to perform complex lookups.
Matrix Calculations: Perform matrix multiplications using MMULT and other advanced functions.