Certificate Advance Office Management 

1 Windows

Personalization, Element of windows, Working with icon, file and some imporant tool in control pannel

2. MS Word – Advanced Document Processing

Theory Topics

1. Introduction to MS Word and Its Interface
2. Creating, Opening and Saving Documents
3. Text Formatting and Paragraph Formatting
4. Page Setup, Margins, Orientation and Paper Size
5. Headers, Footers and Page Numbering
6. Tables, Borders and Shading
7. Bullets, Numbering and Multilevel Lists
8. Styles, Themes and Templates
9. Mail Merge and Its Applications
10. Table of Contents, References and Printing

3. MS Excel – Advanced Spreadsheet

Theory Topics

1. Introduction to Workbook, Worksheet, Rows and Columns
2. Data Entry and Cell Formatting
3. Formulas and Operators
4. Relative, Absolute and Mixed Cell References
5. Mathematical and Statistical Functions
6. IF, AND, OR and Nested IF Functions
7. COUNTIF, SUMIF and AVERAGEIF, Lookup
8. Sorting and Filtering Data
9. Charts and Graphs
10. Data Validation, Conditional Formatting and PivotTables

4. MS PowerPoint – Presentation Skills

Theory Topics

1. Introduction to Presentation Software
2. Slides, Layouts and Themes
3. Text and Paragraph Formatting
4. Inserting Pictures, Shapes, Icons and SmartArt
5. Tables, Charts, Audio and Video
6. Transitions and Animations
7. Slide Master and Design Consistency
8. Hyperlinks and Action Buttons
9. Slide Show Settings and Presenter View
10. Presentation Planning and Professional Design

5. Internet, Email & Digital Communication

Theory Topics

1. Internet, Intranet and Extranet
2. Web Browsers and Search Engines
3. WWW, URL, HTTP and HTTPS
4. Email Concepts and Email Protocols
5. Attachments, CC, BCC and Email Etiquette
6. Cloud Storage and File Sharing
7. Video Conferencing and Online Meetings
8. Digital Payments and Online Services
9. Cybersecurity, Phishing and Malware
10. Password Safety and Digital Privacy

6. Practical Project & Viva

Theory / Viva Topics

1. Computer and Office Software Fundamentals
2. MS Word, Excel and PowerPoint Concepts
3. Database and Record Management
4. Internet and Email Usage
5. Office Procedures and Professional Communication
6. Cybersecurity and Data Protection