Advanced Computer Course

Lesson 1 • Operating System Essentials

Covers OS navigation, file systems, and system settings management. Enables efficient daily operation across Windows and macOS environments.

Lesson 2 • Basic System Maintenance

Covers updates, disk cleanup, and startup optimization routines. Ensures systems remain stable, secure, and performant over time.

Lesson 3 • File Management and Organisation

Teaches folder structures, naming conventions, and file operations. Directly supports productivity by reducing time lost searching for documents.

Lesson 4 • Hardware Components and Functions

Identifies and explains CPU, RAM, storage, and peripheral roles. Builds physical literacy needed to troubleshoot and optimise any workstation.

Lesson 1 • Online Safety and Privacy Basics

Identifies phishing, malware, and unsafe browsing behaviours with mitigation strategies. Establishes a security mindset carried through all subsequent chapters.

Lesson 2 • Video Conferencing and Virtual Meetings

Covers setup, etiquette, screen sharing, and recording for virtual meetings. Prepares learners for hybrid and remote professional environments.

Lesson 3 • Cloud Storage and File Sharing

Introduces cloud platforms for storing, syncing, and sharing files securely. Connects to collaboration workflows covered in later chapters.

Lesson 4 • Browser Mastery and Web Navigation

Covers browser settings, extensions, tabs, and advanced search techniques. Enables fast, focused information retrieval for professional tasks.

Lesson 1 • Advanced Formatting Techniques

Covers columns, section breaks, headers, footers, and page numbering. Enables production of multi-section reports and formal documents.

Lesson 2 • Tables, Graphics, and Visual Elements

Inserts and formats tables, images, charts, and SmartArt within documents. Enhances communication by integrating visual data into written content.

Lesson 3 • References and Long Document Tools

Generates tables of contents, footnotes, citations, and indexes automatically. Supports academic and technical report writing at a professional standard.

Lesson 4 • Document Structure and Styles

Applies heading styles, themes, and style sets to create structured documents. Ensures visual consistency and enables automatic table of contents generation.

Lesson 1 • Data Sorting, Filtering, and Tables

Applies sorting, multi-level filters, and structured table formatting to datasets. Transforms raw data into navigable, analysis-ready structures.

Lesson 2 • Core Formulas and Functions

Teaches SUM, AVERAGE, IF, VLOOKUP, and text functions for data processing. Enables automation of calculations that would otherwise require manual effort.

Lesson 3 • Spreadsheet Structure and Data Entry

Covers workbook layout, cell referencing, and efficient data entry techniques. Establishes clean data habits that prevent errors in later analysis.

Lesson 4 • Charts and Data Visualisation

Creates and customises bar, line, pie, and combo charts for reporting. Translates numerical data into visual insights for non-technical audiences.

Lesson 1 • Slide Design Principles

Applies visual hierarchy, colour theory, and layout grids to slide design. Prevents common design mistakes that undermine professional credibility.

Lesson 2 • Content Structure and Storytelling

Structures presentations using narrative frameworks and audience-centred logic. Ensures every slide serves a clear communicative purpose.

Lesson 3 • Delivery Tools and Presenter Mode

Uses presenter view, speaker notes, and remote clickers for confident delivery. Prepares learners for live, hybrid, and recorded presentation scenarios.

Lesson 4 • Animations and Slide Transitions

Applies purposeful animations and transitions to guide audience attention. Distinguishes professional motion design from distracting visual noise.

Lesson 1 • Designing Tables and Relationships

Builds database schemas with appropriate data types and referential integrity. Prevents data redundancy and ensures long-term database maintainability.

Lesson 2 • Reports and Data Output

Generates formatted reports with grouping, totals, and conditional formatting. Delivers professional data outputs suitable for management and stakeholder review.

Lesson 3 • Forms and Data Entry Interfaces

Creates user-friendly forms for controlled, validated data entry into tables. Reduces input errors and makes databases accessible to non-technical users.

Lesson 4 • Relational Database Fundamentals

Explains tables, primary keys, foreign keys, and relationships. Provides the conceptual foundation for all subsequent database design and querying work.

Lesson 1 • Recording and Running Macros

Records, edits, and assigns macros to buttons within office applications. Delivers immediate productivity gains without requiring programming knowledge.

Lesson 2 • Automating Repetitive Office Tasks

Builds practical scripts for mail merge, report generation, and batch formatting. Applies scripting skills directly to high-frequency professional scenarios.

Lesson 3 • Introduction to Automation Concepts

Defines automation, identifies automatable tasks, and maps workflow bottlenecks. Sets strategic context before any technical implementation begins.

Lesson 4 • Basic Scripting with VBA or Built-in Tools

Introduces variables, loops, and conditionals within the application scripting environment. Enables creation of dynamic macros that respond to data conditions.

Lesson 1 • Dashboard Design and KPI Reporting

Builds interactive dashboards with KPI cards, slicers, and dynamic charts. Translates complex data into executive-ready visual summaries.

Lesson 2 • Power Query for Data Transformation

Imports, cleans, and reshapes data from multiple sources using Power Query. Eliminates manual data preparation and creates repeatable transformation pipelines.

Lesson 3 • Advanced Spreadsheet Functions

Applies INDEX-MATCH, XLOOKUP, array formulas, and dynamic arrays to complex datasets. Solves analytical problems that basic functions cannot address.

Lesson 4 • Introduction to Business Intelligence Tools

Introduces BI platforms for connecting, modelling, and visualising enterprise data. Bridges spreadsheet skills to scalable organisational reporting infrastructure.