Ultimate Microsoft Office Bundle

Last updated: April 2, 2024
|
Language: English
|
Flexible Schedule

Overview

The Ultimate 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.    

Course design

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

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

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 accredited qualification 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

The Ultimate 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 significant qualifications to your CV and will provide a major advantage when applying for administrative and secretarial roles in an organisation.

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: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
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
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
Modify Data
Working with Queries
Access Forms
Working with Reports
Create a Report 00:28:00
Ultimate Microsoft Office Bundle
PRIVATE

Exclusive Deal! 0% Off, Today Only!

PRIVATE COURSE
🔥 10 Units sold in last 6 Hours
cpdy aoht Qlc

This course includes:

  • level Skill Level
  • course_duration Duration
    15 hours, 12 minutes
  • studentsStudents
    65 Students