Microsoft Office Bundle
The Microsoft Office Bundle course will allow you to get the very best results from every one of the tools in Microsoft’s Office. So, you’ll learn how to produce documents and presentations that will impress colleagues and clients alike, whether you’re using Excel, PowerPoint, Word, SharePoint or Outlook.
This is an amazingly comprehensive program that is designed to allow every single every user of Office to provide expert-level pieces of work. The course accomplishes this using learning modules, videos, and training exercises. All of these are tailored to give you exactly the right amount of teaching, depending on what you need for your personal and professional needs.
By the time you have completed the course, you’ll have everything you need to manipulate raw data and turn it into stunning graphs, spreadsheets, tables, letters, libraries, and mails, becoming an asset in any office environment.
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Text/Video lessons
- Online study materials
Endorsed Certification from ABC Awards
After successfully completing the course, learners will be able to order an endorsed certificate as proof of their new qualification. 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.
At the end of this course successful learners will receive a Certificate of Achievement from ABC Awards and Certa Awards and a Learner Unit Summary (which lists the components the learner has completed as part of the course).
The course has been endorsed under the ABC Awards and Certa Awards Quality Licence Scheme. This means that One Education has undergone an external quality check to ensure that the organisation and the courses it offers, meet defined quality criteria. The completion of this course alone does not lead to a regulated qualification* but may be used as evidence of knowledge and skills gained. The Learner Unit Summary may be used as evidence towards Recognition of Prior Learning if you wish to progress your studies in this subject. To this end the learning outcomes of the course have been benchmarked at Level 7 against level descriptors published by Ofqual, to indicate the depth of study and level of demand/complexity involved in successful completion by the learner.
The course itself has been designed by One Education to meet specific learners’ and/or employers’ requirements which cannot be satisfied through current regulated qualifications. ABC Awards & Certa Awards endorsement involves robust and rigorous quality audits by external auditors to ensure quality is continually met. A review of courses is carried out as part of the endorsement process.
ABC Awards and Certa Awards have long-established reputations for providing high quality vocational qualifications across a wide range of industries. ABC Awards and Certa Awards combine over 180 years of expertise combined with a responsive, flexible and innovative approach to the needs of our customers.
Renowned for excellent customer service, and quality standards, ABC Awards and Certa Awards also offer regulated qualifications for all ages and abilities post-14; all are developed with the support of relevant stakeholders to ensure that they meet the needs and standards of employers across the UK.
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.
*Regulated qualification refers to those qualifications that are regulated by Ofqual / CCEA / Qualification Wales
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 ABC 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 and an ABC endorsed certificate 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.
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.
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 significant qualifications to your CV and will provide a major advantage when applying for administrative and secretarial roles in an organisation.
|Microsoft Excel 2019|
|Microsoft Excel 2019 New Features|
|Introduction to Microsoft Excel 2019 New Features||00:07: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|
|Create Worksheet Formulas||00:15: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|
|Preview and Print a Workbook||00:10:00|
|Set Up the Page Layout||00:09:00|
|Configure Headers and Footers||00:07: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 1||00:07: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|
|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|
|Sort a List||00:05:00|
|Format a List||00:06:00|
|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:05: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|
|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|
|SVG Icons to Shapes||00:04:00|
|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|
|Select a Presentation Type||00:08:00|
|Build a Presentation||00:27:00|
|Format Text Boxes||00:09:00|
|Working with Objects|
|Create a Table||00:09:00|
|Format a Table||00:03:00|
|Insert a Table from Other Microsoft Office Applications||00:06:00|
|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|
|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|
|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 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|
|Create Basic Access Forms||00:07:00|
|Work with Data on Access Forms||00:23:00|
|Working with Reports|
|Create a Report||00:28: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|
|Assignment – Microsoft Office Bundle||Unlimited|
|Order Your Certificate|
|Order Your Certificate||00:00:00|