• Your Full Name (required)

    This field can be seen by: Everyone

  • Phone

    This field can be seen by: Everyone Change

    Who can see this field?
    Close
  • Register

Microsoft Office Skills: Mastering Excel, PowerPoint

£25.00 ex Vat

Teacher

Category:

  • Business & Marketing
4.6( 7 REVIEWS )
68 STUDENTS
Microsoft Office Skills: Mastering Excel, Word, PowerPoint, IT, & Cyber Security

Welcome to the comprehensive course on Microsoft Office Skills: Mastering Excel and PowerPoint! This course is designed to help you navigate and master the essential features of Microsoft Office, focusing specifically on Excel 2021 and PowerPoint 2021.

You’ll start by getting acquainted with the fundamental aspects of Microsoft Office. In Excel, you’ll delve into the basics, exploring rows, columns, and cells. You’ll learn effective data handling techniques, how to set up and print pages, and the intricacies of sorting and filtering. As you advance, you’ll uncover the secrets of writing and understanding formulas, including advanced formulas, and specifically the XLOOKUP function available in Excel 2021 and Office 365.

The course will guide you through data tools, formatting data and tables, and creating pivot tables to summarise your data efficiently. You’ll also become proficient in generating various charts to visually represent your data, making your presentations and reports more impactful.

Transitioning to PowerPoint 2021, you’ll start with an introduction to its features, then move on to mastering the basics. You’ll explore text and bullet options, and learn how to enhance your presentations by adding graphic assets.

By the end of this course, you’ll have a thorough understanding of Microsoft Office, especially Excel and PowerPoint. Whether for personal or professional use, these skills will help you create, manage, and present your data effectively. Join us and unlock the full potential of Microsoft Office!

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

Participants in the Microsoft Office Skills: Mastering Excel, PowerPoint course are revolutionizing the professional landscape, propelling their careers forward, and enhancing their livelihoods across the globe. This sought-after course is empowering learners to forge new employment opportunities, advance within their respective industries, and experience substantial personal growth.

Section 01: Getting Started
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
Section 02: Excel 2021: Basics
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
Section 03: Excel 2021: Rows, Columns, and Cells
Adding Rows and Columns 00:03:00
Modifying Rows and Column lengths 00:06:00
Section 04: Excel 2021: Data Handling
Copy, Cut, and Paste 00:07:00
Copying Formulas 00:03:00
Section 05: Excel 2021: Page Setting Up and Print
Page setup options 00:07:00
Fit to print on One Page 00:03:00
Print Workbooks 00:03:00
Section 06: Excel 2021: Sorting and Filtering
Sorting Data Ascending Order 00:04:00
Sorting Data Descending Order 00:02:00
Filter Data 00:04:00
Section 07: Excel 2021: Writing Formulas
Creating Basic Formulas 00:06:00
Datetime Formulas 00:06:00
Mathematical formulas phase1 00:20:00
Mathematical formulas phase2 00:12:00
Section 08: Excel 2021: Advanced Formulas
VLOOKUP formula 00:12:00
HLOOKUP formula 00:04:00
Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365
XLOOKUP 00:08:00
Handling #NA and Approximates match in XLOOKUP 00:11:00
Section 10: Excel 2021: Data and Tools
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
Section 11: Excel 2021: Formatting data and tables
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
Section 12: Excel 2021: Pivot Tables
Pivot Tables 00:07:00
Pivot Charts 00:02:00
Section 13: Excel 2021: Charts
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
Section 14: PowerPoint 2021: Course Introduction
Overview 00:04:00
Start PowerPoint Presentation 00:05:00
Screen setting and Views 00:05:00
Section 15: PowerPoint 2021: Basics
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
Section 16: PowerPoint 2021: Text and Bullet Options
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
Section 17: PowerPoint 2021: Adding Graphic Assets
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

Certification:​

Once you have successfully completed this course, you will receive a PDF certificate completely free of cost as a proof of your accomplishment. The hardcopy certificate is also available for the cost of £9.99.
Note: Delivery of hardcopy certificate is free within the United Kingdom. However, to obtain a hardcopy certificate, International students will have to pay additional fees based on their location.


  • £25.00 ex Vat
  • 1 year
  • Number of Units66
  • Number of Quizzes0
  • 5 hours, 24 minutes
68 STUDENTS ENROLLED
£11 /Unit Price
£110
Quantity:

Buying more than one of the same courses?

  • 45% discount for orders of 10+ courses
  • 55% discount for orders of 50+ courses
  • 65% discount for orders of 100+ courses

Looking for a more personalised package?

contact us now

Awarded By



Oops! We could not locate your form.