Microsoft Office Package Course

Lesson 1 • File Management and Backstage View

Covers creating, saving, opening, and closing files using Backstage View. Connects file hygiene habits to professional workflow efficiency.

Lesson 2 • Introduction to the Office Suite

Overview of Word, Excel, PowerPoint, Outlook, and OneNote and their professional use cases. Establishes context for the full course progression.

Lesson 3 • Customising the Office Interface

Teaches theme selection, display settings, and personal preference configuration. Reduces friction and improves daily productivity across all applications.

Lesson 1 • Creating and Editing Text

Covers typing, selecting, cutting, copying, pasting, and undoing actions in Word. Forms the baseline editing skill set for all subsequent Word tasks.

Lesson 2 • Character and Paragraph Formatting

Applies font styles, sizes, colours, alignment, indentation, and line spacing. Directly impacts document readability and professional appearance.

Lesson 3 • Styles, Themes, and Templates

Introduces built-in styles, document themes, and reusable templates for consistent formatting. Accelerates document production and enforces visual standards.

Lesson 4 • Lists, Tables, and Visual Elements

Builds bulleted lists, numbered lists, and tables, and inserts images and shapes. Enhances information organisation and visual communication in documents.

Lesson 1 • References and Citations

Inserts footnotes, endnotes, captions, and bibliographies using Word's reference tools. Supports academic and professional document standards.

Lesson 2 • Mail Merge for Mass Communication

Automates personalised letters, labels, and emails by merging a data source with a template. Saves significant time in high-volume communication tasks.

Lesson 3 • Track Changes and Document Review

Enables collaborative editing using Track Changes, comments, and comparison tools. Prepares learners for team-based document workflows.

Lesson 4 • Working with Long Documents

Uses the Navigation Pane, bookmarks, and cross-references to manage lengthy files. Builds efficiency when working with reports, manuals, and proposals.

Lesson 1 • Core Formulas and Functions

Introduces SUM, AVERAGE, COUNT, MIN, MAX, and IF functions with proper syntax. Enables learners to automate calculations across real datasets.

Lesson 2 • Sorting, Filtering, and Basic Tables

Sorts and filters data and converts ranges to structured Excel Tables. Prepares learners for efficient data management and analysis.

Lesson 3 • Spreadsheet Structure and Data Entry

Explains workbooks, worksheets, rows, columns, and cells, and covers efficient data entry. Establishes the structural foundation for all Excel work.

Lesson 4 • Cell References and Named Ranges

Distinguishes relative, absolute, and mixed references and introduces named ranges. Prevents formula errors when copying and scaling spreadsheets.

Lesson 1 • Text, Date, and Statistical Functions

Uses CONCATENATE, TEXT, LEFT, RIGHT, MID, TODAY, and COUNTIF for data manipulation. Expands formula capability for diverse real-world datasets.

Lesson 2 • Data Validation and Protection

Applies data validation rules, drop-down lists, and sheet protection to control input. Maintains data integrity in shared workbooks.

Lesson 3 • PivotTables and PivotCharts

Builds PivotTables to summarise large datasets and creates linked PivotCharts. Delivers fast, flexible reporting without complex formulas.

Lesson 4 • Charts and Data Visualisation

Creates and formats column, bar, line, pie, and combo charts for data storytelling. Connects chart selection to the type of data being communicated.

Lesson 1 • Slide Structure and Layout Fundamentals

Covers slide layouts, placeholders, and the Slide Panel for building a presentation framework. Establishes structural discipline before adding content.

Lesson 2 • Animations and Slide Transitions

Applies entrance, emphasis, and exit animations and configures slide transitions. Adds purposeful motion that guides audience focus without distraction.

Lesson 3 • Presenting and Exporting

Uses Presenter View, rehearsal tools, and export options to deliver and share presentations. Prepares learners for live and remote presentation scenarios.

Lesson 4 • Design Themes and Slide Master

Applies built-in themes, colour schemes, and fonts, and edits the Slide Master for consistency. Ensures brand-aligned design across every slide.

Lesson 1 • Tasks, Notes, and Productivity Tools

Uses Outlook Tasks, To-Do integration, and Notes to track work and deadlines. Extends Outlook beyond email into a full personal productivity hub.

Lesson 2 • Email Composition and Management

Covers composing, replying, forwarding, and organising emails with folders and rules. Builds the core communication workflow used daily in professional settings.

Lesson 3 • Calendar and Scheduling

Creates appointments, meetings, and recurring events and shares calendars with colleagues. Supports coordinated scheduling across teams and time zones.

Lesson 4 • Contacts and People Management

Builds and manages a contact list, contact groups, and address books in Outlook. Streamlines communication with frequently contacted individuals and teams.

Lesson 1 • Workflow Automation with Power Automate

Introduces Power Automate flows that trigger actions across Office and connected apps. Extends automation beyond macros to cloud-based business processes.

Lesson 2 • Collaboration with Microsoft 365 Tools

Covers real-time co-authoring, comments, and version control in SharePoint and OneDrive. Enables seamless teamwork on shared Office documents.

Lesson 3 • Introduction to Macros in Excel and Word

Records and runs macros to automate repetitive formatting and data tasks. Reduces manual effort and error in high-frequency workflows.

Lesson 4 • Excel Power Query for Data Import

Uses Power Query to import, clean, and transform data from external sources. Automates data preparation steps that previously required manual effort.