Category:
- Personal Development
- QLS Endorsed Single Course
Course Overview
Unlock the power of Microsoft Office with our comprehensive Microsoft Office Course, designed to empower individuals with essential skills for navigating Microsoft Excel, Word, PowerPoint, and Access. From mastering spreadsheet calculations in Excel to creating impactful presentations in PowerPoint, this course offers a step-by-step guide to harnessing the full potential of Microsoft Office 2019. Whether you are a beginner looking to build a solid foundation or an experienced user aiming to stay updated on the latest features, our course provides a thorough exploration of each application, ensuring you can efficiently manage data, create professional documents, and deliver compelling presentations.
In a technology-driven world, investing in Microsoft Office skills is a strategic decision, as it aligns with the evolving demands of the job market, where digital literacy is a key determinant of success.
Learning Outcomes:
Upon completing this course, participants will:
- Master the new features and functionalities introduced in Microsoft Excel, Word, PowerPoint, and Access 2019.
- Demonstrate proficiency in performing calculations and data analysis in Microsoft Excel.
- Develop advanced formatting skills for creating polished and professional documents in Microsoft Word.
- Create dynamic and visually engaging presentations using Microsoft PowerPoint.
- Acquire database management skills, including data modification, querying, form creation, and report generation in Microsoft Access.
Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.
Why Choose Thames College?
Thames College offers you the benefit of —
- Learn with engaging voice-over and visual elements to facilitate your learning process.
- Get a year's worth of unlimited access to the course.
- Receive round-the-clock access to expert assistance.
- Participate in quick assessments and get instant feedback on your progress.
- Study at your own schedule from the convenience of your own home.
Who Is This Course For?
Those who want to strengthen their professional skills while training for the desired job should take advantage of the Microsoft Office Bundle training! This course will keep you up-to-date with all the latest developments and coach you accordingly. So invest in this Microsoft Office Bundle course if you want the best training available.
Certificate of Achievement
Quality Licence Scheme Endorsed Certificate of Achievement
Upon successful completion of the Microsoft Office Bundle course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of —
-
- 149 GBP within UK
-
- 159 GBP for International Delivery (Postal Fees Included)
CPD Certification
After successfully completing the assessment of this Microsoft Office Bundle course, you can apply for the CPD accredited certificates. The PDF version is only £2.99 and the Hardcopy version will cost you £8.99.
Disclaimer
The Microsoft Office Bundle course has been endorsed under the 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 Microsoft Office Bundle 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 Microsoft Office Bundle 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 Microsoft Office Bundle course itself has been designed by One Education to meet specific learners’ and/or employers’ requirements which cannot be satisfied through current regulated qualifications.
The Quality Licence Scheme 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.
Requirements
No formal entry requirements! No prerequisites or relevant experience is required!
This course is accessible to anyone with an eagerness to learn. All you require is—
- A smart device with a stable internet connection
- A keen interest in this subject
- And being over the age of 16.
Career Path
Completing the Microsoft Office Course can lead to various career opportunities, with the following expected salaries:
- Office Administrator: £18,000 – £25,000 per annum
- Data Entry Clerk: £18,000 – £22,000 per annum
- Executive Assistant: £25,000 – £35,000 per annum
- Marketing Coordinator: £25,000 – £30,000 per annum
- Database Administrator: £30,000 – £40,000 per annum
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: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 | ||
Format Reports | 00:12:00 | ||
Assignment | |||
Assignment – Microsoft Office Bundle | 3 weeks, 4 days | ||
Order Your Certificate | |||
Order Your Certificate QLS | 00:00:00 |
Certificate of Achievement
CPD Accredited Certification
Certification is available –
- In PDF for £2.99
- Hard copy for £8.99
- £109.00
- 1 year
- Level 7
- Number of Units135
- Number of Quizzes0
- 3 weeks, 5 days