About Course
Master the essential tools of modern office work with our MS Office Package Course. This comprehensive training is designed for students, job seekers, and professionals who want to improve their productivity and digital skills.
In this course, you will learn how to effectively use key applications from Microsoft Office including Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.
You will start from the basics and gradually move toward advanced features, enabling you to create professional documents, analyze data, and design impactful presentations.
What You Will Learn:
- Create and format documents in Word
- Perform calculations and data analysis in Excel
- Create professional presentations in PowerPoint
- Use formulas, charts, and functions in Excel
- Design resumes, reports, and official documents
- Improve typing speed and office efficiency
Who This Course is For:
- Students
- Job seekers
- Office workers
- Freelancers
- Beginners with no prior experience
Benefits:
- Practical, easy-to-follow lessons
- Real-world assignments
- Boost your CV and job opportunities
- Certificate upon completion
Duration:
4–6 Weeks (depending on your pace)
Outcome:
By the end of this course, you will have the confidence and skills to handle daily office tasks professionally using MS Office tools.
Course Content
MS Excel
-
Lesson 1 Introduction
01:10 -
MCQs
-
Lesson 2 How to Merge Cells in Excel
02:30 -
Lesson 3 How Formulas and Functions Work in Excel?
02:27 -
Lesson 4 Basic Sum & Average Formula in Excel
04:10 -
Lesson 5 How to use MIN, MAX and LARGE formula in Excel?
04:24 -
Lesson 6 Conditional Formulas IF, AND , OR in Excel
05:09 -
Lesson 7 Text Formatting Formulas CONCAT, RIGHT & LEFT in Excel
02:59 -
Lesson 8 LEN, TRIM & TODAY Formula in Excel
05:52 -
Lesson 9 LOOKUP, VLOOKUP & HLOOKUP in Excel
09:28 -
Lesson 10 Counting formula in EXCEL COUNT & COUNTIF
04:56 -
Lesson 11 INDEX&MATCH Formula in Excel
03:07 -
Lesson 12 Creating a Simple Shop Sale System in Excel
05:30 -
Lesson 16 How to Create Pivot Table in Excel
01:32 -
Lesson 17 a How to do What if Analysis in Excel
03:12 -
Lesson 17 b What if Analysis in Excel
02:08 -
Lesson 18 Conditional Formatting in Excel
01:50 -
Lesson 19 How to use data Filters in Excel
01:35