Course Outline

Module 1: Microsoft Word for Professional Document Management

• Introduction to Microsoft Word
• Creating and saving documents
• Text and paragraph formatting
• Page layout and document setup
• Styles and document consistency
• Tables, lists and text alignment
• Headers, footers and page numbering
• Inserting images and other elements
• Document review and editing tools
• Printing and sharing documents
• Activity: Create and format a professional workplace document using appropriate Word features.

Module 2: Microsoft Excel Fundamentals

• Introduction to Excel workbooks and worksheets
• Data entry and editing
• Formatting cells and worksheets
• Basic formulas and calculations
• Common Excel functions
• Cell references
• Sorting and filtering data
• Creating and formatting tables
• Basic worksheet organisation
• Activity: Develop a structured Excel worksheet for a common workplace task.

Module 3: Excel Data Analysis and Reporting

• Data cleaning and organisation
• Advanced formulas and functions
• Conditional formatting
• Data validation
• Sorting and filtering for analysis
• Basic charts and visualisation
• Summarising workplace data
• Preparing simple Excel reports
• Case Study: Analyse a workplace dataset, identify key findings and prepare a concise Excel-based report.

Module 4: Microsoft PowerPoint for Professional Presentations

• Introduction to PowerPoint
• Creating and organising slides
• Presentation layouts and design principles
• Working with text and images
• Tables, charts and graphics
• Slide transitions and animations
• Consistent presentation formatting
• Presentation delivery techniques
• Sharing and presenting PowerPoint files
• Activity: Develop a professional presentation based on a workplace topic.

Module 5: Integrated Microsoft Office for Workplace Productivity

• Integrating Word, Excel and PowerPoint
• Using Excel data in Word documents and PowerPoint presentations
• Managing and sharing Office files
• Document and spreadsheet productivity techniques
• File organisation and version management
• Improving accuracy and consistency
• Workplace collaboration and information sharing
• Applying Microsoft Office to routine business tasks
• Simulation: Complete a workplace assignment requiring the use of Word, Excel and PowerPoint to produce a coordinated set of professional outputs.