Mastering Computer Fundamentals--Beginner to Intermediate

By completing this lesson, you’ll confidently create, organize, rename, delete, restore, copy, and move both files and folders in Windows—giving you full control over your digital workspace and laying a strong foundation for future computer skills.

In this practical, step-by-step lesson, you’ll learn the essential skills of Windows file and folder management—a core foundation for every computer user. Whether you’re using Windows 8, 10, 11 or later version of windows, you’ll discover how to organize, protect, and streamline your digital workspace with ease.

Here’s what you’ll master in this lesson:

• Create new folders using multiple methods to keep your documents, pictures, music, and videos organized.

• Rename folders and files so your work is neatly labeled and easy to locate.

• Delete unnecessary folders and files to free up valuable storage space.

• Recover accidentally deleted items using the Recycle Bin and the Restore command.

• Copy folders and files into different storage locations for backups or duplication.

• Move (cut and paste) folders and files to secure locations for better privacy and organization.

• Apply the same techniques to both files and folders, building a complete foundation in file management.

By the end, you’ll not only understand how to work with files and folders but also how to manage your digital workspace efficiently and securely.

This lesson is highly practical—after each section, you’ll be encouraged to pause and practice the steps on your own computer, ensuring that the skills become second nature.

When you share a computer at home, school, or in the office, your files shouldn’t be exposed to everyone else.

In this lesson, you’ll discover how to protect your work with user accounts and transfer files safely between computers using USB flash drives and memory cards. These are essential skills for every beginner who wants privacy, organization, and flexibility in handling digital files.

Here’s what you’ll learn step by step:

• Why user accounts are critical for keeping your files confidential on shared computers

• The difference between Administrator, Standard, and Guest accounts in Windows

• How to create a new user account and protect it with a password

• How to navigate to Control Panel or PC Settings in Windows 7, 8, and 10 to manage accounts

• Safely copy files from your computer to a flash drive or memory card for portability

• How to transfer files from a USB or memory card back into your computer

• The importance of using the Eject command to safely remove external storage devices

• Real-world examples of moving documents, music, and projects between different computers

By completing this lesson, you’ll confidently create secure user accounts for privacy and transfer files to and from USB flash drives or memory cards—skills that will protect your data and make you more productive on any Windows computer.

Unlock the full potential of Microsoft Word by mastering the foundational skills that make every document look professional.

In this lesson, you’ll learn how to set up your page correctly before typing — a vital step for creating letters, reports, manuals, and questionnaires that stand out.

Here’s what you’ll learn step-by-step:

• How to launch Microsoft Word and navigate the interface with confidence

• The role of the cursor, rulers, and margins in structuring your text

• How to use minimize, maximize, and restore buttons to manage multiple Word documents on screen

• Setting up your page orientation (portrait vs. landscape) for professional printing results

• Adjusting margins (top, bottom, left, right) to fit your needs

• Understanding and applying the gutter for binding documents like reports or manuals

• Why page setup is essential before typing, and how it saves time and improves quality

By the end of this lesson, you will confidently open Microsoft Word, set up your page with the correct orientation and margins, and prepare professional-looking documents ready for printing or sharing.

By the end of this lesson, you will confidently use your keyboard to type sentences, apply capitalization and punctuation correctly, and structure paragraphs in Microsoft Word like a true beginner-to-pro user.

Typing is the foundation of every Microsoft Word skill.

In this lesson, you’ll learn how to use your keyboard effectively so you can create and edit documents with confidence. We’ll cover the essential keys — Caps Lock, Shift, Tab, Enter, Backspace, and punctuation keys — and show you how they work together to improve your typing speed and accuracy.

Here’s what you’ll learn step by step:

• How to identify and use the Escape, Tab, Caps Lock, Shift, and Enter keys

• Switching between uppercase and lowercase letters using Caps Lock and Shift

• Typing sentences with correct capitalization, commas, apostrophes, and full stops

• Using the Backspace key to delete mistakes quickly and correctly

• Starting new paragraphs with the Enter key for clean formatting

• How to place the cursor for corrections without retyping everything

• Best practices for typing with both hands to increase speed and efficiency

• Writing short paragraphs in Microsoft Word for real-world typing practice

By the time you are done with this lesson, you will confidently use your keyboard to type sentences, apply capitalization and punctuation correctly, and structure paragraphs in Microsoft Word like a true beginner-to-pro user.

In this lesson, you will master key Microsoft Word formatting skills that transform your documents from plain text into polished, professional work.

Whether you are writing reports, newsletters, resumes, or academic papers, these techniques will give your work a clean, structured, and impressive look

.

? Here’s what you’ll learn step-by-step:

• How to create Drop Caps like those used in magazines and newspapers.

• How to align text (Left, Right, Center, and Justify) to give your pages professional balance.

• How to change text case instantly without retyping—sentence case, lowercase, uppercase, title case, and toggle case.

• How to create numbered lists and bullet points for clean organization of ideas, tasks, or data.

• How to quickly undo and redo actions to save time while editing.

These are foundational Word processing skills that every computer user must master. By the end of this lesson, you will be able to format your text with confidence and design documents that stand out.

By completing this lesson, you will gain the confidence to format documents professionally—whether it’s assignments, office reports, or creative writing projects—boosting both your efficiency and presentation skills.

Master powerful formatting tools in Microsoft Word to make your documents look polished and professional.

In this lesson, you’ll learn how to:

• Create and format columns for newsletters, reports, or magazines.

• Insert page numbers and understand the difference between numbering vs. page breaks.

• Use page breaks to control document layout.

• Adjust line spacing to fit more or less text on a page.

• Format professional forms with dotted lines, signature fields, and dates using tabs.

• Save documents in custom folders for better organization.

• Get introduced to objects in Word (tables, charts, clipart, shapes, text boxes).

These skills are essential for creating professional reports, CVs, academic papers, contracts, and business forms.

By the end of this lesson, you will confidently format complex documents with columns, page numbers, page breaks, line spacing, and professional forms—plus create and manage tables in Microsoft Word.

Mastering Microsoft Word formatting is one of the most valuable skills for students, professionals, and anyone preparing reports, assignments, or presentations. In this lesson, you’ll gain step-by-step skills that make your documents look polished, professional, and easy to read.

By the end of this lesson, you will:

• Insert and customize page numbers for reports, projects, and assignments.

• Use page breaks and section breaks to control document layout like a pro.

• Format text into columns for newsletters, resumes, or academic work.

• Create, edit, and customize tables to organize data clearly.

• Apply borders, shading, and styles to improve table presentation.

• Insert charts directly into Word to visualize student performance, sales, or research data.

• Customize chart titles, axis labels, and backgrounds for professional results.

By completing this lesson, you’ll confidently design Word documents with advanced formatting features — saving time, boosting productivity, and presenting work that stands out academically and professionally.

This practical, hands-on training will not only make your assignments and reports look professional, but also give you real-world skills you can apply immediately in the workplace or studies.

Transform your Microsoft Word documents into eye-catching designs using shapes, banners, grouping, and clipart.

This lesson shows you step by step how to go beyond plain text and create professional, creative layouts directly inside Word.

By the end of this lesson, you will confidently:

• Insert and format basic shapes to build creative designs.

• Apply textures, gradients, and patterns for polished effects.

• Draw and customize objects like tables, glasses, mats, and banners.

• Use the grouping feature to move and resize multiple objects together.

• Add text inside shapes and create custom banners with slogans or logos.

• Insert clipart in Word and adjust positioning with wrap text options.

• Resize, rotate, and layer images so they fit perfectly with your design.

• Combine clipart and shapes to create logos, covers, and professional graphics.

By completing this lesson, you will be able to design attractive layouts, banners, and graphics in Microsoft Word — boosting your creativity, presentation quality, and professional achievement.

This is a practical, hands-on lesson designed to spark creativity and help you see Microsoft Word as more than just a typing tool.

In this lesson, you’ll master Mail Merge in Microsoft Word — one of the most powerful tools for creating personalized letters, invitations, emails, and mass documents without repetitive typing.

Instead of writing dozens (or hundreds) of letters one by one, you’ll learn how to connect Word with a data source (like Excel or an address list) and automatically generate customized outputs.

Here’s what you’ll learn step by step:

• Creating a main document (letter or invitation) with placeholders for names, addresses, and dates

• Building and saving a data source with recipient details (names, addresses, interview dates, times, etc.)

• Inserting merge fields (First Name, Last Name, City, Country, Date, Time) into the letter correctly

• Adding a Greeting Line and Recipient Address Block for professional formatting

• Previewing letters for multiple recipients to ensure accuracy

• Merging the data source with the document to automatically create multiple personalized letters

• Editing individual merged documents and saving them for print or email

• Practical real-world application: how to create 50+ professional letters with just one template

By the end of this lesson, you will be able to confidently use Mail Merge in Microsoft Word to save time, reduce errors, and automate repetitive office tasks.

You’ll walk away from this lesson with the ability to create professional, customized letters and documents in minutes — a skill that will boost your efficiency, productivity, and confidence at work or school.

Master the foundation of Microsoft Excel by learning how to apply basic formulas that save time and make calculations effortless.

Whether you’re a beginner or refreshing your skills, this lesson walks you step by step through using Excel’s most common functions.

Instead of wasting time with manual math, you’ll discover how to let Excel do the work for you—boosting your speed, accuracy, and confidence in handling data.

What you’ll learn in this lesson:

• Inserting formulas directly into the Formula Bar

• Using the =SUM function to total rows and columns instantly

• Applying the =AVERAGE function to find quick averages

• Using =MIN and =MAX to identify smallest and largest values

• Understanding how Excel updates formulas automatically when data changes

• Organizing your data for clear, accurate results

• Practical examples you can use in office, school, or business projects

By the end of this lesson, you’ll confidently apply Excel formulas like SUM, AVERAGE, MIN, and MAX to perform quick, accurate calculations—building the essential skills that make you more productive and efficient in school, office, or business tasks.

In this hands-on lesson you'll move from manual arithmetic to Excel's built-in power: learn how to use Math & Trigonometric functions, Statistical functions and Logical counting functions to analyze student marks and other datasets — then visualize results with charts.

What you’ll learn (bullet highlights)

• Apply core Excel formulas: SUM, PRODUCT, POWER and manual formula construction.

• Use statistical functions: AVERAGE, MAX, MIN, MODE (MODE.SNGL), MEDIAN.

• Count and filter with COUNT and COUNTIF (examples: count marks <50, ≥75).

• Fix common formula errors, use autofill to apply formulas across rows.

• Create and format column charts to visualize performance quickly — add titles, move/resize charts.

• Practical step-by-step workflows for copying worksheets safely and working with real student marks.

By the end of this lesson you will be able to analyze student marks using Excel formulas (SUM, AVERAGE, MAX/MIN, COUNTIF) and create clear charts to present results — practical skills you can apply immediately at work or school.

Master Excel’s most powerful logical functions — IF, AND, and OR — to analyze data, set conditions, and make real-time decisions. In this lesson, you’ll learn step by step how to:

• Apply the IF function to automatically classify results (e.g., Qualified vs. Disqualified).

• Combine conditions with the AND function when multiple criteria must be met.

• Use the OR function to allow flexibility when only one condition needs to be true.

• Create practical, real-world scenarios such as selecting students for clubs, courses, or career paths based on exam scores.

• Avoid common formula errors by correctly using brackets, commas, and quotes.

This lecture emphasizes hands-on practice — from testing student qualifications to simulating college course eligibility — giving you confidence to handle real-life business, academic, and data analysis tasks in Excel.

By the end of this lesson, you will be able to confidently write, troubleshoot, and apply IF, AND, and OR formulas to solve real-world problems and make smarter data-driven decisions in Excel.

Learn how to design professional tables in Microsoft Access — the foundation of every powerful database.

In this lesson, you’ll get hands-on practice building student and staff tables, applying data types, setting primary keys, and adding attachments like photos. Perfect for beginners aiming to master database design step by step.

What you’ll learn in this lecture:

• How to create student and staff tables in Microsoft Access

• Applying the correct data types (text, number, date, currency, attachment)

• Setting primary keys for unique record identification

• Using AutoNumber fields to automatically count records

• Adding attachments (like student photos) into your tables

• Editing table structure with Design View and managing fields

• Best practices for organizing data for institutions and organizations

By the end of this lecture, you’ll confidently create well-structured Microsoft Access tables that serve as the backbone of any professional database.

In this hands-on lesson, you’ll discover how to create and customize Forms in Microsoft Access — one of the most essential tools for database management.

Unlike tables that display every record at once, forms allow you to view, enter, edit, and delete data one record at a time, making your workflow faster, cleaner, and less prone to mistakes.

You’ll learn step by step:

• The difference between fields, records, and data inside a table

• Why forms are critical for avoiding errors when updating records

• How to use the Form Wizard to create professional, user-friendly forms

• Adding new records through a form that automatically updates your database

• Editing and updating records safely without confusion

• Deleting records directly from a form and ensuring changes reflect in the table

• Opening forms in Design View to resize, rearrange, and customize layouts for a cleaner interface

• Best practices to make your forms visually clear, organized, and professional

By the end of this lesson, you’ll not only understand how to use Access forms but also be confident in building forms that make your databases easier to use and maintain.

After completing this lesson, you will be able to confidently create and customize forms in Microsoft Access to add, update, view, and manage records with professional accuracy — a crucial step toward becoming a skilled database manager.

Master how to search, filter, and extract specific records in Microsoft Access using primary keys and queries. In this lecture, you’ll learn step-by-step how to:

• Use unique fields (primary keys) like admission or staff numbers to instantly retrieve records.

• Create and design Select Queries to filter students by course, level, or fees.

• Run advanced criteria-based queries (e.g., names starting with J, fees above 70,000).

• Understand the difference between Select Queries and Action Queries.

• Build and run a Make Table Query to generate a new table from existing data.

• Apply queries in real-world scenarios for fast data retrieval and reporting.

Whether you’re managing students, staff, or organizational records, queries will save hours of manual work by pulling exactly the information you need. This lecture also introduces you to Action Queries—the foundation for deleting, updating, and copying tables in Access.

By the end of this lesson, you will confidently design and run Select Queries and Make Table Queries in Microsoft Access, giving you professional-level database management skills.

In this lesson, you’ll learn how to work with powerful Action Queries in Microsoft Access — specifically the Delete Query and the Append Query. Unlike Select Queries, which only display data, Action Queries perform changes directly on your tables, making them a critical tool for database administrators and analysts.

Here’s what you’ll master step by step:

• Delete Queries: Automatically remove multiple records at once without manually deleting row by row.

• Filtering records for deletion: Target specific records using criteria such as staff ID, name, or department.

• Append Queries: Copy and insert records from one table into another when both tables have a similar structure.

• Practical scenarios: Use Append Queries to restore deleted records or merge data from different tables.

• Design View techniques: Learn to drag fields, set query conditions, and run queries with precision.

• Error prevention: Understand why Action Queries don’t open like Select Queries and how to avoid accidental data loss.

• Security settings in Access: Enable content to ensure your queries run properly after reopening a database.

By the end of this lecture, you’ll have hands-on experience with two of the most important Action Queries in Microsoft Access, giving you the skills to clean, restore, and manage data like a professional.

After completing this lesson, you will confidently create and run Delete Queries and Append Queries in Microsoft Access to efficiently remove, restore, and manage records — a skillset highly valued in professional database management

In this final Microsoft Access lesson, you’ll master Update Queries and Report Creation, two of the most powerful tools for managing and presenting data professionally.

By the end of this lecture, you’ll not only know how to update hundreds of records in seconds but also how to generate polished reports that employers and organizations depend on for decision-making.

Here’s what you’ll learn step by step:

• ? Update Queries in Microsoft Access – Automate bulk updates, saving hours of manual work when departments, staff, or student data changes.

• ? Real-World Scenarios – Handle staff promotions, student course transfers, and inventory updates with a single click.

• ? Reports in Microsoft Access – Create structured, professional reports that highlight key data such as student records, financials, or organizational assets.

• ? Custom Report Design – Format, resize, and organize reports so that every detail is clear, accurate, and ready for printing.

By the end of this lesson, you’ll be able to:
✅ Maintain up-to-date databases without repetitive manual edits.

✅ Present professional, print-ready reports for managers, clients, or academic institutions.

✅ Prove your skills as someone who can transform raw data into organized knowledge.

By completing this lesson, you will achieve the ability to efficiently manage large-scale data updates and generate professional reports in Microsoft Access—skills that make you stand out in any modern workplace.

Master the practical essentials of Microsoft PowerPoint in this hands-on lesson.

You'll learn how to create slides that look professional and communicate clearly by inserting and editing charts, tables, SmartArt, images and video clips.

This lesson is built for beginners and busy professionals who want fast, repeatable skills for business presentations, training sessions, church services, classroom lessons and sales pitches.

What you’ll learn (step-by-step):

• Insert and edit charts (column, pie, clustered): link chart data, update labels and format axes.

• Add and format tables to present numeric or tabular data neatly on a slide.

• Use SmartArt to visualize processes, hierarchies and workflows (create org charts, pyramids, cycles).

• Embed images and video clips (how to insert, common troubleshooting tips, file-format best practices).

• Choose the right slide layout and place content inside placeholders for balanced, readable slides.

• Basic slide composition: bullet best practices, minimal text, and how to pair visuals + key points.

• Save and export presentations safely (file naming, save locations), so your work is protected and shareable.

Why this lesson helps you rank and convert:

• Uses long-tail, search-friendly keyword phrases like “insert charts in PowerPoint,” “SmartArt in PowerPoint,” and “embed video in PowerPoint presentation.”

• Focused on real tasks recruiters & employers search for — not just theory.

• Practical outcomes you can show immediately in a portfolio, training class or meeting.

Outcomes & benefits:

• Create 5+ polished slides using charts, tables and SmartArt in a single session.

• Embed short video clips and images to add motion and credibility to your slides.

• Produce presentation files ready for printing or projection.

After this lesson you’ll be able to build and export a professional PowerPoint slide deck with charts, tables, SmartArt and embedded media — ready to present, print or share.

Master the art of designing professional PowerPoint slides by learning how to create engaging slide backgrounds, gradient fills, textures, and placeholder designs that enhance visual impact.

In this lesson, you’ll also discover how to apply dynamic slide transitions, sound effects, and animations to captivate your audience.

Finally, you’ll learn how to present your slides manually or automatically, setting timings for seamless self-running presentations perfect for business, teaching, or marketing.

By the end of this lesson, you will be able to create visually stunning PowerPoint presentations with custom backgrounds, smooth transitions, and automated slide shows that impress any audience.

Learn how to save time and build polished presentations by mastering the PowerPoint Slide Master feature.

Instead of formatting each slide one by one, discover how to create a slide master template that automatically applies your chosen backgrounds, fonts, colors, and layouts to every slide.

This lesson shows you step by step how to design, save, and reuse templates so that all future presentations look consistent, professional, and visually engaging.

What you’ll learn in this lesson:

• How to open and use Slide Master view in PowerPoint

• Applying custom backgrounds, fonts, and colors across all slides

• Formatting placeholders (titles, text, bullet points) with uniform styles

• Saving your customized design as a PowerPoint template (POTX)

• Inserting new slides that automatically adopt your template formatting

• Building a quick product-pitch presentation using your saved master

Why this matters:

Slide Master templates are one of the most time-saving and career-boosting tools in Microsoft PowerPoint. Professionals, trainers, students, and entrepreneurs all need fast, consistent slide designs that impress audiences without spending hours on formatting.

By the end of this lesson, you will be able to design and save custom Slide Master templates in PowerPoint, making every presentation consistent, professional, and ready in minutes.

In this lesson, you’ll master how to create professional certificates and brochures using Microsoft Publisher.

Starting from inserting and formatting text boxes to applying background colors, aligning text, and customizing fonts, you’ll build a multi-school brochure that showcases courses such as Business, Education, Divinity, ICT, Engineering, Hospitality, Hairdressing & Beauty, Fashion & Design, and Building Technology.

You’ll also learn how to:

• Apply text formatting, bullets, and color coding for clarity.

• Insert and manage multiple text boxes for structured layouts.

• Use zooming, alignment, and spacing tools to polish your design.

• Create both certificates and multi-page brochures from scratch.

• Apply keyboard shortcuts (Ctrl+C, Ctrl+V, Ctrl+X, Shift+Arrows) for faster editing.

By the end of this lesson, you’ll have the ability to design professional-grade educational materials such as certificates, flyers, and multi-school brochures — skills highly valuable for academic institutions, training centers, and businesses.

After completing this lesson, you will be able to confidently design certificates and brochures in Microsoft Publisher that look professional, organized, and print-ready for real-world use.

In this lesson, you’ll master the process of designing a professional brochure in Microsoft Publisher.

From setting up text boxes and formatting colors to inserting images and aligning layouts, you’ll learn how to create visually striking and engaging brochures that showcase information clearly.

By following step-by-step instructions, you’ll gain practical skills to:

• Insert, resize, and format text boxes for clean brochure layouts

• Apply WordArt and background colors to make headings stand out

• Add, resize, and align images related to your content (e.g., education, technology, buildings)

• Use shapes, lines, and outlines to improve design structure and readability

• Organize information across multiple pages for a complete, professional brochure

By the end of this lesson, you will have designed a two-page, professional-quality brochure in Microsoft Publisher—perfect for advertising a school, business, or event with confidence and creativity.

Creating professional designs doesn’t have to be complicated.

In this lesson, you’ll learn how to design business cards and success cards in Microsoft Publisher — two practical projects that will boost your creativity and real-world design skills.

This step-by-step training will show you how to use Publisher templates, customize layouts, add borders, insert text, and apply backgrounds to create polished, print-ready cards.

By the end of this lesson, you will be able to:

• Open and edit Publisher templates for business cards.

• Customize fonts, colors, and layouts for a professional look.

• Add personal details (name, job title, contacts) in clear, attractive formats.

• Create success cards from scratch using text boxes, borders, shapes, and word art.

• Insert clipart, apply gradients, and combine creative elements for unique designs.

• Save, print, and prepare cards for real-life use.

By completing this lesson, you will confidently design business and success cards in Microsoft Publisher — a skill you can use for personal branding, professional networking, or inspiring others with creative success messages.

In this lesson, you’ll learn how to design custom calendars in Microsoft Publisher — a practical project that combines creativity with real-world applications. Whether you’re creating a one-year-per-page calendar or a 12-page monthly calendar, you’ll gain step-by-step skills that can be applied to personal use, business promotions, or organizational branding.

Here’s what you’ll master in this lesson:

• Opening and customizing Publisher calendar templates.

• Choosing between portrait or landscape orientations.

• Designing both one-year-per-page and one-month-per-page calendars.

• Adding images, company logos, and branding elements.

• Formatting fonts, colors, and outlines for a polished look.

• Inserting promotional messages, services, and contact details.

• Saving, exporting, and preparing calendars for real-world distribution.

By completing this lesson, you will confidently design and customize calendars in Microsoft Publisher — a versatile skill you can use for business advertising, organizational projects, or personal creativity.

Discover how to unlock the world’s knowledge by taking advantage of internet.

In this lecture, you’ll learn how to maximize your time—even while traveling—by accessing powerful audio lessons, video tutorials, and building new skills on demand in virtually any filed of interest

You’ll uncover how YouTube can be your free classroom, providing everything from computer training to personal development insights.

By the end of this lecture, you will:

• Leverage YouTube as a free learning hub for skills, software, and self-improvement.

• Maximize downtime during travel or waiting by turning it into productive study time.

• Apply practical skills from bestselling books to influence, connect, and succeed.

By the end of this lesson, you will confidently access and use free digital resources—turning wasted hours into learning opportunities that accelerate your career, studies, and personal growth.