Microsoft Excel Overview for ICT Class

Introduction to Microsoft Excel

• Teacher: Ms. Lieshan S. Bernadit
• Institution: University of Perpetual Help System Dalta - Las Piñas, Junior Business High School Department

Daily Routine Overview

• Components:
  • Daily Routine
  • Recall/Motivation
  • Essential Question
  • Lesson Proper
  • Evaluation/Activity
  • Wrap-Up/Valuing/Assignment

Essential Question

• How can we navigate and use Microsoft Excel to organize data efficiently?

Learning Objectives

By the end of class, students should be able to:

• Determine how to use basic Excel commands such as:
  • Cut
  • Copy
  • Paste
  • Undo
  • Redo
  • Autofill
• Insert, delete, and save workbooks properly
• Create a new workbook and enter data in cells

Working with Microsoft Excel Commands

Creating and Saving Workbooks

• Creating a Workbook:
  • Open Microsoft Excel and select "New" to start a new workbook.
• Saving a Workbook:
  • Use the command File > Save As to save your workbook.

Cell Operations

• Inserting and Changing Data in Cells:
  • Click on a cell to edit its contents. Double-click to edit directly or start typing immediately.
• Speeding Up Data Entry:
  • Use Autofill to quickly fill a series of cells based on patterns.

Basic Editing Commands

• Undo and Redo Commands:
  • Use Ctrl + Z to undo changes and Ctrl + Y to redo changes.
• Cut, Copy, and Paste Commands:
  • Use Ctrl + C to copy, Ctrl + X to cut, and Ctrl + V to paste data.

Managing Workbook Structure

• Inserting and Deleting Columns and Rows:
  • Right-click on a column/row header to insert or delete.
• Opening a Previously Saved Workbook:
  • Use File > Open to access files that are saved on your computer.

Conclusion

• Ensure familiarity with the tools and commands discussed to enhance efficiency in using Excel.
• Prepare for hands-on practice and application in subsequent lessons.