Course Curriculum

Introduction 00:03:00
Getting started on Windows, macOS, and Linux 00:01:00
How to ask great questions 00:01:00
FAQ’s 00:01:00
Excel Overview 00:06:00
Start Excel Spreadsheet 00:04:00
Enter Text and Numbers 00:07:00
Relative References 00:04:00
Working with ranges 00:07:00
Save and Save as Actions 00:08:00
File Extensions, Share, Export, and Publish files 00:07:00
Adding Rows and Columns 00:03:00
Modifying Rows and Column lengths 00:06:00
Copy, Cut, and Paste 00:07:00
Copying Formulas 00:03:00
Page setup options 00:07:00
Fit to print on One Page 00:03:00
Print Workbooks 00:03:00
Sorting Data Ascending Order 00:04:00
Sorting Data Descending Order 00:02:00
Filter Data 00:04:00
Creating Basic Formulas 00:06:00
Datetime Formulas 00:06:00
Mathematical formulas phase1 00:20:00
Mathematical formulas phase2 00:12:00
VLOOKUP formula 00:12:00
HLOOKUP formula 00:04:00
XLOOKUP 00:08:00
Handling #NA and Approximates match in XLOOKUP 00:11:00
Split Text into columns 00:07:00
Flash Fill 00:07:00
Data Validation 00:07:00
Remove Duplicates 00:08:00
Import Data from Text files 00:07:00
Import Data from .CSV files 00:03:00
Formatting Font 00:04:00
Formatting Alignment 00:06:00
Formatting Numbers 00:05:00
Formatting Date 00:03:00
Formatting Tables 00:02:00
Pivot Tables 00:07:00
Pivot Charts 00:02:00
Excel Charts – Categories 00:03:00
Elements of a chart 00:04:00
Creating Charts 00:02:00
Column or Bar charts 00:04:00
Formatting Charts 00:02:00
Line Charts 00:02:00
Pie and Doughnut charts 00:04:00
Overview 00:04:00
Start PowerPoint Presentation 00:05:00
Screen setting and Views 00:05:00
Presentation Tips and Guidelines 00:06:00
Creating a New Presentation 00:04:00
Working with Slides 00:04:00
Save a Presentation 00:04:00
Print Slides 00:03:00
Formatting Text 00:06:00
Slide Text Alignments 00:03:00
Multi-Column Text Alignments 00:02:00
Adding Bullets and Numbered List Items 00:03:00
Insert Shapes 00:03:00
Insert Icons 00:03:00
Insert Graphics 00:04:00
Add 3D Models 00:03:00
Insert Pictures 00:03:00
Picture Options 00:04:00
Picture Cropping 00:03:00
Applying Built-in Picture Styles 00:04:00
Add SmartArt Graphic 00:03:00
Modifying SmartArt 00:03:00
Creating a Target Chart using SmartArt 00:03:00
Create a Table on Slide 00:04:00
Formatting Tables 00:06:00
Inserting Tables 00:02:00
Table Layouts 00:01:00
Add a Chart 00:02:00
Formatting charts 00:04:00
Insert Chart from Microsoft Excel 00:03:00
Adding Video to a Presentation 00:03:00
Adding Audio to a Presentation 00:02:00
Screen Recording and Adding 00:02:00
Applying Transitions to Presentation 00:04:00
Object Animation 00:03:00
Effect Options 00:02:00
Advanced Animation 00:02:00
Triggers to control animation 00:02:00
Onscreen Presentation 00:02:00
Hiding Slides 00:02:00
Changing Order of Slides 00:02:00
Copying Slides 00:02:00
Overview of MS Word 00:04:00
Start MS Word 2021 00:05:00
Create a new blank document 00:04:00
Creating a paragraph text 00:05:00
Non-printing characters 00:03:00
Save a document 00:03:00
Open a document 00:01:00
Find and replace 00:04:00
AutoCorrect options 00:03:00
Formatting text 00:04:00
Copy cut and paste 00:04:00
Character formatting 00:02:00
Work with numbers 00:02:00
Add bullets 00:03:00
Outline creation 00:04:00
Creating a table 00:03:00
Adding rows and columns to a table 00:02:00
Formatting table data 00:02:00
Borders and shading 00:02:00
Sorting in a table 00:04:00
Draw a table 00:04:00
Convert text to table 00:03:00
Convert table to text 00:02:00
Insert a spreadsheet 00:02:00
Quick tables – readily available formats 00:02:00
Working with styles 00:02:00
Creating styles 00:02:00
Clear formatting 00:01:00
Margins 00:02:00
Orientation 00:01:00
Page size setting 00:01:00
Adding columns 00:03:00
Page break – section break 00:02:00
Adding watermark 00:03:00
Headers and footers 00:03:00
Create envelops 00:02:00
Creating labels 00:02:00
Creating a mail merge document 00:03:00
Thesaurus and spell check 00:01:00
Word count 00:01:00
Speech – read aloud 00:01:00
Language – translate 00:01:00
Tracking 00:01:00
Obtain Your Certificate 00:00:00
Leave a Feedback! 00:00:00

Course Overview 

Microsoft Office Skills is one of the most in-demand qualifications you can add to your CV, and it’s easy to see why. Nearly every office job in the UK relies on it, from admin roles to management positions, which makes strong Microsoft Office skills a real asset in almost any career.

This course takes you through Excel and PowerPoint step by step, starting with the basics and building up to more advanced techniques. In Excel, you’ll learn how to enter data, write formulas, sort and filter information, and create pivot tables and charts that make sense of numbers at a glance. You’ll even cover XLOOKUP, one of the newest and most useful formulas around. Moving into PowerPoint, you’ll discover how to design slides, add graphics, insert charts, and bring presentations to life with animation and transitions.

By the end, you’ll have practical, job-ready Microsoft Office skills you can use straight away, whether you’re applying for a new role or aiming to work more efficiently in your current one.

Learning Outcomes

  • Navigate spreadsheets confidently and enter, sort and filter data with ease
  • Write formulas and functions, including lookups, to solve everyday number problems
  • Build pivot tables and charts that turn raw data into clear insights
  • Format tables, cells and documents so your work looks polished and professional
  • Design engaging slide presentations using text, graphics, images and SmartArt
  • Add multimedia, transitions and animation to make presentations more memorable
  • Apply Microsoft Office tools across Excel and PowerPoint to boost workplace productivity

Your Benefits by Learning with ‘Cambridge Open Academy’:

  • Accreditation: Showcase your ability with our accredited Microsoft Office Skills: Mastering Excel, PowerPoint to potential employers.
  • Free Certificate: Get a Free Digital Certificate upon successful completion of the Microsoft Office Skills: Mastering Excel, PowerPoint.
  • Flexibility: Learn virtually from anywhere, anytime at your own pace and convenience.
  • Advance Your Career: Upskill to impress your employers and land your dream job or long-awaited promotion.
  • Immediately Applicable Coursework: Keep up with the latest skill trend by putting your skillsets to work.
  • Affordability: Save big with our online Microsoft Office Skills: Mastering Excel, PowerPoint as it not only suits your professional needs but also fits within your budget.
  • Tutor Support: Get tutor support on weekdays, 9-5 am, and our dedicated 24/7 customer support.
  • Lifetime Access: Achieve lifetime access to the top-notch expertly crafted course materials.

Our Specialised Delivery Method:

  • Interactive Learning Materials: The course modules were created using an EdTech industry-recognised tool to keep you engaged at all times. With this tool, you get interactive, engaging and top-notch course content. In our courses, you can take advantage of features like—
    • Drop Down Menu
    • Drag and Drop
    • Flash Card
    • Label Graphic
    • Timeline View
  • Responsiveness: In light of contemporary mobile and point-of-need learning trends, our courses are designed to be intrinsically dynamic and provide you the ultimate eLearning solution. These courses will adapt to any gadget without any extra software.
  • Learner-Friendly Navigation: Our courses are also quite simple to navigate for any learner. These courses are designed with simplicity and a modern flow that appeals to a wide range of learning audiences, regardless of their technical background and gadgets.
  • Elegant Outline: Our courses are visually appealing, where you can —
    • Track your progress on the left-side navigation toolbar.
    • Engage in drag-and-drop sorting activities and use the multiple response question to test your understanding of course topics.

With your newly acquired skills from this course can help you

  • Increase Your Hireability.
  • Make Yourself a Valuable Asset
  • Get Your Long-awaited Promotion.
  • Boost Your Pay-scale
  • Better Your Productivity

Certification:

Upon successful completion of the Microsoft Office Skills: Mastering Excel, Word, PowerPoint, IT, & Cyber Security course, you have the opportunity to obtain a PDF certificate for just £4.99, providing tangible evidence of your remarkable achievement.

Note: Delivery of hardcopy certificates is free within the United Kingdom. However, to obtain a hardcopy certificate, International students will have to pay additional fees based on their location.

Who is this course for?

This Microsoft Office Skills: Mastering Excel, PowerPoint course is developed for people who wish to excel in their professional and personal life. Learn from industry leaders and interact with a global network of experts by enrolling in this Microsoft Office Skills: Mastering Excel, PowerPoint course.

Requirements

Enrolling in our Microsoft Office Skills: Mastering Excel, PowerPoint course does not require any prior knowledge or experience. All that is required is an internet-connected gadget and a passion to learn.

Career Path

  • Administrative Assistant / Office Administrator: Provides daily administrative support using Word, Excel, Outlook, and PowerPoint for document preparation, scheduling, data entry, correspondence, and office coordination.
    Salary: £22,000 – £30,000 per year (average around £24,000 – £28,000).
  • Executive Assistant / Personal Assistant (PA): Supports senior managers or executives with advanced diary management, report creation, presentations, travel arrangements, and confidential document handling using the full Microsoft Office suite.
    Salary: £28,000 – £45,000 per year (higher in London).
  • Data Entry Clerk / Excel Specialist: Manages large datasets, creates spreadsheets, performs data analysis with formulas and pivot tables, generates reports, and maintains accurate records using advanced Excel features.
    Salary: £22,000 – £32,000 per year.
  • HR Administrator: Handles employee records, onboarding documentation, payroll support, recruitment admin, and HR reports primarily using Excel, Word, and Outlook for tracking and compliance.
    Salary: £24,000 – £35,000 per year.
  • Project Coordinator / Support Officer: Assists project teams with planning documents, status reports, resource tracking in Excel, PowerPoint presentations, and stakeholder communications using Microsoft Office tools.
    Salary: £28,000 – £40,000 per year.
  • Office Manager / Team Administrator: Oversees office operations, manages administrative teams, prepares management reports and presentations, budgets in Excel, and optimises processes with Microsoft Office proficiency.
    Salary: £32,000 – £48,000+ per year (higher with experience or in London).

Certification:​

Once you have successfully completed this course, you can order a certificate as proof of your achievement.

A PDF certificate is available for £5.99. You can also request a hardcopy certificate for £9.99.

Delivery of the hardcopy certificate is free within the United Kingdom. For international learners, an additional delivery charge will apply based on the destination country.

review-star

I have studied a few courses and have…

I have studied a few courses and have found the whole experience quick and efficient, and believe the courses will help contribute to my job in the Healthcare. Fabulous!

review-star

A clear and concise course

This self-paced course delivers clear, high-quality content on political science fundamentals, ideal for beginners. It builds confidence in key topics like political theory, institutions, the British constitution and Parliament, US government, elections, and doctrines (liberalism, anarchism, conservatism, nationalism). The flexible format fits busy schedules. Highly recommended for aspiring international relations professionals seeking internships or jobs—it broadens knowledge and strengthens foundational skills.