Power of Microsoft Office

Master Excel, PowerPoint, and Word with structured, in-depth Microsoft Office training.

Overview:
Mastering Microsoft Office isn’t just about knowing which button to press—it’s about wielding Excel, PowerPoint, and Word like a seasoned pro. Whether you’re crunching numbers, building polished presentations, or finessing text documents, this course cuts through the clutter and gets straight to what matters. It brings together everything from formula functions and pivot tables in Excel to SmartArt and animations in PowerPoint, and formatting finesse in Word.

This well-organised module-based training is designed to take you from cautious clicks to confident control. Spanning Windows, macOS, and Linux, it blends functionality with finesse across all three Office giants. Each section is cleanly structured, deliberately paced, and meant to build up your capability step-by-step without any jargon-heavy fluff. If you're ready to stop googling every five minutes and finally get to grips with Microsoft Office, you're in the right place.

Learning Outcomes:

• Confidently navigate Excel, Word, and PowerPoint interfaces with ease.
• Create structured spreadsheets, charts, and formula-based data models.
• Format text, tables, and documents to meet professional standards.
• Build engaging, well-structured presentations with animation and media.
• Import, organise, and analyse data with advanced Excel functions.
• Use styles, layout tools, and mail merge in Microsoft Word effectively.

Course Curriculum:
Microsoft Excel Modules

1. Introduction
2. Getting Started on Windows, macOS, and Linux
3. How to Ask Great Questions
4. FAQs
5. Excel Overview
6. Start Excel Spreadsheet
7. Enter Text and Numbers
8. Relative References
9. Working with Ranges
10. Save and Save As Actions
11. File Extensions, Share, Export, and Publish Files
12. Adding Rows and Columns
13. Modifying Rows and Column Lengths
14. Copy, Cut, and Paste
15. Copying Formulas
16. Page Setup Options
17. Fit to Print on One Page
18. Print Workbooks
19. Sorting Data (Ascending Order)
20. Sorting Data (Descending Order)
21. Filter Data
22. Basic Formula Operations
23. Date & Time Functions
24. Mathematical Functions – Phase 1
25. Mathematical Functions – Phase 2
26. VLOOKUP Formula
27. HLOOKUP Formula
28. XLOOKUP
29. Handling NA and Approximate Match in XLOOKUP
30. Split Text into Columns
31. Flash Fill
32. Data Validation
33. Remove Duplicates
34. Import Data from Text
35. Import Data from CSV
36. Formatting: Font
37. Formatting: Alignment
38. Formatting: Number
39. Formatting: Date
40. Formatting: Tables
41. Creating Pivot Tables
42. Pivot Charts
43. Excel Chart Categories
44. Elements of a Chart
45. Creating Charts
46. Column/Bar Charts
47. Formatting Charts
48. Line Charts
49. Pie and Doughnut Charts

Microsoft PowerPoint Modules
50. Overview
51. Start PowerPoint Presentation
52. Screen Setting and Views
53. Presentation Tips and Guidelines
54. Creating a New Presentation
55. Working with Slides
56. Save a Presentation
57. Print Slides
58. Formatting Text
59. Slide Text Alignments
60. Multi-Column Text Alignments
61. Adding Bullets and Numbered Lists
62. Insert Shapes
63. Insert Icons
64. Insert Graphics
65. Add 3D Models
66. Insert Pictures
67. Picture Options
68. Picture Cropping
69. Apply Built-In Picture Styles
70. Add SmartArt Graphics
71. Modify SmartArt
72. Create a Target Chart using SmartArt
73. Create a Table on Slide
74. Formatting Tables
75. Inserting Tables
76. Table Layouts
77. Add a Chart
78. Formatting Charts
79. Insert Chart from Excel
80. Add Video to a Presentation
81. Add Audio to a Presentation
82. Screen Recording and Adding
83. Apply Transitions
84. Object Animation
85. Effect Options
86. Advanced Animation
87. Use Triggers for Animation
88. Onscreen Presentation
89. Hide Slides
90. Change Order of Slides
91. Copy Slides

Microsoft Word Modules
92. Overview of MS Word
93. Start MS Word 2021
94. Create a New Blank Document
95. Creating Paragraph Text
96. Non-Printing Characters
97. Save a Document
98. Open a Document
99. Find and Replace
100. Autocorrect Options
101. Formatting Text
102. Copy, Cut, and Paste
103. Character Formatting
104. Format Painter
105. Work with Numbers
106. Add Bullets
107. Outline Creation
108. Creating a Table
109. Adding Rows and Columns to a Table
110. Formatting Table Data
111. Borders and Shading
112. Sorting in a Table
113. Draw a Table
114. Convert Text to Table
115. Convert Table to Text
116. Insert a Spreadsheet
117. Quick Tables – Built-In Formats
118. Working with Styles
119. Creating Styles
120. Clear Formatting
121. Margins
122. Orientation
123. Page Size Settings
124. Adding Columns
125. Page Break & Section Break
126. Adding Watermark
127. Headers and Footers
128. Create Envelopes
129. Create Labels
130. Mail Merge Document
131. Thesaurus and Spell Check
132. Word Count
133. Speech – Read Aloud
134. Language – Translate
135. Tracking

Who is This Course For:

• Professionals managing spreadsheets, documents, and slides regularly.
• Students needing consistent formatting and structured assignments.
• Admin staff handling reports, letters, and presentations.
• Small business owners working with budgets and templates.
• Data analysts requiring Excel’s advanced formula features.
• Jobseekers adding Office proficiency to their CV.
• Content creators using Word and PowerPoint for publishing.
• Anyone fed up with formatting errors and wasted screen clicks.

Career Path:

• Administrative Assistant – £22,000 average per year
• Office Manager – £30,000 average per year
• Data Entry Specialist – £21,000 average per year
• Project Coordinator – £29,000 average per year
• Business Analyst – £42,000 average per year
• Marketing Assistant – £25,000 average per year