Microsoft Excel for Beginners (In Urdu) Free Course

Module 1: Introduction to Excel

1.1 What is Microsoft Excel?

1.2 Excel's importance in data management.

1.3 Excel interface and navigation.

1.4 Creating and saving your first Excel file.

Module 2: Basic Excel Functions and Formulas

2.1 Entering data into cells.

2.2 Formatting cells and text.

2.3 Understanding cell references.

2.4 Basic arithmetic operations (addition, subtraction, multiplication, division).

2.5 Introduction to formulas (e.g., SUM, AVERAGE, MAX, MIN).

2.6 Using AutoSum for quick calculations.

Module 3: Working with Worksheets

3.1 Creating and deleting worksheets.

3.2 Renaming worksheets.

3.3 Navigating between worksheets.

3.4 Copying and moving data between worksheets.

Module 4: Data Management

4.1 Sorting data.

4.2 Filtering data.

4.3 Data validation and drop-down lists.

4.4 Using Find and Replace.

4.5 Removing duplicates.

Module 5: Basic Formatting and Styling

5.1 Changing font styles and sizes.

5.2 Applying cell borders and shading.

5.3 Using cell styles.

5.4 Adding cell colors and conditional formatting.

Module 6: Working with Rows and Columns

6.1 Inserting and deleting rows and columns.

6.2 Adjusting column widths and row heights.

6.3 Freezing panes for better navigation.

Module 7: Charts and Graphs

7.1 Creating basic charts (e.g., bar charts, pie charts).

7.2 Customizing charts.

7.3 Adding data labels and titles to charts.

Module 8: Printing and Sharing

8.1 Page setup and print options.

8.2 Printing worksheets and workbooks.

8.3 Saving Excel files in different formats.

8.4 Sharing workbooks via email or cloud storage.

Module 9: Basic Functions and Formulas

9.1 Understanding functions and their syntax.

9.2 Common functions (e.g., IF, SUMIF, COUNTIF).

9.3 Performing basic calculations with formulas.

9.4 Introduction to absolute and relative cell references.

Module 10: Data Analysis Tools

10.1 Introduction to Data Tables.

10.2 PivotTables for data summarization.

10.3 What-If Analysis using Goal Seek and Scenario Manager.

Module 11: Final Project

11.1 Applying all the learned skills to a practical project.

11.2 Creating a budget or expense tracker.

-----------------------------------------------------------------------------------------------------------

Project: Personal Budget and Expense Tracker

Project Description: Create a simple personal budget and expense tracker in Microsoft Excel to help manage your finances.

Project Components:

1. Income Sheet:

   • Create an "Income" sheet with the following columns:
     • Date
     • Income Source
     • Amount

2. Expense Tracker:

   • Create an "Expenses" sheet with the following columns:
     • Date
     • Category (e.g., Housing, Transportation, Food, Entertainment)
     • Expense Description
     • Amount

3. Budget Planning:

   • Create a "Budget" sheet with the following columns:
     • Category
     • Budgeted Amount

4. Dashboard:

   • Create a "Dashboard" sheet with the following elements:
     • A summary of total income and expenses.
     • A pie chart to visualize the breakdown of expenses by category.
     • Conditional formatting to highlight overspending in the expense tracker.

Sample Data:

You can add sample data to the "Income" and "Expenses" sheets to see how your tracker works. For instance:

Income:

Date	Income Source	Amount
2023-01-01	Salary	4000
2023-01-15	Freelance Work	800

Expenses:

Date	Category	Expense Description	Amount
2023-01-05	Housing	Rent	1200
2023-01-10	Food	Groceries	300

Budget:

Fill out the "Budget" sheet with your planned budgeted amounts for each category.

Dashboard:

In the dashboard sheet, you can use Excel functions and formulas to calculate:

• Total income: =SUM('Income'!C2:C100)
• Total expenses: =SUM('Expenses'!D2:D100)
• Savings (or deficit): =Total Income - Total Expenses
• 


-----------------------------------------------------------------------------------

Module 12: Course Review and Next Steps

12.1 Recap of the course.

12.2 Resources for further learning.

12.3 Excel tips and shortcuts.