Get Access to Entire Course Library of 2000+ Courses at £99 Get Now
Course Overview
Take your Microsoft Office skills to a new level and gain full proficiency in Word, Excel, PowerPoint, Access and Outlook. This complete Diploma in Microsoft Office will teach you how to automate tasks with macros, create powerful work presentations, write professional business documents, and much more.
Through step-by-step audiovisual training, you will familiarise with the advanced tools and features of each program, taking you from beginner to expert in no time. In just a few days, you will be able to perform advanced tasks such as creating queries in Access, and will be able to work faster and much more efficiently when taking on day-to-day office tasks.
By the end of this Advanced Microsoft Office Training course, you will have the skills and confidence to utilise key Microsoft Office features and tools to customise your work and enhance your documents and slides to your liking. Not only that, but you will be able to add this qualification to your resume to instantly stand out to prospective employers!
Develop full proficiency in Microsoft Office and stand out to prospective employers!
What You Will Learn
In this Microsoft Office Diploma, you will develop full proficiency in Word, Excel, PowerPoint, Outlook and Access, guaranteeing your career prospects in any office-based role.
- Performing Advanced Editing & Formatting Tasks in Word
- Formatting Pictures and Adding SmartArt in Word
- Working With Illustrations in Word
- Adding Tables & Inserting Special Objects in Word
- Working With Document References in Word
- How to Automate Tasks With Macros In Excel
- Managing, Grouping & Outlining Data In Excel
- Inserting Text, Audio & Visual in PowerPoint
- Tips for Preparing Your PowerPoint Presentation
- Creating Queries, Reports & Reforms in Access
- Managing Junk Mail & Performing Advanced Calendar Tasks
Why You Should Choose This Course From iStudy
Study at your own pace
Full Tutor support on weekdays (Monday – Friday)
Fully compatible with any device
Free Printable PDF Certificate immediately after completion
No prior qualifications are needed to take this course
No hidden fees or exam charges
CPD Qualification Standards and IAO accredited
Efficient exam system, assessment, and instant results
Our customer support team is always ready to help you
Gain professional skills and better earning potential
Certification
After completing the course you’ll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9!
Accreditation
This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service.
Enrol today and learn something new with iStudy.
You’ll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We’re sure you’ll be satisfied with this course.
Course Curriculum
| Microsoft Word Advanced Level | |||
| 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 | 00:00:00 | ||
| Microsoft Excel Advanced Level | |||
| Module One – Getting Started | FREE | 01:00:00 | |
| Module Two – SmartArt and Objects | FREE | 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 | 00:00:00 | ||
| Microsoft PowerPoint Advanced Level | |||
| 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 | 00:00:00 | ||
| Microsoft Access Advanced Level | |||
| 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 | 00:00:00 | ||
| Microsoft Outlook Advanced Level | |||
| 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 | 00:00:00 | ||
| Mock Exam | |||
| Mock Exam- Advanced Diploma in Microsoft Office | 00:30:00 | ||
| Final Exam | |||
| Final Exam- Advanced Diploma in Microsoft Office | 00:30:00 | ||
FAQs
This course is for anyone who's interested in this topic and wants to learn more about it. This course will also help you gain potential professional skills.
No prior qualifications are needed to take this course.
You can study this course from wherever and whenever you want. You can study at your own pace and from any device. Just log in to your account from any device and start learning!
Yes, there is a test at the end of the course. Once you’ve completed all the modules of the course, you will have to give a multiple-choice test. The questions will be based on the topics of the modules you studied. And of course, you can take the test at any time, from any device and from anywhere you want.
Don’t worry if you fail the test, you can retake it as many times as you want.
You don’t have to wait a minute after your payment has been received, you can begin immediately. You will create your login details during the checkout process and we will also send you an email confirming your login details.
We make the payment process easy for you. You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. We use the latest SSL encryption for all transactions, so your order is safe and secure.
After you complete the course, you’ll immediately receive a free printable PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! You may have to wait for 3 to 9 days to get the hard copy certificate.
