Complete MS Office Course – Word, Excel, Advanced Excel & PowerPoint | Get LBSTI Certificate After Course Completion
About Course
Master Microsoft Office with our complete practical training course covering MS Word, MS Excel, Advanced Excel, and Microsoft PowerPoint from beginner to advanced level.
This course is designed to help students, professionals, teachers, job seekers, and business users develop strong practical computer skills required for office work and day-to-day professional tasks.
What You Will Learn
- MS Word: Document creation, formatting, page layout, tables, images, shapes, styles, headers & footers, hyperlinks, bookmarks, references, mail merge, and professional document preparation.
- MS Excel: Data entry, formatting, formulas, functions, tables, sorting & filtering, charts, printing, and essential spreadsheet techniques.
- Advanced Excel: Advanced formulas & functions, IF, SUMIFS, COUNTIFS, VLOOKUP, XLOOKUP, INDEX-MATCH, Pivot Tables, Pivot Charts, data validation, conditional formatting, dashboards, data analysis, and other advanced Excel tools.
- Microsoft PowerPoint: Creating professional presentations, slide design, layouts, themes, animations, transitions, images, charts, SmartArt, audio/video, and presentation techniques.
The course focuses on practical, real-world examples and step-by-step training, helping you confidently use Microsoft Office for office jobs, business, education, freelancing, and professional work.
By the end of this course, you will have a strong working knowledge of MS Word, MS Excel, Advanced Excel, and PowerPoint and will be able to create professional documents, analyze data, prepare reports, and design effective presentations.
Course Content
Complete MS Office Course – Word, Excel, Advanced Excel & PowerPoint
-
Welcome to LBSTI
00:57 -
Lesson 01: How to Save a Word Document
06:58 -
Lesson 02: MS Word – Home Tab & Its Essential Tools
35:25 -
Lesson 03: Insert Tab in MS Word
01:53:14 -
Lesson 04 : MS Word Design Tab – Document Formatting & Design Options
10:40 -
Lesson 5: MS Word Layout Tab – Page Setup & Formatting
09:18