Word, Excel and PowerPoint Essentials for Microsoft 365
Word, Excel and PowerPoint Essentials for Microsoft 365 is a course in using the three core apps the right way, from formatting documents with styles and mail merge to calculating with formulas and PivotTables and building slides with Morph and Zoom. It suits office staff, students, teachers and people moving from an older version of Office.
- Duration12 hours · 2 days
- FormatOnsite / live online
- Next roundOn request
- CertificateIncluded
Course overview
Word, Excel and PowerPoint are still the core tools of office work, yet many people use them the way they learnt on old versions of Office: spacing documents out with the space bar, working sums out on a calculator and typing the answers into a table, and building slides one by one without a theme. Office 2019 has reached the end of support, and the current Microsoft 365 apps offer tools that make work faster and easier to change, such as AutoSave to OneDrive, styles, modern formulas like XLOOKUP, and Design Suggestions and Morph in PowerPoint.
This course teaches Word, Excel and PowerPoint in Microsoft 365 the right way from the start. It begins with the shared interface and saving and recovering files, then covers formatting documents with styles, tables of contents, tables and mail merge in Word; data entry, formulas, everyday functions, PivotTables and charts in Excel; and slide design, animation and rehearsing a talk in PowerPoint. It finishes with a workshop that produces a project pack across all three apps. (2 days, 6 hours per day, 12 hours in total, Beginner level.)
What you’ll gain
- Work confidently with the ribbon, the Quick Access Toolbar and the search box in the Microsoft 365 apps
- Save, share and recover files with AutoSave, OneDrive and version history
- Format Word documents with styles and create tables of contents, tables and mail merges
- Enter data, write formulas and use everyday functions correctly in Excel
- Summarise data with PivotTables and present it with charts in Excel
- Design slides with themes and Design Suggestions, and use Morph and Zoom in PowerPoint
- Share data between Word, Excel and PowerPoint in a single piece of work
Who this course is for
- Office staff who use Word, Excel and PowerPoint regularly and want to bring their methods up to date
- People moving from Office 2016 or 2019 to the Microsoft 365 apps
- Students, teachers and lecturers who produce documents, spreadsheets and presentations
- Beginners who want a grounding in all three apps in one course
Prerequisites
- Able to use a computer and Windows, for example creating folders and copying and pasting files
- Able to type in Thai and English
- No previous knowledge of Word, Excel or PowerPoint is needed
- The Microsoft 365 apps installed, or a Microsoft 365 account that can use the web apps
Curriculum
Course Details
This is the 2026 edition of the Microsoft Office 2019 course. It runs for 2 days, 6 hours per day (12 hours in total, 09:00-16:00), as lectures with labs, at Beginner level. Because Office 2019 has reached the end of support, the content has been rewritten for the Microsoft 365 apps. It concentrates on Word, Excel and PowerPoint, leaving Outlook to the Using Microsoft 365 Apps course, which focuses on email and collaboration, and adds AutoSave, version history, XLOOKUP, Excel tables, Design Suggestions and Speaker Coach. Learners take home the course handbook, sample files and the project pack from the workshop.
Day 1 The Shared Interface and Documents in Word
Section 1: Microsoft 365 Apps and the Shared Interface
- How the Microsoft 365 apps differ from one-off Office 2019 and Office 2024
- The ribbon, ribbon display options, the status bar and the search box
- Customising the Quick Access Toolbar and the ribbon
- Workshop: set up your own interface and favourite shortcuts
Section 2: Lab: Managing Files with AutoSave and OneDrive
- Creating, opening and saving files to OneDrive with AutoSave
- Version history and Recover Unsaved Documents
- Compatibility Mode for older files and exporting to PDF
- Lab: make a mistake in a file and restore an earlier version
Section 3: Lab: Typing and Formatting Documents in Word
- Alignment, line spacing, paragraph spacing and indents
- Matching Thai and English font sizes and setting them as the default
- Bullets, numbering, tab stops and Format Painter
- Lab: format an internal memo
Section 4: Lab: Styles, Headings and Tables of Contents
- Applying and modifying styles instead of formatting by hand
- The Navigation pane, section breaks and a single landscape page
- Headers, footers, page numbers and an automatic table of contents
- Lab: lay out a multi-page report with a table of contents
Section 5: Lab: Tables, Pictures and Objects in Documents
- Creating and formatting tables with header rows that repeat on every page
- Inserting pictures, icons and SmartArt with text wrapping
- Captions and cross-references
- Lab: produce a flyer with a table and pictures
Section 6: Lab: Reviewing, Co-authoring and Mail Merge
- Checking spelling with Editor, plus Translate and Read Aloud
- Comments, Track Changes, Compare and co-authoring on OneDrive
- Mail merge for letters, labels and envelopes from an Excel list
- Lab: produce invitation letters from an Excel recipient list
Day 2 Spreadsheets in Excel and Presentations in PowerPoint
Section 7: Lab: Data Entry and Basic Formulas in Excel
- Workbooks, worksheets, data types and number and date formats
- AutoFill and Flash Fill for fast data entry
- Formulas, relative and absolute references, SUM, AVERAGE and IF
- Lab: build a quotation that totals itself
Section 8: Lab: Everyday Functions and Excel Tables
- XLOOKUP in place of VLOOKUP for looking up data across tables
- SUMIFS, COUNTIFS, IFS and TEXTJOIN
- Excel tables, sorting, filtering and data that keeps growing
- Lab: summarise sales by product and salesperson
Section 9: Lab: Summarising and Presenting Data in Excel
- PivotTables for summarising data in a few clicks
- Recommended Charts, chart formatting and conditional formatting
- Page setup, fitting a print to one page and protecting a sheet
- Lab: a monthly sales report with charts
Section 10: Lab: Building Slides in PowerPoint
- Themes, layouts, Slide Master basics and sections
- Design Suggestions (Designer) for slide layouts
- Pictures, icons, SVG graphics, tables and charts from Excel
- Lab: build a project deck from a Word outline
Section 11: Lab: Morph, Zoom and Rehearsing Your Presentation
- The Morph transition and animations that do not distract
- Summary Zoom and Slide Zoom for non-linear presentations
- Presenter View and Speaker Coach (Rehearse with Coach)
- Lab: add Morph and Zoom, then rehearse with Speaker Coach
Section 12: Workshop: A Complete Project Pack in Three Apps
- Workshop: a project report in Word with a table of contents
- A budget sheet in Excel, with linked charts in Word and PowerPoint
- A summary deck, PDF export and a OneDrive sharing link
- An overview of Copilot in Word, Excel and PowerPoint for licensed users
Schedule & training options
For individuals — public rounds
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
For organisations — in-house / private
- Tailor the content to your team’s tools and projects
- Your dates, at your office or live online
- Quotation with tax ID for procurement
Instructors
Frequently asked questions
I still use Office 2019. Should I move to the Microsoft 365 apps?
Support for Office 2019 ended on 14 October 2025, so it no longer receives security fixes, even though the apps still open. Microsoft recommends moving to Microsoft 365, which keeps gaining new features, or to a one-off Office 2024 licence if you do not want a subscription. This course is based on the Microsoft 365 apps, and most of it also applies to Office 2024.
How do I recover a Word file I forgot to save or edited by mistake?
If the file is stored in OneDrive or SharePoint with AutoSave on, select the file name at the top and choose Version history to open or restore an earlier version. For a file that was never saved, go to File > Info > Manage Document > Recover Unsaved Documents. The course includes a lab that practises both.
How is XLOOKUP different from VLOOKUP?
XLOOKUP can return values from either side of the lookup column, needs no column number, uses an exact match by default and lets you set a not-found message in the same formula, so it does not break when columns are inserted. It is available in Excel for Microsoft 365 and Excel 2021 or later, but not in Excel 2019.
Who is Word, Excel and PowerPoint Essentials for Microsoft 365 for, and what do I need to know first?
It suits office staff, students, teachers and lecturers who want a sound grounding in Word, Excel and PowerPoint, and people moving from an older Office to the Microsoft 365 apps. You should be able to use a computer and Windows; no previous knowledge of the three apps is needed.
What will I be able to do after Word, Excel and PowerPoint Essentials for Microsoft 365?
You will be able to format Word documents with styles, tables of contents and mail merge, calculate and summarise data in Excel with XLOOKUP, tables, PivotTables and charts, build slides with themes, Morph and Zoom in PowerPoint, and keep files safe in OneDrive, and you leave with the project pack from the workshop.
Can Word, Excel and PowerPoint Essentials for Microsoft 365 be run in-house for our team?
Yes. IT Genius Institute runs in-house sessions and can adapt the lab examples to the documents and templates your team actually uses. Contact us for a quotation.
Related articles
Articles are published in Thai.