Microsoft Office and Computer Basics

Overview
This course introduces you to the power and versatility of Microsoft Office, with a strong focus on the skills you actually use day to day in Word, Excel, and PowerPoint. You will start with the fundamentals, document creation, formatting, spreadsheet basics, formulas, and simple charts, and then build up to more advanced skills such as pivot tables, data slicers, advanced filtering, and collaborative document editing. Live demonstrations, hands-on exercises, and group activities keep the pace practical and engaging throughout.
The course is designed for beginners and for anyone who wants to strengthen their foundation in Microsoft Office. It runs 20 hours in total, moving from core fundamentals to more advanced Excel-focused data analysis and presentation skills.
What You Will Learn
- Create, format, and edit professional documents in Word using styles, tables, and headers and footers
- Navigate Excel confidently and enter and format data accurately
- Build basic and advanced formulas and functions, including IF, VLOOKUP, and cell referencing
- Create and customize charts and pivot tables to analyze and visualize data
- Design engaging PowerPoint presentations using themes, transitions, and multimedia
- Use Word’s collaboration features, including comments and track changes
- Apply advanced Excel techniques such as data slicers, advanced filtering, and what-if analysis
Course Curriculum
| Module | What you cover |
|---|---|
| Introduction to Microsoft Office | Overview of the Office suite, common features, and navigating Word, Excel, and PowerPoint |
| Microsoft Word Basics | Formatting text, page layout, tables, and inserting graphics and objects |
| Microsoft Excel Fundamentals | Data entry, basic formulas, cell formatting, worksheets, charts, and an introduction to pivot tables |
| Microsoft PowerPoint Essentials | Creating presentations, applying themes and transitions, and incorporating multimedia elements |
| Advanced Excel Data Analysis | Pivot tables and pivot charts, data slicers, advanced filtering, and what-if analysis with Goal Seek and Scenario Manager |
| Advanced Word and PowerPoint Skills | Collaborative editing with comments and track changes, long document formatting, and advanced presentation design and delivery |
Target audiences
- Beginners and anyone looking to strengthen their foundation in Microsoft Word, Excel, and PowerPoint