-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Mastering Microsoft Office: Word, Excel, PowerPoint, and 365
Mastering Microsoft Office: Word, Excel, PowerPoint, and 365
£29 ex Vat
Take This Course OR
1 Year Access 
Advanced
12 Students -
8 hours, 27 minutes
Course Overview
Become a trained professional from the safety and comfort of your own home by taking Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 . Whatever your situation and requirements, One Education can supply you with professional teaching, gained from industry experts, and brought to you for a great price with a limited-time discount.
One Education has been proud to produce an extensive range of best-selling courses, and Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is one of our best offerings. It is crafted specially to promote easy learning at any location with an online device. Each topic has been separated into digestible portions that can be memorised and understood in the minimum of time.
Teaching and training are more than just a job for the staff at One Education; we take pride in employing those who share our vision for e-learning and its importance in today’s society. To prove this, all learning materials for each course are available for at least one year after the initial purchase.
All of our tutors and IT help desk personnel are available to answer any questions regarding your training or any technical difficulties.
By completing Mastering Microsoft Office: Word, Excel, PowerPoint, and 365, you will have automatically earnt an e-certificate that is industry-recognised and will be a great addition to your competencies on your CV.
Whatever your reason for studying Mastering Microsoft Office: Word, Excel, PowerPoint, and 365, make the most of this opportunity from One Education and excel in your chosen field.
Please be aware that there are no hidden fees, no sudden exam charges, and no other kind of unexpected payments. All costs will be made very clear before you even attempt to sign up.
Course Benefits
- Learning experience gained rapidly in related fields
- Quick assessment and guidance for all assignments
- Certificate for proof of acquired skills and knowledge
- Freedom to study in any location and at a pace that suits you
- Support from dedicated tutors committed to online learning
Will I receive a certificate of completion?
After successfully completing this course, you will qualify for the CPD Certificate from One Education as proof of your continued expert development. Certificate is available in PDF format, at the cost of £9, or a hard copy can be sent to you via post, at the cost of £15.
Why Study This Course
It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.
The Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.
Course Curriculum
| 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:06: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:04: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 | ||
| Section 18: PowerPoint 2021: Picture Formatting | |||
| Picture Options | 00:04:00 | ||
| Picture Cropping | 00:03:00 | ||
| Applying Built-in Picture Styles | 00:04:00 | ||
| Section 19: PowerPoint 2021: SmartArt Graphics | |||
| Add SmartArt Graphic | 00:03:00 | ||
| Modifying SmartArt | 00:03:00 | ||
| Creating a Target Chart using SmartArt | 00:03:00 | ||
| Section 20: PowerPoint 2021: Working with Tables | |||
| Create a Table on Slide | 00:04:00 | ||
| Formatting Tables | 00:02:00 | ||
| Inserting Tables | 00:02:00 | ||
| Table Layouts | 00:01:00 | ||
| Section 21: PowerPoint 2021: Working with Charts | |||
| Add a Chart | 00:02:00 | ||
| Formatting Charts | 00:02:00 | ||
| Insert Chart from Microsoft Excel | 00:03:00 | ||
| Section 22: PowerPoint 2021: Adding Multimedia | |||
| Adding Video to a Presentation | 00:03:00 | ||
| Adding Audio to a Presentation | 00:02:00 | ||
| Screen Recording and Adding | 00:02:00 | ||
| Section 23: PowerPoint 2021: Working with Transition | |||
| Applying Transitions to Presentation | 00:04:00 | ||
| Section 24: PowerPoint 2021: Animation | |||
| Object Animation | 00:03:00 | ||
| Effect Options | 00:02:00 | ||
| Advanced Animation | 00:02:00 | ||
| Triggers to control animation | 00:02:00 | ||
| Section 25: PowerPoint 2021: Slideshow Effects | |||
| Onscreen Presentation | 00:02:00 | ||
| Hiding Slides | 00:02:00 | ||
| Changing Order of Slides | 00:02:00 | ||
| Copying Slides | 00:02:00 | ||
| Section 26: Word 2021: Introduction | |||
| Overview of MS Word | 00:04:00 | ||
| Start MS Word 2021 | 00:05:00 | ||
| Section 27: Word 2021: Basics | |||
| 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 | ||
| Section 28: Word 2021: Word Formatting | |||
| AutoCorrect options | 00:03:00 | ||
| Formatting text | 00:04:00 | ||
| Copy cut and paste | 00:04:00 | ||
| Character formatting | 00:02:00 | ||
| Format painter | 00:04:00 | ||
| Work with numbers | 00:02:00 | ||
| Add bullets | 00:03:00 | ||
| Outline creation | 00:04:00 | ||
| Section 29: Word 2021: Tables | |||
| 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 | ||
| Section 30: Word 2021: Styles | |||
| Working with styles | 00:02:00 | ||
| Creating styles | 00:02:00 | ||
| Clear formatting | 00:01:00 | ||
| Section 31: Word 2021: Page Layout | |||
| 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 | ||
| Section 32: Word 2021: Envelops and Lables | |||
| Create envelops | 00:02:00 | ||
| Creating labels | 00:02:00 | ||
| Section 33: Word 2021: Mail Merges | |||
| Creating a mail merge document | 00:03:00 | ||
| Section 34: Word 2021: Review and Printing | |||
| 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 | ||
| Order Your Certificate | |||
| Order Your Certificate Now | 00:00:00 | ||
Related Courses
Important Links
- Affiliate
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add