Calculate Total Marks, Percentage, Average and Result using Excel formulas.

Calculate Basic Salary, HRA, DA, Gross Salary and Net Salary.

Calculate total sales using SUM and basic arithmetic formulas.

Calculate total, average, highest and lowest monthly expenses.

Calculate total units, total sales and average sales.

Use IF function to assign grades according to percentage.

Create a performance-based employee bonus calculation.

Calculate attendance percentage and eligibility status.

Calculate salesperson commission based on sales amount.

Create an electricity bill using slab-based calculations.

Find total sales for each salesperson.

Calculate sales according to city, product and month.

Count employees according to department.

Count employees based on multiple attendance conditions.

Calculate average salary according to department.

Find average sales using multiple criteria.

Create an eligibility checker using AND and OR.

Use the IFS function to create an automated grading system.

Handle lookup errors using IFERROR.

Highlight high sales, low sales, pending fees and failed students.

Find employee name, department and salary using Employee ID.

Find product price and product details using Product ID.

Create a horizontal lookup exercise.

Find employee information using INDEX and MATCH.

Extract employee codes, city codes and department codes.

Combine first name and last name into a complete name.

Combine multiple fields into a single text string.

Clean unnecessary spaces and unwanted characters from data.

Find characters and words inside text data.

Separate combined customer data into multiple columns.

Convert raw sales data into an Excel Table.

Sort and filter records according to multiple requirements.

Extract records according to multiple criteria.

Find and remove duplicate customer records.

Create dropdown lists for City, Department, Product and Payment Mode.

Create a Salesperson-wise sales analysis using Pivot Table.

Analyze Category, Product and Sales Amount.

Create a chart from Pivot Table data.

Create Slicers for City, Category, Salesperson and Payment Mode.

Use an Excel Timeline to filter sales data by month, quarter and date range.

Create an automated employee salary calculation system.

Track Present, Absent, Leave and Attendance Percentage.

Create Total, Percentage, Grade and Result automatically.

Track Total Fee, Paid Fee and Pending Fee.

Calculate Opening Stock, Purchase, Sales and Closing Stock.

Calculate EMI, Total Interest and Total Payment.

Create a monthly MIS report with Sales, Units, City and Category.

Analyze expenses by category, month and payment mode.

Create KPI cards, charts, salesperson analysis and city analysis.

Create a complete project using Excel Table, Pivot Tables, Pivot Charts, Slicers, Timeline, KPI Cards and Dashboard.