Career Consultations
One-on-one guidance to define goals and explore the right career path.
Certificate Course
Computer Applications in Business
Duration
120 Hours
No. of Lessons
6 Lessons
Delivery
Self-Paced Learning
Credential
Certificate on Completion
Course Overview
Hands-on, self-paced mastery of the core Microsoft 365 apps used in modern offices: Word, Excel, PowerPoint, Access, Outlook, and Calendar/related collaboration tools. Learners’ complete workplace-style tasks, build a small portfolio, and validate skills through short quizzes and a final MCQ.
Course Learning Outcomes
By the end, learners can
- Produce accessible, professional documents in Word (styles, sections, mail merge).
- Analyze data in Excel (cleaning, formulas, lookups, PivotTables, charts, what-if tools, Power Query).
- Build brand-consistent presentations in PowerPoint (Slide Master, data visuals, Presenter View).
- Design a simple relational database in Access (tables/keys, queries, forms, reports, basic macros).
- Manage communication in Outlook (search, rules, Quick Steps, signatures, cloud links).
- Schedule effectively with Calendar (recurrence, time zones, sharing/delegation, meeting etiquette).
- Collaborate via OneDrive/SharePoint (co-authoring, permissions, versioning).
Course Outline
Lesson 1: MS Word
Objectives: styles & templates; document structure; mail merge; review & protection; accessibility & PDF.
Key topics: Styles/Themes, headers/footers, section breaks, tables & images, TOC/captions, Track Changes, Mail Merge, Accessibility Checker.
Major activity: 2-page letter on branded template + mail merge to PDF.
Assessment: 8-item quiz + accessibility checkpoint.
Lesson 2: MS Excel
Objectives: data cleanup; core formulas & lookups; conditional formatting; charts; PivotTables; what-if; Power Query basics.
Key topics: cell references, ranges/tables, XLOOKUP/INDEX-MATCH, Data Validation, chart types, Pivot table/chart, Scenario/Goal Seek, Power Query.
Major activity: KPI sheet with PivotChart & slicers; small ETL with Power Query.
Assessment: 8-item quiz + accessibility checkpoint (alt text on charts, color contrast).
Lesson 3: MS PowerPoint
Objectives: Slide Master & theme; visual clarity; data visuals & media; Presenter View; export & accessibility.
Key topics: Slide Master, layout variants, typography/contrast, charts from Excel, transitions/animations (use sparingly), presenter tools.
Major activity: 8–10-slide persuasive deck with branded master, embedded chart, speaker notes.
Assessment: 7-item quiz + accessibility checkpoint (reading order, alt text).
Lesson 4: MS Access
Objectives: design relational schema; build queries; create forms/reports; simple macros; import/link external data.
Key topics: tables/keys, relationships & integrity, select/totals/crosstab queries, forms & subforms, grouped reports, UI/data macros, Compact & Repair.
Major activity: Customers–Orders database: relationships, queries, form/subform, grouped report to PDF.
Assessment: 8-item quiz + reliability checkpoint (indexes/relationships).
Lesson 5: MS Outlook
Objectives: search & triage; professional composition; signatures & templates; cloud links vs attachments; tasks & rules.
Key topics: search operators, categories/flags, Rules & Quick Steps, signatures, sharing files from OneDrive, archiving & cleanup.
Major activity: Rule set + monthly briefing invite with linked files and template signature.
Assessment: 7-item quiz + etiquette checkpoint (bcc, clarity, accessibility).
Lesson 6: Calendar & Other Applications
Objectives: create meetings with recurrence/time zones; Scheduling Assistant; sharing/delegates; security & etiquette.
Key topics: appointments vs meetings, permissions, online meeting links, sensitivity labels, time-zone handling.
Major activity: Team review workflow—store files in OneDrive, co-author, schedule/host review meeting.
Assessment: 6-item quiz + security checkpoint.
Career Path
This certificate prepares learners for entry-level office, administration, customer service, and business support roles across multiple industries.
Graduates can apply Microsoft 365 skills in document creation, data handling, presentations, email communication, scheduling, and workplace collaboration.
Possible roles include
- Administrative Assistant
- Office Assistant
- Office Support Staff
- Customer Service Representative
- Business Support Associate
- Data Entry Clerk
- Reception / Front Desk Coordinator
- Sales & Service Support Assistant
- Operations Assistant
- Junior Office Coordinator
- Scheduling Assistant
- Microsoft Office Support Assistant
Skills Employers Value
This certificate is designed around real workplace expectations, focusing on practical Microsoft 365 and office productivity skills employers look for in entry-level and support roles.
- Professional communication
- Administrative efficiency
- Document preparation and formatting
- Data handling and reporting
- Presentation and communication skills
- Email, calendar, and scheduling management
- Digital workplace readiness
- Team collaboration using cloud tools
- Problem-solving and adaptability
Learning Experience
How You Learn
- Short, focused training modules
- Self-paced learning structure
- Practical, workplace-based activities
- Hands-on practice with Microsoft 365 apps
- Skill application through quizzes and projects
- Portfolio-building assignments
- Flexible learning for adult learners
Who is This Course For
Is This Right for You?
This certificate may be a good fit if you:
- Want to start or restart your career
- Want to transition into office or business support roles
- Need practical Microsoft Office skills
- Are returning to education after a break
- Are looking for job-ready digital workplace skills
- Need short-term upskilling for employment
- Want to improve document, spreadsheet, email, and presentation skills
Why Choose Liberty College
Career-Focused Training You Can Trust
- Practical, employer-aligned learning
- Flexible training pathways
- Career support and guidance
- Internship and workplace exposure (where applicable)
- Funding eligibility assistance
- Focus on job readiness and real outcomes
Need Immediate Assistance?
Let's talk about your
funding options & career goals
Call Us
+1 (226) 667-0808
Send Email
info@libertycollege.ca
Your Journey to Employment Starts Here
Career Planning & Employment Support
Our team supports students throughout their learning journey and helps them prepare for employment after graduation.
Resume Development Guidance
Build a strong resume that highlights your skills, training, and experience.
Interview Preparation
Practice mock interviews and learn how to present yourself with confidence.
Internship Readiness Support
Get prepared for workplace expectations before starting your internship.
Career Development Resources
Access tools to improve communication, etiquette, and career skills.
Employment Preparation
Support to help you transition smoothly from studies to employment.
Getting Started
Not Sure Where to Start? Let's Map It Out Together
Explore your funding options, find the right program, and take your next step with confidence — at a pace that works for you.
STEP - 01
Explore Funding Options
Explore available funding opportunities and understand the support programs that may be available to you.
STEP - 02
Connect With Our Team
Speak with our team to ask questions, talk through your goals, and get personalized guidance.
STEP - 03
Choose Your Program
Discover career-focused diploma programs designed to help you build practical skills for today's job market.
STEP - 04
Train for Your Future
Complete your training, gain practical skills through your work-integrated internship, and prepare for your next career opportunity.
Funding Support
Explore Your Funding Options
Most adult learners put their goals on hold assuming they have to pay for retraining entirely out of pocket. The reality is different. Financial assistance is available through multiple government and workforce programs to help cover your expenses. You don't have to figure it out alone.
Your Potential Pathways to Funding
NEED HELP DECIDING?
Not Sure Which Program Is Right for You?
Choosing a program is a big step, and you do not have to figure it out alone. Our team can help you explore your options based on your interests, goals, and background. We will also walk you through the funding pathways that may be available to you, so cost is part of the conversation from the start. The guidance is free, with no pressure to commit.
Our Address
285 King St, Suite 400, London, ON N6B 3M6
Call us Monday to Friday, 8:30 AM – 5:00 PM
Send E-Mail
Take the First Step Toward Your New Career
YOUR FUTURE STARTS HERE
Take the Next Step Toward a New Career in
London, Ontario Job Market
Free. No obligation. Personalized Guidance.
FAQ
Frequently Asked
Questions
-
Do I qualify for funding?Eligibility depends on your personal circumstances and the specific funding program. We recommend speaking with our team to explore which options may apply to you.
-
What is Better Jobs Ontario?Better Jobs Ontario is a government-supported program that may help eligible individuals access funding for approved training programs to start or change their career.
-
How long are the diploma programs?Our diploma programs typically range from 25 to 64 weeks depending on the program. Please contact our admissions team for specific program durations.
-
What's included in the internship?Our internship component provides real-world workplace experience in your field of study, helping you build confidence, professional connections, and practical skills before graduation.
-
Do I need experience to apply?No prior experience is required for most programs. Our programs are designed to build skills from the ground up for career changers and new learners.