Duration 2 days – 14 hrs
Overview
This training course is designed to provide participants with foundational skills in Microsoft Word and Excel. Participants will learn how to create, edit, format, and manage documents and spreadsheets, equipping them with essential skills for personal and professional use. By the end of the course, attendees will be able to use Word for professional document creation and Excel for basic data management and analysis.
Objectives
- Understand the basic interface and functionalities of Microsoft Word and Excel.
- Create, format, and edit professional documents in Word.
- Use Excel to organize, format, and analyze basic data.
- Apply key tools such as tables, charts, and templates in both applications.
- Save, print, and share documents and spreadsheets efficiently.
Audience
- Administrative staff, students, and professionals seeking basic knowledge of Microsoft Word and Excel.
- Individuals new to Microsoft Office applications or seeking to refresh their skills.
Prerequisites
- Basic computer literacy, including the ability to use a keyboard and mouse.
- No prior experience with Microsoft Word or Excel is required.
Course Content
Day 1: Microsoft Word Basics
Introduction to Microsoft Word
- Overview of the interface
- Understanding the ribbon, quick access toolbar, and status bar
Creating and Formatting Documents
- Typing and editing text
- Applying font styles, sizes, and colors
- Paragraph alignment, line spacing, and indentation
Working with Lists and Tables
- Creating and customizing bulleted and numbered lists
- Inserting and formatting tables
Page Layout and Design
- Adjusting margins, orientation, and paper size
- Adding headers, footers, and page numbers
- Using themes and styles
Saving, Printing, and Sharing
- File formats and versions
- Printing options and PDF conversion
- Emailing and sharing documents
Day 2: Microsoft Excel Basics
Introduction to Microsoft Excel
- Overview of the interface
- Understanding worksheets, workbooks, and cells
Basic Excel Operations
- Entering, editing, and formatting data
- Using autofill and flash fill
- Adjusting row height and column width
Basic Formulas and Functions
- Introduction to formulas (SUM, AVERAGE, MIN, MAX)
- Using basic functions for calculations
Working with Data
- Sorting and filtering data
- Formatting data for readability
Creating Charts and Tables
- Inserting and customizing charts
- Using tables for data organization
Saving, Printing, and Sharing
- File saving formats
- Print area selection and page setup
- Exporting as PDF and sharing spreadsheets
