Add to basket or enquire
Microsoft Office Essentials is accredited by CPD and suitable for anyone aspiring to or already working in this field or simply want to learn deeper into Microsoft Office Essentials. You will be able to add this CPD accredited qualification to your CV by downloading your certificate instantly without any cost.
To make this Microsoft Office Essentials course more accessible for you, we have designed it for both part-time and full-time students. This Microsoft Office Essentials course is packed into the bite-size module for your convenience. You can study at your own pace or become accredited within hours!
If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this Microsoft Office Essentials course and answer all your queries through email.
It is crucial to understand the basics of the business apps that support companies flourish and reach your potential or support companies to reach their potential.
In the Microsoft Office Essentials course, you will appreciate every ins and outs of Microsoft Office. By enrolling this Microsoft Office Essentials course, you will learn the necessary skills, knowledge, and information about Microsoft Office that includes Access, Excel, Outlook, PowerPoint, Publisher and Word. You will know the different components and parts of Microsoft Office that you need to learn to become a Microsoft Office Suite expert. Learn how to communicate and collaborate more productively with Microsoft tools.
What will you learn in this Microsoft Office Essentials
Module 1: Word Essentials
In this module, you will learn all about Opening. You will learn how to open Word, where you’ll first encounter the Recent list and other ways you can start a document. You’ll learn how to open files and how to create a blank document or a document from a template.
Module 2: Word Interface and Navigation
This module will teach you about Working with the Interface. we’ll introduce you to the Word 2013 interface, which uses the Ribbon from the previous two versions of Word. You’ll get a closer look at the Ribbon, as well as the Navigation pane and the Status bar. You’ll also learn how to manage your Microsoft account right from a new item above the ribbon. This module introduces you to the Backstage view, where all of the functions related to your files live. You’ll learn how to save files. Finally, we’ll look at closing files and closing the application.
Module 3: Word Advanced Features
In this module, you will learn all about Your First Document. you will create your first document. You will learn how to type text and select it with a mouse or keyboard. With text selected, you can edit or delete text, or you can use the mouse to drag and drop a text to a new location. You’ll also learn how to insert symbols and numbers. Finally, this module will cover how to start a new page.
Module 4: Excel Basics
This module will teach you about Viewing Excel Data. Excel offers several options for viewing your worksheets. This module will provide an overview of the different views that are available. It also explains how to switch views and create a custom view. This module covers how to use the Zoom feature. Finally, this module discusses how to switch between different open files.
Module 5: Excel Formulas
In this module, you will learn all about Building Formulas. The backbone of Excel is its ability to perform calculations. There are two ways to set up calculations in Excel: using formulas or using functions. Formulas are mathematical expressions that you build yourself. You need to follow proper math principles in order to obtain the expected answer. Building the formula is simply a matter of combining the proper cell addresses with the correct operators in the right order. This module will explore how to build, edit, and copy formulas. This module will also explain the difference between relative and absolute references. Finally, this module will explain how to use the Status Bar to perform simple calculations. We will explore functions in the next module.
Module 6: Excel Functions
This module will teach you about Using Excel Functions. This module introduces Excel functions, which are a little like templates for common formulas. There are many different types of functions. First, we’ll look at the SUM function. You’ll learn about using AutoComplete for entering formulas. We’ll look at other basic common functions as well. We’ll take a look at the Formulas tab introduced in the Ribbon for Excel 2007. Finally, we’ll take a look at the function names.
Module 7: Excel Data Analysis
In this module, you will learn all about Using Quick Analysis. The new Quick Analysis tools allow you to easily preview and apply a number of formatting, charts, totals, tables, and sparklines features to your data. We’ll first look at the formatting tools. You’ll also learn about the recommended charts available in Quick Analysis. Next, we’ll look at the totals tools that include formulas that automatically calculate totals for you. We’ll also look at the tables available with Quick Analysis. Once you have your data in a table format, you can use a number of sorting and filtering tools, which we’ll also discuss in this module. Finally, you’ll learn how to create sparklines.
Module 8: PowerPoint Essentials
This module will teach you about Working with Text. the PowerPoint 2013 editing tools make editing your presentation a breeze. This module covers how to work with text, including selecting, editing, deleting, cutting, copying, and pasting. It also explains how to use the Office Clipboard. You’ll learn how to use undo and redo and how to find and replace text, such as when you want to change a PowerPoint or phrase throughout your presentation.
Module 9: Powerpoint Formatting
In this module, you will learn all about Formatting Text and Paragraphs. PowerPoint allows you to enhance your text in many ways. In this module, we’ll discuss the different ways you can format your words, including the font face, size, and colour, as well as enhancements and spacing. We’ll also discuss how to clear formatting if you change your mind.
Module 10: PowerPoint Advanced Features
This module will teach you about Adding Pictures. You’ll enhance your presentations with pictures. First, we’ll look at how to insert a picture from a file or online. You’ll also learn how to add screenshots. You’ll get an introduction to the Picture Tools tab, a context-sensitive tab on the Ribbon that appears when you are working with any kind of picture. Finally, we’ll look at how to resize, move, or delete a picture
Module 11: Access Basics
In this module, you will learn all about Working with Fields. Now we’ll start getting more into database design. First, we’ll look at adding a field by entering data. Then we’ll look at adding a specific type of field. You’ll learn how to change the field name, caption, or description for the field and how to change the field format.
Module 12: Access Functions
This module will teach you about An Introduction to Queries, Forms, and Reports. This module introduces you to some of the other objects in Access. You’ll learn about the types of queries and learn to create a query with the Query Wizard. Next, we’ll look at forms and form views. Finally, we’ll take a look at reports in Access.
Module 13: Access and Database
In this module, you will learn all about Protecting Your Data. n order to protect the hard work of designing your database and collecting the data, you should plan regular backups. This module talks about guidelines and tips for planning backups as well as how to back up a database.
Module 14: Outlook Essentials
This module will teach you about An Introduction to the Calendar. Outlook provides a calendar to help you manage your appointments. In this module, we’ll start with an introduction to the calendar interface and learn more about the weather bar. Then we’ll look at creating and editing appointments, as well as managing reminders and changing the view of your calendar.
Module 15: Outlook Tasks
In this module, you will learn all about An Introduction to Tasks. Outlook can help you stay on top of your To Do list with tasks.
Module 16: Publisher Basics
This module will teach you about Opening Publisher. We’ll learn how to open the application, as well as how to open recent and other files.
Method of Assessment:
Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly.
After successfully completing the course, you will be able to obtain the certificates. You can claim a PDF certificate for free-of-charge. There is an additional fee to obtain a hardcopy certificate which is £9.
Who is this course for?
Microsoft Office Essentials is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This Microsoft Office Essentials course is CPD accredited so you don’t have to worry about the quality.
Our Microsoft Office Essentials is open to all from all academic backgrounds and there is no specific requirements to attend this Microsoft Office Essentials course. This Microsoft Office Essentials is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc.
This Microsoft Office Essentials course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with the required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.
Questions and answers
No questions or answers found containing ''.
Good afternoon Would it be possible to confirm if this course is compatible with Microsoft 2007 version.
Hi Sarah, Thanks for your query. The Microsoft Office Essentials course design with Microsoft 2013 version. You will need to do the course with Microsoft 2013 not 2007 version. Many thanks.This was helpful. Thank you for your feedback.
Hi, How many hours does this course take to complete?
Hi Rebecca, Thanks for your query. The duration is 67 hours. However, after purchasing the course you will get one year access to the course to complete. Many thanks.This was helpful. Thank you for your feedback.
Rating and reviews
There haven't been any reviews for this course yet.Leave a review
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.