MS Word and Excel Basics

Introduction

• This lecture covers the basics of MS Word and Excel.

MS Word

• Creating a New Document:
  • Click on 'File' → 'New' to create a new document.
• Margins and Settings:
  • Go to 'Layout' and adjust margins and other page settings.
• Entering Text:
  • Use 'Tab' to move between fields.
  • Example: Name, Date of Birth (use 'Tab' between fields)
• Formatting Text:
  • Use settings like bold, italics, and underline.
• Inserting Elements:
  • Insert tables, images, and other elements using the 'Insert' tab.
• Alignment:
  • Align text to left, right, center using the 'Home' tab.
• Page Numbers:
  • Insert page numbers by going to 'Insert' → 'Page Number'.

MS Excel

• Creating a New Worksheet:
  • Click on 'File' → 'New' to open a new Excel worksheet.
• Entering Data:
  • Use 'Tab' to move between cells.
  • Use columns for different types of data (e.g., Serial Number, Application Names).
• Formulas and Calculations:
  • Input formulas like SUM, AVERAGE.
  • Example: MS Word (Page 5), MS Excel (Page 25), MS PowerPoint (Page 35).
• Inserting Columns:
  • Right-click on a column header and select 'Insert' to add a new column.
• Data Types:
  • Understand different data types like text, numbers and use formulas accordingly.
• Formatting and Selection:
  • Select data ranges for operations.
  • Example: Formatting and selecting specific fields for calculations.
• Charts and Data Visualization:
  • Create charts using selected data for better visualization.

General Tips

• Auto Calculations:
  • Use features like automatic calculations to improve efficiency.
• Saving Documents:
  • Always save your work frequently to prevent data loss.
• Importing Data:
  • Import data from different file types for use in Excel or Word.

Conclusion

• These basics give you a foundation to further explore MS Word and Excel functionalities.
• Practice these steps to become proficient in using these tools.

Thank you for attending the lecture.