Our Courses

Course Library View the full range of courses

No products in the basket.
Log in

Empower Yourself!!

Join our community of 70k+ learners, upskill with CPD accredited courses, explore career development tools and psychometrics.

Having trouble Logging in? Get in Touch

Don’t have an account yet? Sign Up

Already have an account? Log In

[wplms_lost_password_form]

Remember your password? Back to Login

Home
Course
Employability
Microsoft Office
Advanced Diploma in Microsoft Office

Advanced Diploma in Microsoft Office

Master Microsoft Office with Excel, Word, PowerPoint, and Access 2019. Gain advanced skills for professional productivity and office efficiency.

(11 Reviews)

481

Students

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49 PER YEAR. FIND OUT MORE

Advanced Diploma in Microsoft Office Course Overview

The Advanced Diploma in Microsoft Office is a comprehensive course designed to provide in-depth knowledge and practical expertise across Microsoft Office 2019 applications. Covering Excel, Word, PowerPoint, and Access, learners gain the skills necessary to work efficiently in professional office environments and enhance their productivity.

This course explores advanced features, new tools, formatting techniques, data management, presentation design, and database handling. With step-by-step guidance on calculations, charts, tables, document publishing, queries, reports, and more, learners will become proficient in using Microsoft Office for real-world tasks. It is ideal for office professionals, students, or anyone looking to master Microsoft Office at an advanced level.

What You’ll Learn from this Course

By the end of this course, you will learn:

Microsoft Excel 2019: formulas, functions, formatting, and workbook management
Microsoft Word 2019: document formatting, tables, graphics, and publication preparation
Microsoft PowerPoint 2019: presentation design, formatting, objects, tables, charts, and slideshows
Microsoft Access 2019: database creation, queries, forms, and reports
How to work efficiently using Microsoft Office tools
Advanced data management and document control techniques
Applying new features of Microsoft Office 2019 effectively

Key Topics Covered in Advanced Diploma in Microsoft Office Course

Microsoft Excel 2019 (New Features, Calculations, Formatting, Workbooks & Printing)
Microsoft Word 2019 (New Features, Text & Paragraph Formatting, Tables & Graphics, Document Preparation)
Microsoft PowerPoint 2019 (New Features, Presentation Basics, Objects, Tables & Charts, Slide Review & Presentation)
Microsoft Access 2019 (New Features, Database Basics, Data Modification, Queries, Forms & Reports)

Who Is This Course For?

This Advanced Diploma in Microsoft Office Course is ideal for:

Entry Requirements: No formal qualifications required. Learners only need a basic understanding of English and access to a device with an internet connection. The course is accessible on laptops, desktops, tablets, and smartphones, enabling flexible, self-paced study.

Why Learn with iStudy

Lifetime access to the course
No hidden fees or exam charges
CPD Qualification Standards certification on successful completion
Full Tutor support on weekdays (Monday – Friday)
Efficient exam system, assessment, and instant results
Download Printable PDF certificate immediately after completion
Optional hard copy certificate delivery for as little as £9
Improve your chance of gaining professional skills and better earning potential

Career Path

Completing the Advanced Diploma in Microsoft Office Course can open doors to several opportunities, such as:

Start Your Career Today

Boost your professional productivity and expertise. Enrol in the Advanced Diploma in Microsoft Office today and become a Microsoft Office power user.

Course content

45 Sections 197 lectures 75 hours 46 mins in total

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

5 lectures • 1 hour 14 mins

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

3 lectures • 49 m: 0 s

Create Worksheet Formulas

00:15:00
Insert Functions

00:17:00
Reuse Formulas and Functions

00:17:00

Modifying a Worksheet

3 lectures • 26 m: 0 s

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

5 lectures • 56 m: 0 s

Apply Text Formats

00:16:00
Apply Number Format

00:08:00
Align Cell Contents

00:09:00
Apply Styles and Themes

00:12:00
Apply Basic Conditional Formatting

00:11:00

Printing Workbooks

3 lectures • 26 m: 0 s

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

3 lectures • 18 m: 0 s

Manage Worksheets

00:05:00
Manage Workbook and Worksheet Views

00:07:00
Manage Workbook Properties

00:06:00

Microsoft Word 2019

0 lectures • 0 m: 0 s

Microsoft Word 2019 New Features

8 lectures • 41 m: 0 s

Introduction to Microsoft Word 2019 New Features

00:14:00
Inking Tools

00:03: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

6 lectures • 1 hour 11 mins

Navigate in Microsoft Word

00:13: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

5 lectures • 51 m: 0 s

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:05:00

Working More Efficiently

3 lectures • 30 m: 0 s

Make Repetitive Edits

00:06:00
Apply Repetitive Formatting

00:10:00
Use Styles to Streamline Repetitive Formatting Tasks

00:14:00

Managing Lists

2 lectures • 11 m: 0 s

Sort a List

00:05:00
Format a List

00:06:00

Adding Tables

4 lectures • 21 m: 0 s

Insert a Table

00:07:00
Modify a Table

00:06:00
Format a Table

00:03:00
Convert Text to a Table

00:05:00

Inserting Graphic Objects

2 lectures • 15 m: 0 s

Insert Symbols and Special Characters

00:04:00
Add Images to a Document

00:11:00

Controlling Page Appearance

4 lectures • 18 m: 0 s

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

4 lectures • 21 m: 0 s

Check Spelling Grammar and Readability

00:07:00
Use Research Tools

00:07:00
Check Accessibility

00:03:00
Save a Document to Other Formats

00:04:00

Microsoft PowerPoint 2019

0 lectures • 0 m: 0 s

Microsoft PowerPoint 2019 New Features

9 lectures • 32 m: 0 s

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:05:00
Background Removal

00:03:00
4K

00:03:00

PowerPoint Interface

4 lectures • 1 hour 6 mins

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

3 lectures • 48 m: 0 s

Select a Presentation Type

00:08:00
Edit Text

00:13:00
Build a Presentation

00:27:00

Formatting

3 lectures • 36 m: 0 s

Format Characters

00:11:00
Format Paragraphs

00:16:00
Format Text Boxes

00:09:00

Inserting Options

2 lectures • 25 m: 0 s

Insert Images

00:10:00
Insert Shapes

00:15:00

Working with Objects

5 lectures • 40 m: 0 s

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

3 lectures • 18 m: 0 s

Create a Table

00:09:00
Format a Table

00:03:00
Insert a Table from Other Microsoft Office Applications

00:06:00

Charts

3 lectures • 25 m: 0 s

Create a Chart

00:10:00
Format a Chart

00:10:00
Insert a Chart from Microsoft Excel

00:05:00

Review and Presentatin

4 lectures • 29 m: 0 s

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

0 lectures • 0 m: 0 s

Microsoft Access 2019 New Features

6 lectures • 11 m: 0 s

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

3 lectures • 55 m: 0 s

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

2 lectures • 22 m: 0 s

Modify Table Data

00:17:00
Sort and Filter Records

00:05:00

Working with Queries

3 lectures • 37 m: 0 s

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

2 lectures • 30 m: 0 s

Create Basic Access Forms

00:07:00
Work with Data on Access Forms

00:23:00

Working with Reports

6 lectures • 59 m: 0 s

Create a Report

00:12: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

Old Version - Advanced Diploma in Microsoft Office

0 lectures • 0 m: 0 s

Microsoft Word Advanced Level

14 lectures • 11 hour 8 mins

Module One – Getting Started

00:30:00
Module Two – Working with the Word Window

01:00:00
Module Three – Advanced Editing and Formatting Tasks

01:00:00
Module Four – Working with Illustrations

01:00:00
Module Five – Formatting Pictures

01:00:00
Module Six – Adding SmartArt

01:00:00
Module Seven – Adding Tables

01:00:00
Module Eight – Inserting Special Objects

01:00:00
Module Nine – Working with Document References

01:00:00
Module Ten – Reviewing Your Document

01:00:00
Module Eleven – Using Comments and Tracking

01:00:00
Module Twelve – Wrapping Up

00:30:00
Activities-Accredited Microsoft Word Advanced Level Training
Create and Use Templates

00:08:00

Microsoft Excel Advanced Level

13 lectures • 13 hour 0 mins

Module One – Getting Started

01:00:00
Module Two – SmartArt and Objects

01:00:00
Module Three – Auditing

01:00:00
Module Four – Creating Charts

01:00:00
Module Five – Working with Charts

01:30:00
Module Six – Creating Pivot Tables and Pivot Charts

01:00:00
Module Seven – Macros

01:00:00
Module Eight – Solving Formula Errors

01:00:00
Module Nine – Using What If Analysis

01:00:00
Module Ten – Managing Your Data

02:00:00
Module Eleven – Grouping and Outlining Data

01:00:00
Module Twelve – Wrapping Up

00:30:00
Activities-Microsoft Excel Advanced CPD & IAO Accredited

Microsoft PowerPoint Advanced Level

13 lectures • 11 hour 0 mins

Module One – Getting Started

00:30:00
Module Two – Working with Shapes

01:00:00
Module Three – Working with Text Boxes

01:00:00
Module Four – Adding SmartArt

01:00:00
Module Five – Advanced Drawing Tasks

01:00:00
Module Six – Adding Tables

01:00:00
Module Seven – Inserting Audio and Video

01:00:00
Module Eight – PowerPoint’s Research Tools

01:00:00
Module Nine – Preparing for Your Presentation

01:00:00
Module Ten – Using Slide Masters

01:00:00
Module Eleven – Advanced Presentation Tasks

01:00:00
Module Twelve – Wrapping Up

00:30:00
Activities-Microsoft PowerPoint Advanced Level

Microsoft Access Advanced Level

13 lectures • 11 hour 0 mins

Module One – Getting Started

00:30:00
Module Two – Using App Views

01:00:00
Module Three – Customizing Apps, Part One

01:00:00
Module Four – Customizing Apps, Part Two

01:00:00
Module Five – Working with More Record Tasks

01:00:00
Module Six – Using Advanced Field Tasks

01:00:00
Module Seven – Working in Table Design View

01:00:00
Module Eight – Working with the Expression Builder

01:00:00
Module Nine – Working with External Data

01:00:00
Module Ten – Creating Queries

01:00:00
Module Eleven – Creating Forms and Reports

01:00:00
Module Twelve – Wrapping Up

00:30:00
Activities – Certified Microsoft Access Professional

Microsoft Outlook Advanced Level

13 lectures • 11 hour 30 mins

Module One – Getting Started

00:30:00
Module Two – Working with Messages

01:00:00
Module Three – Customizing Your Profile

01:00:00
Module Four – Advanced Email Tasks

01:00:00
Module Five – Managing Junk Mail

01:00:00
Module Six – Advanced Calendar Tasks

01:00:00
Module Seven – Doing More With Tasks

01:00:00
Module Eight – Using Notes

01:00:00
Module Nine – Viewing RSS Feeds

01:00:00
Module Ten – Printing

01:00:00
Module Eleven – Managing Outlook Data

01:00:00
Module Twelve – Wrapping Up

01:00:00
Activities- Accredited Microsoft Outlook Advanced

Mock Exam

0 lectures • 0 m: 0 s

Mock Exam- Advanced Diploma in Microsoft Office

Final Exam

0 lectures • 0 m: 0 s

Final Exam- Advanced Diploma in Microsoft Office

Order Your Certificate & Transcripts

1 lecture • 0 m: 0 s

Order Your Certificate & Transcripts

Certification

After successfully completing the course, you will be able to get the and internationally accepted certificate to share your achievement with potential employers or include it in your CV.

Student Reviews

Excellent

4.9 Average 11 Reviews

Reviews

Great learning experience with iStudy. Clear lessons and easy to follow. Really impressed.

Loved the flexibility. Studied at my own pace and finished quickly.

Excellent course quality. I feel more confident in my skills now.

iStudy delivered exactly what I needed. Very smooth process.

Customer support was fast and helpful. Got answers straight away.

Great platform. Well-structured lessons and simple navigation.

Really happy with the experience. The certificate arrived quickly.

Clear teaching style and easy to understand. Highly recommend.

Self-paced learning was a huge benefit. Finished around my schedule.

Great value for money. Quality courses and helpful support.

I enjoyed learning with iStudy. Everything was straightforward.

Quick, simple and informative. Made studying stress-free.

Fantastic support team. They resolved my issue in minutes.

Course material was clear and engaging. Very happy overall.

Loved the layout and simple step-by-step lessons.

Prompt certificate delivery. Really impressed with the service.

Good quality courses and easy platform to use.

Very convenient. Learned at my own pace without pressure.

Great experience from start to finish. Worth every penny.

Clear content, supportive team and fast responses. Highly recommend iStudy.

Frequently Asked Question

Are there any prerequisites for taking the course?

There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course.

Can I access the course at any time, or is there a set schedule?

You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience.

How long will I have access to the course?

For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime.

Is there a certificate of completion provided after completing the course?

Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks.

Can I switch courses or get a refund if I'm not satisfied with the course?

We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase.

How do I track my progress in the course?

Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course.

What if I have technical issues or difficulties with the course?

If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.