Excel Scheme

 

Topic	Tool	What We Use the Tool For	Practical
What is Microsoft Excel?	Microsoft Excel	To organize, calculate, analyze, and visualize data.	Open Microsoft Excel and create a new workbook.
Microsoft Excel Interface	Microsoft Excel	To learn the Ribbon, Formula Bar, Name Box, Rows, Columns, Cells, and Worksheets.	Identify and explain the main parts of the Excel interface.
Creating and Saving Workbooks	Microsoft Excel	To create, save, and manage Excel files.	Create a workbook and save it as an Excel file and PDF.
Entering and Editing Data	Microsoft Excel	To input, edit, and organize data efficiently.	Create a student attendance sheet.
Cell Formatting	Microsoft Excel	To format numbers, dates, fonts, borders, and colors.	Format a sales record professionally.
Rows, Columns, and Worksheets	Microsoft Excel	To organize and manage spreadsheet data.	Insert, delete, hide, and rename worksheets.
Basic Formulas	Microsoft Excel	To perform mathematical calculations.	Calculate totals using addition, subtraction, multiplication, and division formulas.
Common Functions	Microsoft Excel	To perform automatic calculations using built-in functions.	Use SUM, AVERAGE, MIN, MAX, and COUNT on student scores.
Relative and Absolute Cell References	Microsoft Excel	To copy formulas correctly across worksheets.	Create a multiplication table using relative and absolute references.
Sorting and Filtering	Microsoft Excel	To organize and search large datasets.	Sort employees by salary and filter a specific department.
Tables	Microsoft Excel	To organize and manage structured data.	Convert a dataset into an Excel Table and apply styles.
Conditional Formatting	Microsoft Excel	To highlight important data automatically.	Highlight students who scored below 50%.
Charts and Graphs	Microsoft Excel	To visualize data for reports and presentations.	Create a bar chart and a pie chart from sales data.
Data Validation	Microsoft Excel	To control what users can enter into cells.	Create a drop-down list for departments.
Freeze Panes	Microsoft Excel	To keep headers visible while scrolling.	Freeze the first row in a large worksheet.
Page Layout and Printing	Microsoft Excel	To prepare worksheets for printing.	Set print area, page orientation, margins, and print preview.
IF Function	Microsoft Excel	To make logical decisions based on conditions.	Create a grading system using the IF function.
VLOOKUP and XLOOKUP	Microsoft Excel	To search and retrieve information from tables.	Find employee information using employee IDs.
Pivot Tables	Microsoft Excel	To summarize and analyze large amounts of data.	Create a Pivot Table showing monthly sales by region.
Pivot Charts	Microsoft Excel	To visualize Pivot Table summaries.	Create a Pivot Chart from the Pivot Table.
Basic Data Analysis	Microsoft Excel	To analyze trends and business performance.	Analyze monthly expenses and income.
Protecting Worksheets	Microsoft Excel	To prevent unauthorized changes to data.	Protect a worksheet with a password.
Importing and Exporting Data	Microsoft Excel	To work with CSV and other file formats.	Import a CSV file and export it as PDF.
Final Microsoft Excel Project	Microsoft Excel	To apply all Excel skills in one practical project.	Create a complete business dashboard with formulas, charts, Pivot Tables, conditional formatting, and print-ready reports.