Skip to content

Microsoft : Microsoft 365

Boste Your office skills with Microsoft|Free Microsoft 365 Office Suite Subscription ||Free PDF & Hardcopy Certificate


One Education

Summary

Price
£6,999 inc VAT
Or £583.25/mo. for 12 months...
Study method
Online
Duration
97 hours · Self-paced
Access to content
12 months
Qualification
No formal qualification
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

Overview

If you want to gain a solid understanding of Microsoft 365 and fast track your dream career, then take a step in the right direction with this industry-standard, comprehensive Microsoft 365 bundle designed by expert instructors.

What you will get:

  • Microsoft 365 Office Suite Yearly Subscription
  • 19 accredited courses worth £600
  • 5 QLS-Endorsed Certificates worth £800
  • 20 IAO Accredited Certificates, both in PDF and Hardcopy format (sent straight to your doorstep) worth £192
  • Free 5 Premium Courses
  • Free student ID

This Microsoft 365 bundle package includes:

  • Complete Microsoft Outlook - CPD Approved
  • MS Teams - Master Microsoft Teams
  • The Complete Microsoft OneDrive Course
  • MS Word Advanced
  • Advanced PowerPoint
  • Animations with PowerPoint
  • Advanced Diploma in MS Excel
  • MS Excel: Master Power Query in 120 Minutes!
  • MS Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
  • MS Excel: Excel Sheet Comparison with VBA
  • New Functions in MS Excel 2021
  • MS Access for Beginners
  • MS Access Databases Forms and Reports
  • MS Access Tables and Queries

Free Courses to enhance your office skills

  • Virtual Meeting Training
  • Using Zoom Meeting Effectively
  • Learn to Master Google Docs
  • Effective Communication with Better Email
  • Effective Communication Skills

Dedicated tutor support and 24/7 customer support are available to all students with this premium quality Microsoft 365 bundle. Get the help you require and the answers to all your queries throughout the comprehensive syllabus of this Microsoft 365 bundle.

This premium online course titled Microsoft 365 ensures your professional development with IAO accreditation. You’ll have the privilege of learning in your own time, at your own pace and earning accredited certificates.

Course media

Description

This Microsoft 365 bundle is developed by industry experts and is packed with several insightful modules to properly understand Microsoft 365 and allow you to accelerate your career.

Curriculum

The Curriculum of the Microsoft 365 bundle is given below:

***Complete MS Outlook - CPD Approved***

  • Getting Started
  • Opening and Closing Outlook
  • Understanding the Interface
  • Working with the Message List and the Reading Pane
  • Using Message List Commands
  • Creating a New Email
  • Managing Email
  • Searching for Items
  • An Introduction to the Calendar
  • An Introduction to Tasks
  • An Introduction to Contact
  • Wrapping Up

***MS Teams - Master MS Teams***

  • MS Teams - Introduction
  • Mastering MS Teams
  • Top MS Teams Tips

***The Complete Microsoft OneDrive Course**

  • You Can Master OneDrive
  • OneDrive Functions and Interface
  • MS Word OneDrive
  • MS Word Project and Tables Practice
  • MS Excel OneDrive
  • MS Excel Practice
  • MS PowerPoint OneDrive
  • MS PowerPoint Practice
  • Other Apps in OneDrive and Settings
  • Create Powerful Password for Your Account

***MS Word Advanced***

  • Manipulating Images
  • Using Custom Graphic Elements
  • Collaborating on Documents
  • Adding Document References and Links
  • Securing a Document
  • Using Forms to Manage Content
  • Automating Repetitive Tasks with Macros

***Advanced PowerPoint***

  • Overview and Workspace
  • The File Menu – Export Command
  • The File Menu – Options Sub Menu
  • Adding Sections
  • Using Smart Art
  • Hyperlinks
  • Adding 3D Images
  • Using the Actions Button
  • Using the Zoom Feature
  • Using the Screen Recorder
  • Using the Picture Background
  • Slide Master – Picture Background
  • Slide Master – Part 2
  • Using the Slide Sorter View
  • Using the Presenter View
  • Recording Our Presentation
  • Present Your Presentation Online
  • Insert Menu – Add-Ins
  • Add Ins – Camtasia
  • Conclusion

***Animations with PowerPoint***

  • Introduction
  • Creating intros
  • Motion graphics
  • Videos and videos backgrounds
  • Masks
  • Parallax Effect Slide Presentation
  • Kinetic Typography
  • Adding Animated Gifs
  • Display videos
  • Creating outros
  • Producing the videos

***Advanced Diploma in MS Excel***

  • Excel from A-Z Course Introduction
  • Getting Started With Excel
  • Values, Referencing and Formulas
  • Intro to Excel Functions
  • Adjusting Excel Worksheets
  • Visually Pleasing Cell Formatting
  • How to Insert Images and Shapes!
  • Visualize Data with Charts
  • Excel’s Printing Options
  • Benefits of Using Excel Templates
  • Working with Excel Datasets
  • Excel Database Functions
  • Excel Data Validation
  • Excel PivotTables
  • Excel’s PowerPivot Add-In
  • Excel’s Conditional Functions
  • Excel’s Lookup Function
  • Text-Based Functions in Excel
  • Auditing Formulas and Views in Excel
  • Excel’s “what If?” Tools
  • Welcome to Excel VBA
  • Writing VBA Code
  • Important VBA Tools and Logic
  • Excel VBA Loop
  • Triggering Macros
  • Excel User Forms
  • Starting a Career in Excel

***MS Excel: Master Power Query in 120 Minutes!***

  • Power Query Intro and Excel version
  • Excel Power Query – Introduction
  • Excel Power Query – Query Editor Ribbon
  • Trim in Excel Power Query
  • Format Dates and Values in Excel Power Query
  • Parsing URLs in Excel Power Query
  • Split Text Fields in Excel Power Query
  • Group By in Excel Power Query
  • Unpivoting Columns in Excel Power Query
  • Pivoting Columns in Excel Power Query
  • Split Columns into Other Columns in Excel Power Query
  • Filtering Rows in Excel Power Query
  • Sorting Columns in Excel Power Query
  • Transform and Add Columns in Excel Power Query
  • Import From Folder in Excel Power Query
  • Doing Auto Cleanup in Excel Power Query
  • Extract Data from Forms in Excel Power Query
  • Extract Multiple Criteria in Excel Power Query
  • Extract Multiple Worksheets in Excel Power Query
  • Intro to Joins
  • Merging
  • Full Outer Join
  • Right Anti Join
  • Convert Reports into Pivot Tables
  • Modulo

***Microsoft Access Databases Forms and Reports***

  • Autoforms
  • Form Wizard
  • Changing a form with a design view
  • Adding controls to your form
  • Subforms
  • Using Auto report to create a report
  • Using the Report Wizard to create a report
  • Changing a report in design view
  • Adding Calculations to your report
  • Adding Groups, Sorts and Totals to reports
  • Making labels with the Label Wizard
  • Form and Report Properties
  • Exporting a report to Excel
  • Creating a menu with the Switchboard Manager
  • Finalizing the Application

Certificates of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

After successfully completing the following courses under the Microsoft 365bundle, learners will get Quality Licence Scheme-endorsed certificates as proof of their achievement:

  • Complete MS Outlook - CPD Approved
  • MS Teams - Master MS Teams
  • MS Word Advanced
  • Advanced Diploma in MS Excel
  • Microsoft Access for Beginners

Hardcopy of these certificates of achievement endorsed by the Quality Licence Scheme will be sent straight to your home by post, without any cost whatsoever!

CPD & IAO Accredited Certification from One Education

Once you have finished the Microsoft 365 bundle, you will be eligible for CPD & IAO-accredited certificates for each of the courses inside this bundle as proof of your new skills and your continued professional development. Certification is available in both PDF & hardcopy format, which can be received absolutely for free!

Who is this course for?

The Microsoft 365 bundle is ideal for highly motivated individuals who want to enhance their professional skills and train for the job they want! This Microsoft 365 bundle also suits people aspiring for some in-depth knowledge on this topic and keep up to date with the latest information.

Study the Microsoft 365 bundle today and increase your professional skillset from the comfort of your home!

Requirements

There are no formal entry requirements for the Microsoft 365 bundle, with enrollment open to anyone! Anyone and everyone with a knack for learning can enrol on this course without any hesitation.

Learn online from any internet device, including your computer, tablet or smartphone. Study when it suits you and complete the Microsoft 365 bundle at your own pace.

All students must have a passion for learning and literacy and be over the age of 16.

Career path

Studying the Microsoft 365 bundle is designed to help you get the job of your dreams, or even that promotion you’ve always wanted. Learn the essential skills and knowledge you need to exceed in your professional life with the help & guidance from our Microsoft 365 bundle.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.