GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49 PER YEAR. FIND OUT MORE
Course Description
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.
-
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
-
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
-
Create Worksheet Formulas 00:15:00
-
Insert Functions 00:17:00
-
Reuse Formulas and Functions 00:17:00
-
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
-
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
-
Preview and Print a Workbook 00:10:00
-
Set Up the Page Layout 00:09:00
-
Configure Headers and Footers 00:07:00
-
Manage Worksheets 00:05:00
-
Manage Workbook and Worksheet Views 00:07:00
-
Manage Workbook Properties 00:06:00
-
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
-
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
-
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
-
Make Repetitive Edits 00:06:00
-
Apply Repetitive Formatting 00:10:00
-
Use Styles to Streamline Repetitive Formatting Tasks 00:14:00
-
Sort a List 00:05:00
-
Format a List 00:06:00
-
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
-
Insert Symbols and Special Characters 00:04:00
-
Add Images to a Document 00:11:00
-
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
-
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
-
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
-
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
-
Select a Presentation Type 00:08:00
-
Edit Text 00:13:00
-
Build a Presentation 00:27:00
-
Format Characters 00:11:00
-
Format Paragraphs 00:16:00
-
Format Text Boxes 00:09:00
-
Insert Images 00:10:00
-
Insert Shapes 00:15:00
-
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
-
Create a Table 00:09:00
-
Format a Table 00:03:00
-
Insert a Table from Other Microsoft Office Applications 00:06:00
-
Create a Chart 00:10:00
-
Format a Chart 00:10:00
-
Insert a Chart from Microsoft Excel 00:05:00
-
Review Your Presentation 00:11:00
-
Apply Transitions 00:05:00
-
Print Your Presentation 00:05:00
-
Deliver Your Presentation 00:08:00
-
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
-
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 Table Data 00:17:00
-
Sort and Filter Records 00:05:00
-
Create Basic Queries 00:15:00
-
Sort and Filter Data in a Query 00:14:00
-
Perform Calculations in a Query 00:08:00
-
Create Basic Access Forms 00:07:00
-
Work with Data on Access Forms 00:23:00
-
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
-
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
-
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
-
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
-
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
-
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
Course Reviews
No Reviews found for this course.
Comming Soon!
Original price was: £329.00.£19.99Current price is: £19.99.
SAVE 94% - Ends Soon!
or
All courses now £49
2000+ Globally Recognised Premium Courses
This course includes:
01 Year of full Course access
198 Units
2 Quizzes
3 days, 4 hours of total Unit + Quiz duration
