Includes the Following Courses

Microsoft Excel Certification Level 1
Microsoft Excel Certification Level 2
Microsoft Excel Certification Level 3
Microsoft Word Certification Level 3
PowerPoint Diploma
Microsoft Outlook Certification Level 3

The Complete Microsoft Office Certification

This all-inclusive 90 hour course consists of 6 information packed lessons, each of which is made up of over 30 modules.

Upon completion of this course, learners will be able to master each one of these important pieces of software. This online course can be completed from anywhere on your business’s schedule.

The Complete Microsoft Office Certification firstly introduces you to Microsoft Excel, with a beginner, intermediate and then advanced certification. Through these three lessons, team members become experts in Excel, from simple tricks to using advanced functions.

Next, they study Microsoft Word, and, through this certification, they’ll learn how to quickly create impressive documents.

The following lesson will cover how to use Microsoft PowerPoint, teaching how to create professional and effective presentations. The final aspect that this course covers is Microsoft Outlook, to enable learners to master this important tool.

What’s Covered in the Course?

Through this combined course, your employees will learn:

  • In the modules covering Microsoft Excel for beginners, they will learn the basics of the programme and everything that they’ll need, in order to get started with more advanced concepts;
  • The following modules will give them an intermediate certification in Excel, by building upon the knowledge gained from the previous section and introducing them to more complicated functions;
  • Next, they’ll receive an advanced certification in Excel, which will prepare them for any position that requires someone who’s proficient in Excel;
  • The Microsoft Word Certificate will give them an advanced understanding of this crucial piece of software;
  • By gaining the Microsoft PowerPoint diploma, they will be able to quickly and efficiently create better slideshows and impress their colleagues with their presentations;
  • The final lesson will earn them a Microsoft Outlook Diploma, whereby they’ll become familiar with all the tips and tricks necessary to effortlessly handle this software.

What are the Benefits of the Course?

There are a range of benefits to successfully completing this course. These benefits include:

  • Achieving the ability to flawlessly operate the Microsoft Office suite;
  • The ability to study at the time and from the place that best suits them;
  • Upon completion of all modules, employees receive an industry-recognised and fully-accredited certification;
  • Study materials are available on all major devices - all that’s required is an internet connection.

 



Course Modules/Lessons

Microsoft Excel Certification Level 1

Module 1: Introduction to Excel

Module 2 : Add

Module 3 : Multiply

Module 4 : Subtraction in Excel

Module 5 : Dividing

Module 6 : Sort

Module 7 : Percentage

Module 8 : Running Totals

Module 9 : Print

Module 10 : Paste Special

Module 11 : Merge

Module 12 : Filter

Module 13 : Average

Module 14 : AVERAGEIF

Module 15: SUMIF Formula

Module 16: IF Formula

Module 17: VLOOKUP

Module 18: HLOOKUP

Module 19 : Countif Formula

Module 20 : CountBlank

Module 21 : Counta Formula

Module 22 : Count Formula

Module 23 : Concatenate

Module 24 : Transpose

Module 25: Date Formula

Module 26: Month Formula

Module 27: Pivot Tables

Module 28: Pie Charts

Module 29: Doughnut Charts

Module 30: Line Charts

Module 31: Column Charts

Module 32: Bar Charts

Module 33: Number Formatting

Module 34: Create Borders

Module 35: Conditional Formatting

Module 36: Comments

Microsoft Excel Certification Level 2

Module 1: SumProduct Formula

Module 2 : Data Validation With Date

Module 3 : Data Validation with Whole Numbers

Module 4 : Data Validation with List Feature

Module 5 : ABS Function

Module 6 : CHAR Function

Module 7 : CLEAN Function

Module 8 : CODE Function

Module 9 : EXACT Function

Module 10 : AVERAGEA Function

Module 11 : AVERAGEIF

Module 12 : AVERAGEIFS Function

Module 13 : CELL Function With 10 Variations

Module 14 : LARGE Function

Module 15: MAX Function

Module 16: MEDIAN Function

Module 17: MIN Function

Module 18: MODE Function

Module 19 : N Function

Module 20 : RANDBETWEEN Function (Insert Random Numbers)

Module 21 : RANK Function

Module 22 : Remove Duplicate Values

Module 23 : ROUND Function Up/Down

Module 24 : Add Custom Background Image

Module 25: Change Text To Lower Case

Module 26: Change Text To Upper Case

Module 27: Change Text To Proper Case

Module 28: Insert Special Character

Module 29: Use Autofill : A Time Saving Trick

Module 30: Treemap Chart

Module 31: Sunburst Chart

Module 32: Use Tables

Module 33: Use Templates

Module 34: Use Themes

Microsoft Excel Certification Level 3

Module 1: Add a Password

Module 2 : AND Function

Module 3 : Auto Updating Drop-down Lists

Module 4 : CEILING Formula

Module 5 : Charts that Update Automatically

Module 6 : CHOOSE Formula

Module 7 : Compare 2 Lists with VLOOKUP Function

Module 8 : CORREL Function

Module 9 : Create an Advanced Calculator

Module 10 : Create a Combo Chart

Module 11 : Create a Custom Tab

Module 12 : Create a Pivot Chart

Module 13 : Create Visual In-cell Indicators

Module 14 : Create Visual In-cell Indicators with Icon Sets

Module 15: Customise the Status Bar

Module 16: DATEDIF Function

Module 17: DATEVALUE Function

Module 18: DAVERAGE Function

Module 19 : DCOUNT Function

Module 20 : DCOUNTA Function

Module 21 : Depreciation Formula

Module 22 : DGET Function

Module 23 : DMAX Function

Module 24 : DPRODUCT

Module 25: DSUM Function

Module 26: EDATE Function

Module 27: EOMONTH Function

Module 28: Find and Replace

Module 29: FIND Function

Module 30: INDEX Function

Module 31: INDEX MATCH Function

Module 32: INDIRECT Function

Module 33: Insert Serial Number Automatically

Module 34: IPMT Function

Module 35: ISBLANK Function

Module 36: ISERR Function

Module 37: ISLOGICAL Function

Module 38: ISNONTEXT Function

Module 39: ISNUMBER Function

Module 40: ISODD Function

Module 41: Isolate First Name

Module 42: ISTEXT Formula

Module 43: LEFT Function

Module 44: LEN Function

Module 45: MATCH Function

Module 46: VLOOKUP Multiple Results at Once

Module 47: OR Function

Module 48: PMT Function

Module 49: REPLACE Function

Module 50: Select all Cells with Comments

Module 51: Sparkline Charts in Excel

Module 52: Straight Line Depreciation

Module 53: Strikethrough

Module 54: Sum of Years Depreciation

Module 55: Timeline in Pivot Table

Module 56: VLOOKUP with 2 Criteria

Module 57: VLOOKUP with DropDown List

Module 58: VLOOKUP with MAX

Module 59: VLOOKUP with MIN

Module 60: Watch Window In Excel

Microsoft Word Certification Level 3

Module 1: Entering Text

Module 2 : Deleting Text

Module 3 : Splitting and Joining Text

Module 4 : Undo and Redo

Module 5 : Find and Replace

Module 6 : Text Block

Module 7 : Spell Check

Module 8 : Check Word Count

Module 9 : Format Text

Module 10 : Printing a Document

Module 11 : Format a Page

Module 12 : Using Sections

Module 13 : Create a Cover Page

Module 14 : Create Headers

Module 15: Edit Headers

Module 16: Using Styles

Module 17: Create Own Formatting Style

Module 18: Applying a Theme

Module 19 : Modifying a Theme

Module 20 : Create a Border

Module 21 : Edit Border

Module 22 : Create Page Border

Module 23 : Create a Table

Module 24 : Editing Table

Module 25: Use Format Painter

Module 26: Create Line Numbers

Module 27: Create Automatic Table of Contents

Module 28: Insert Image

Module 29: Insert Shapes

Module 30: Insert Clip Art

Module 31: Use Comments

Module 32: Save As

Module 33: View Two Documents Side By Side

Module 34: Insert Video

Module 35: Mix Image and Text

Module 36: Insert Symbols / Special Characters

Module 37: Enter Footnote and Endnote

Module 38: Use layouts

Module 39: Insert SmartArt

Module 40: Handle Multiple Documents

Module 41: Convert MS Word File to Other Format

Module 42: Remove Comments When Printing

Module 43: Insert Text Box

Module 44: WordArt

Module 45: Position Images

Module 46: Unlinking Images from Text

Module 47: Convert File to PDF

Module 48: Highlight Text

Module 49: Configure Status Bar

Module 50: Quick Access Toolbar

Module 51: Hide/Display Ribbon

Module 52: Add Hyperlink

Module 53: Use Thesaurus

PowerPoint Diploma

Module 1: Navigating PowerPoint

Module 2 : Work with Slides

Module 3 : Work with Multiple Layouts

Module 4 : Work with Text

Module 5 : Work with Text Pt2

Module 6 : Working with Text Pt3

Module 7 : Tables

Module 8 : Insert an Image

Module 9 : Create a Photo Album

Module 10 : Use Shapes

Module 11 : Smart Art

Module 12 : Text Boxes

Module 13 : Headers & Footers

Module 14 : Use Videos

Module 15: Use Audio

Module 16: Recording Screen & Audio

Module 17: Slide Design

Module 18: Transition

Module 19 : Animations

Module 20 : Spell Check

Module 21 : Thesaurus

Module 22 : Comments

Module 23 : Inking

Module 24 : Outline View

Module 25: Slide Sorter

Module 26: Notes Page

Module 27: Reading View

Module 28: Handout Master

Module 29: Notes Master

Module 30: Zoom View

Module 31: New Window Option

Module 32: Cascade and Arrange Window Option

Module 33: Left Side Menu

Module 34: Templates

Module 35: Open Command

Module 36: Save As Option

Module 37: Print Command

Module 38: Convert PPT to PDF

Module 39: Convert PPT to Video

Module 40: Create Handouts

Module 41: Customise the Quick Access Toolbar

Module 42: Password Protect a PPT

Module 43: Find and Replace

Module 44: Replace Command

Module 45: Hyperlinks

Microsoft Outlook Certification Level 3

Module 1: Compose an Email

Module 2 : Read an Email

Module 3 : Reply to an Email

Module 4 : Reply to All and Forward an Email

Module 5 : Add Attachment to an Email

Module 6 : View and Save Attachments

Module 7 : Add Signatures

Module 8 : Adding an IMAP or POP Account Manually

Module 9 : Backing Up or Moving Outlook

Module 10 : Connecting to a OneDrive account

Module 11 : Create New Folder in Outlook

Module 12 : Organising Mail Into Folders

Module 13 : Navigating Tasks

Module 14 : Navigate People Hub and Create a Contact

Module 15: Create New Contact Group

Module 16: Working with Contacts

Module 17: Create Rules to Manage Emails in Outlook

Module 18: Create Voting Buttons in a Message

Module 19 : Create a Meeting

Module 20 : Responding to, Cancelling and Editing a Meeting

Module 21 : Creating an Appointment

Module 22 : Creating Follow-up Flags

Module 23 : Creating Notes

Module 24 : Creating Personal Stationery

Module 25: Search Email

Module 26: Creating Search folders

Module 27: Exploring Delivery Options

Module 28: Exploring Other Mail Settings

Module 29: Format an Email

Module 30: Ignoring Conversations and Flagging as Junk

Module 31: Mailbox Clean Up Tools

Module 32: Manage Inbox

Module 33: Navigating the Calendar

Module 34: Opening Other Calendars

Module 35: Creating Additional Calendars

Module 36: Setting Calendar Preferences

Module 37: Printing and Emailing the Calendar

Module 38: Out of Office Reply for POP and IMAP

Module 39: Reusing Text by Creating Quick Parts

Module 40: Sending or Receiving Emails Manually

Module 41: Setting Advanced General Outlook Options

Module 42: Using Conditional Formatting to Change Font and Colour

Module 43: Using Filters and the People Pane

Module 44: Using Quick Steps

FIND OUT HOW WE CAN HELP TRAIN YOUR STAFF



FAQ's

  • Who can take the Complete Microsoft Office Certification course?

    Anyone who has an interest in learning more about this subject matter is encouraged to take the course. There are no entry requirements to take the course.

  • What is the structure of the course?

    The Complete Microsoft Office Certification Course consists of 6 courses:
    Each course consists of between 34 and 60 individual modules.
    Modules can take from 20 to 90 minutes to complete. You are free to spend as much or as little time as you feel necessary on each module, simply log in and out of the course at your convenience.

  • Do I have to study the courses in a certain order?

    No. You can study the courses in any order you choose. If you want to, you can do one module from a course and then move on to the next course.

  • Where / when can I study the course?

    You can study the course any time you like. Simply log in and out of the web based course as often as you require. The course is compatible with all computers, tablet devices and smart phones so you can even study while on the move!

  • Is there a test at the end of the course?

    Yes. Once you have completed all of the modules for each course there will be a multiple choice test.
    The questions will be on a range of topics found within the modules. The test, like the course, is online and can be taken a time and location of your choosing.

  • What is the pass mark for the final test?

    The pass mark for each test is 70%.

  • What happens if I fail the test?

    If you don’t pass the test first time you will get further opportunities to take the test again after extra study. There are no limits to the number of times you can take the test. All test retakes are included within the price of the course.

  • When will I receive my certificate?

    Once you have completed your test you can log in to your account and download/print your certificate any time you need it. If you would prefer us to post you a certificate to a UK address, there will be an admin charge of £10 (certificates sent internationally may cost more).

  • How can I pay?

    You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. Our site uses the latest SSL encryption to ensure your safety. All payments are handled securely by PayPal.

  • How long after payment can I begin the course?

    You can begin the course immediately after your payment has been received. You will create your login details during the checkout process.
    We will also send you an email confirming your login details.

  • How long does it take to complete the Complete Microsoft Office Certification course?

    We estimate that the course will take about 90 hours to complete in total.

  • How long is my certificate valid for?

    Once you have been awarded your certificate it is valid for life. The certificate does not expire or need renewing.

  • Can I apply for an NUS card?

    Yes. All New Skills Academy students can apply for an NUS card. Details of how to do so will be available in your account once your order has been processed.