Microsoft Office Bundle
***4 Courses Bundle | 136 Modules | Free PDF Certificates | Assignment Included | 336 CPD points***
Microsoft Office Bundle
Original price was: £425.£49Current price is: £49. ex Vat
Save 88.47 % - ENDS SOON
OR
Or
Take All courses for £49
1 Year Access 
Level 7
780 Students -
3 weeks, 5 days
Get access to 5000+ courses including this for
Overview
Master the full range of Microsoft 365 tools with the Microsoft software bundle. This comprehensive course covers key applications, including Microsoft Excel 2019, Microsoft Word 2019, Microsoft PowerPoint 2019, and Microsoft Access 2019, equipping you with essential skills for productivity and efficiency. You will learn everything from performing calculations in Excel to preparing professional documents in Word, creating engaging presentations with PowerPoint, and managing data in Access.
Gain expertise in each of the core Microsoft packages, including new features and techniques. Navigate through worksheets in Excel, manage lists in Word, and work with charts and tables in PowerPoint. Each module is structured to help you improve your proficiency and confidently handle various tasks across the Microsoft 365 suite.
Whether you are a beginner or looking to update your skills, the Microsoft software bundle ensures you are fully prepared for the modern workplace. Build your foundation in data management, document formatting, and presentation design—all through the power of Microsoft 365.
Learning Outcomes of Microsoft Office Bundle
- Learn how to perform calculations and modify worksheets.
- Learn how to print and manage workbooks.
- Manage your workspace in Word.
- Apply styles to Streamline Repetitive Formatting Tasks and work more efficiently.
- Use the powerpoint interface professionally and make the smartest presentations at work.
- Get the most out of Microsoft Access.
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
After successfully completing the course, learners will be able to order an endorsed certificate as proof of their new achievement. Endorsed certificates can be ordered and get delivered to your home by post for only £129. There is an additional £10 postage charge for international students.
CPD Certification from One Education
After successfully completing the MCQ assessment of this course, you will qualify for the CPD Certificate from One Education, as proof of your continued professional development. Certification 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.
Endorsement of Microsoft Office Bundle
This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Method of Assessment
To assess your learning, you have to participate in an automated multiple choice question exam. You have to score at least 60% to pass the exam and to qualify for Quality Licence Scheme endorsed and CPD accredited certificates. After passing the exam, you will be able to apply for a certificate.
In addition, to enhance the depth of your knowledge regarding the course and further assess your learning, you are advised to complete the assignment questions provided at the end of the course, which you can complete anytime you wish. After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance.
Why Study This Course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills attesting to your knowledge.
Who is This course for?
This course is invaluable for anybody that uses Microsoft Office tools in pretty much any capacity, whether it is for group administration or for running your own company. Therefore, the skill level required can range from beginner, to an intermediate office worker, to a business owner. Absolutely no previous experience will be needed, and you can guarantee that you’ll encounter many tips and techniques that you’ve never seen before.
Requirements of Microsoft Office Bundle
The Microsoft Office Bundle course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Career Path
When you complete the course, you will be fully qualified to use Microsoft Office tools in multiple ways. This knowledge can then be used to add Certificate of Achievement to your CV and will provide a major advantage when applying for administrative and secretarial roles in an organisation.
Frequently Asked Questions
What exactly are CPD hours/points?
CPD is an abbreviation for Continuing Professional Development. Your employer may require you to complete a certain number of CPD hours or points per year if you work in certain professions or for certain companies.
Do you provide CPD certification? How to obtain CPD certification?
Yes, all of our courses offer CPD certification. After successfully completing the MCQ assessment of this course, you will qualify for the CPD Certificate from One Education, as proof of your continued professional development. With a 60% passing score you will be qualified for CPD accredited certificates.
What exactly is an ‘endorsed’ course?
An endorsed course is one that has been reviewed and approved by an independent awarding body.
Does this course have any endorsements? Do I get any endorsed certificate after completion of the course?
This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. After successfully completing the course, you will be able to order an endorsed certificate as proof of their new achievement. With a 60% passing score you will be qualified for Quality Licence Scheme endorsed certificates.
Do I get any accredited qualifications after completing this course?
This course is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example, progression routes into further and/or higher education.
Do your certificates expire?
No, our certificates do not come with any expiration date.
Do I need to pay for the certification?
Yes, certification 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.
Do I need to pay for the exams?
No, there are no extra fees and hidden costs for the exam.
How to order a QLS certificate?
Endorsed certificates can be ordered and get delivered to your home by post for only £129. There is an additional £10 postage charge for international students
What is the method of teaching?
The course is fully online. You can study this course at your own pace. You will be taught through a combination of
- Video lessons
- Online study materials
How can I further assess my learning and get full tutor support?
Full tutor support is available only on weekdays ( Monday – Friday). You are advised to complete the assignment questions provided at the end of the course, our expert tutor will assess your assignment and will give you feedback on your performance.
How can I gift this course to my beloved one?
In just 3 steps you can gift any course to your beloved ones. The steps are :
- Select gift these course button
- Enter your email, your recipient email and your desired message
- Select send as gift button
- Proceed to checkout and pay for the course
And done! The course will be sent to your desired recipient.
Can I purchase this course in bulk?
Yes, you can. To purchase courses in bulk, add the desired number of courses in the cart and then proceed to the payment option. We also have special discounts for Business Customers.
How long can I access this course ?
All of our courses can be accessed for 1 Year. After one year you have to buy this course again if you wish to continue.
Does completing this course certify me as a Microsoft Office Specialist?
This Microsoft Office 2016 Complete course is ideal for anyone looking to gain Microsoft Office Specialist (MOS) certification. It is aimed at those who wish to develop their skills using Microsoft Office applications.
Would this course be relevant to Microsoft 365 version?
No.
Does this course refer to Microsoft Office 2016 or 2019?
This course is based on Microsoft Office 2016. Also, some of the features of Office 2019 has been covered in this course.
Is it compatible with the Mac operating system?
It is compatible with Mac operating system.
My laptop is currently running MS Office 2013 version. Will this be compatible to commence the course?
No, you need MS Office version 2016.
Course Curriculum
| Microsoft Excel 2019 | |||
| Microsoft Excel 2019 New Features | |||
| Introduction to Microsoft Excel 2019 New Features | 00:07:00 | ||
| CONCAT | 00:02:00 | ||
| IFS | 00:01:00 | ||
| MAXIFS | 00:01:00 | ||
| MINIFS | 00:01:00 | ||
| SWITCH | 00:02:00 | ||
| TEXTJOIN | 00:01:00 | ||
| Map Chart | 00:02:00 | ||
| Funnel Chart | 00:01:00 | ||
| Better Visuals | 00:06:00 | ||
| Pivot Table Enhancements | 00:02:00 | ||
| Power Pivot Updates | 00:01:00 | ||
| Getting Started with Microsoft Excel | |||
| Navigate the Excel User Interface | 00:28:00 | ||
| Use Excel Commands | 00:10:00 | ||
| Create and Save a Basic Workbook | 00:19:00 | ||
| Enter Cell Data | 00:12:00 | ||
| Use Excel Help | 00:05:00 | ||
| Performing Calculations | |||
| Create Worksheet Formulas | 00:15:00 | ||
| Insert Functions | 00:17:00 | ||
| Reuse Formulas and Functions | 00:17:00 | ||
| Modifying a Worksheet | |||
| Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
| Search for and Replace Data | 00:09:00 | ||
| Use Proofing and Research Tools | 00:07:00 | ||
| Formatting a Worksheet | |||
| Apply Text Formats | 00:16:00 | ||
| Apply Number Format | 00:07:00 | ||
| Align Cell Contents | 00:09:00 | ||
| Apply Styles and Themes | 00:12:00 | ||
| Apply Basic Conditional Formatting | 00:11:00 | ||
| Create and Use Templates | 00:08:00 | ||
| Printing Workbooks | |||
| Preview and Print a Workbook | 00:10:00 | ||
| Set Up the Page Layout | 00:09:00 | ||
| Configure Headers and Footers | 00:07:00 | ||
| Managing Workbooks | |||
| Manage Worksheets | 00:05:00 | ||
| Manage Workbook and Worksheet Views | 00:07:00 | ||
| Manage Workbook Properties | 00:06:00 | ||
| Microsoft Word 2019 | |||
| Microsoft Word 2019 New Features | |||
| Introduction to Microsoft Word 2019 New Features | 00:14:00 | ||
| Inking Tools | 00:03:00 | ||
| Inking Tools 1 | 00:07:00 | ||
| Learning Tools | 00:07:00 | ||
| Microsoft Translate | 00:03:00 | ||
| LaTeX | 00:05:00 | ||
| Smart Lookup | 00:04:00 | ||
| Side to Side Scrolling | 00:02:00 | ||
| Scalable Vector Graphics | 00:03:00 | ||
| Getting Started with Word | |||
| Navigate in Microsoft Word | 00:12:00 | ||
| Create and Save Word Documents | 00:24:00 | ||
| Manage Your Workspace | 00:06:00 | ||
| Edit Documents | 00:16:00 | ||
| Preview and Print Documents | 00:04:00 | ||
| Customize the Word Environment | 00:08:00 | ||
| Formatting Text and Paragraphs | |||
| Apply Character Formatting | 00:17:00 | ||
| Control Paragraph Layout | 00:19:00 | ||
| Align Text Using Tabs | 00:07:00 | ||
| Display Text in Bulleted or Numbered Lists | 00:03:00 | ||
| Apply Borders and Shading | 00:04:00 | ||
| Working More Efficiently | |||
| Make Repetitive Edits | 00:06:00 | ||
| Apply Repetitive Formatting | 00:10:00 | ||
| Use Styles to Streamline Repetitive Formatting Tasks | 00:14:00 | ||
| Managing Lists | |||
| Sort a List | 00:05:00 | ||
| Format a List | 00:06:00 | ||
| Adding Tables | |||
| Inserting a Table | 00:06:00 | ||
| Modify a Table | 00:06:00 | ||
| Format a Table | 00:03:00 | ||
| Convert Text to a Table | 00:04:00 | ||
| Inserting Graphic Objects | |||
| Insert Symbols and Special Characters | 00:04:00 | ||
| Add Images to a Document | 00:11:00 | ||
| Controlling Page Appearance | |||
| Apply a Page Border and Color | 00:03:00 | ||
| Add Headers and Footers | 00:06:00 | ||
| Control Page Layout | 00:05:00 | ||
| Add a Watermark | 00:04:00 | ||
| Preparing to Publish a Document | |||
| Check Spelling Grammar and Readability | 00:07:00 | ||
| Use Proofing and Research Tools | 00:07:00 | ||
| Check Accessibility | 00:03:00 | ||
| Save a Document to Other Formats | 00:04:00 | ||
| Workbooks - Microsoft Word 2016 (Beginner) | |||
| Workbooks – Microsoft Word 2016 (Beginner) | 00:00:00 | ||
| Microsoft PowerPoint 2019 | |||
| Microsoft PowerPoint 2019 New Features | |||
| Introduction to Microsoft PowerPoint 2019 New Features | 00:06:00 | ||
| Highlighting | 00:02:00 | ||
| Morph Transition | 00:03:00 | ||
| Zoom | 00:03:00 | ||
| Vector Graphics | 00:03:00 | ||
| SVG Icons to Shapes | 00:04:00 | ||
| 3D Modeling | 00:04:00 | ||
| Background Removal | 00:03:00 | ||
| 4K | 00:03:00 | ||
| PowerPoint Interface | |||
| Navigate the PowerPoint Environment | 00:28:00 | ||
| View and Navigate a Presentation | 00:15:00 | ||
| Create and Save a PowerPoint Presentation | 00:13:00 | ||
| Use PowerPoint Help | 00:10:00 | ||
| Presentation Basics | |||
| Select a Presentation Type | 00:08:00 | ||
| Edit Text | 00:13:00 | ||
| Build a Presentation | 00:27:00 | ||
| Formatting | |||
| Format Characters | 00:11:00 | ||
| Format Paragraphs | 00:16:00 | ||
| Format Text Boxes | 00:09:00 | ||
| Inserting Options | |||
| Insert Images | 00:10:00 | ||
| Insert Shapes | 00:15:00 | ||
| Working with Objects | |||
| Edit Objects | 00:16:00 | ||
| Format Objects | 00:06:00 | ||
| Group Objects | 00:04:00 | ||
| Arrange Objects | 00:07:00 | ||
| Animate Objects | 00:07:00 | ||
| Table | |||
| Create a Table | 00:09:00 | ||
| Format a Table | 00:03:00 | ||
| Insert a Table from Other Microsoft Office Applications | 00:06:00 | ||
| Charts | |||
| Create a Chart | 00:10:00 | ||
| Format a Chart | 00:10:00 | ||
| Insert a Chart from Microsoft Excel | 00:05:00 | ||
| Review and Presentation | |||
| Review Your Presentation | 00:11:00 | ||
| Apply Transitions | 00:05:00 | ||
| Print Your Presentation | 00:05:00 | ||
| Deliver Your Presentation | 00:08:00 | ||
| Microsoft Access 2019 | |||
| Microsoft Access 2019 New Features | |||
| Introduction to Microsoft Access 2019 New Features | 00:05:00 | ||
| Window Resize | 00:01:00 | ||
| Charts | 00:02:00 | ||
| dbf | 00:01:00 | ||
| Large Number | 00:01:00 | ||
| Property Sorting | 00:01:00 | ||
| Introduction to Access | |||
| Orientation to Microsoft Access | 00:39:00 | ||
| Create a Simple Access Database | 00:10:00 | ||
| Get Help and Configure Options in Microsoft Access | 00:06:00 | ||
| Modify Data | |||
| Modify Table Data | 00:17:00 | ||
| Sort and Filter Records | 00:05:00 | ||
| Working with Queries | |||
| Create Basic Queries | 00:15:00 | ||
| Sort and Filter Data in a Query | 00:14:00 | ||
| Perform Calculations in a Query | 00:08:00 | ||
| Access Forms | |||
| Create Basic Access Forms | 00:07:00 | ||
| Work with Data on Access Forms | 00:23:00 | ||
| Working with Reports | |||
| Create a Report | 00:12:00 | ||
| Add Controls to a Report | 00:12:00 | ||
| Enhance the Appearance of a Report | 00:05:00 | ||
| Prepare a Report for Print | 00:03:00 | ||
| Organize Report Information | 00:15:00 | ||
| Format Reports | 00:12:00 | ||
| Assignment | |||
| Assignment – Microsoft Office Bundle | 1 week, 3 days | ||
| Recommended Materials | |||
| Workbook – Microsoft Office Bundle | 2 weeks, 1 day | ||
| Order Your Certificate | |||
| Order Your Certificate QLS | 00:00:00 | ||
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.
