Microsoft Office 2016 Training - Advanced Level
-
I have found some interesting facts in this course, plus customer Service is excellent. Currently taking another course with 1Training.
← | →
-
You have all the information needed. The course has helped me to understand Microsoft office better and to improve my skills.
← | →
-
Totally enjoyable course. It will enhance my ability to use MS Office. I’m glad I chose it!
← | →
Course
Online
Become an expert at using Microsoft Office!
-
Type
Intensive course
-
Level
Advanced
-
Methodology
Online
-
Class hours
60h
-
Duration
Flexible
-
Online campus
Yes
Become an expert at using Microsoft Office with this Microsoft Office 2016 Training (Advanced Level) course, organized by 1 Training, that Emagister.co.uk has listed as part of its educational catalogue.
Microsoft Office is a collection of programs that can be utilized for both business and personal use. While already feature rich and critical for productivity, Microsoft continues to improve and enhance office package with each new release. Learning how to use Microsoft Office is an investment in both your personal and professional life.
By enrolling to this course, you’ll master key Microsoft Office programs, learn how to produce standard documents using word, gain knowledge of advance accounting calculations and about creative Power Point presentation skills.
Besides, every 1 Training course offers you the opportunity to study 24/7 wherever you are in the world. These intensive online courses are open to everyone, as long as you have an interest in the topic! They provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.
So, if you want more information about this programme contact 1 Training through Emagister.co.uk without hesitation. You won’t regret it!
Facilities
Location
Start date
Start date
About this course
By enrolling to this course, you’ll learn master key Microsoft Office programs.
In this course, you’ll be able to produce standard documents using word.
This course will gain knowledge in advance options of MS word.
Having this course, you’ll become master of MS excel worksheets.
In this course, you’ll gain knowledge of advance accounting calculations.
Logging in to this course, you’ll gain creative Power Point presentation skills.
On completion of this course, you’ll gain knowledge in database management.
At the end of this course, you’ll become expert in MS outlook e mail management system.
Job hunters & School leavers
College or University students, graduates & Teachers
Personal assistant & Receptionist
Assistant for company director
New or Temporary staff
Office Administrators & Office managers
Office clerk, Marketing assistant & Administration Assistant
Secretary or Executive
Account assistance, Bookkeeper & Accountant
IT professionals & Businessman
You’ll need a computer or tab with an internet connection and Microsoft Office software installed in it. Also, it’s better to have a notepad and a pen with you.
If you pass the exam successfully then you will be awarded a Certificate in Microsoft Office 2016 Advanced Level Training.
On receiving your request, one of our staff members will call you or send you a message by explaining everything about the course you are requesting information, including how you can sign up, payment options, exam, and enrollment requirements, etc.
Reviews
-
I have found some interesting facts in this course, plus customer Service is excellent. Currently taking another course with 1Training.
← | →
-
You have all the information needed. The course has helped me to understand Microsoft office better and to improve my skills.
← | →
-
Totally enjoyable course. It will enhance my ability to use MS Office. I’m glad I chose it!
← | →
Course rating
Recommended
Centre rating
Carlton Lee
Sabrina Hussain
Robert Nicole
Royston Wright
Tonya Ahmed
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 7 years
Subjects
- Receptionist
- Excel
- Word
- Powerpoint
- Access
- Presentation
- Database Management
- Office IT
- Microsoft Excel
- Microsoft Word
- Microsoft Powerpoint
- Database
- Database training
- Ms Office
- Microsoft excel training
- MS Excel
- Ms PowerPoint
- Presentation ppt
- Microsoft Access
- Power Point
- Microsoft Office
- Ms Word
- MS Outlook
- Bookkeeper
- Worksheets
- Vlookup and Hlookup
Teachers and trainers (1)
David Nicol
Course Administrator
Course programme
COURSE CURRICULUM
MICROSOFT WORD 2016 - BEGINNER
- Introduction to Microsoft Word
- First Step to MS Word
- Text Editing & Formatting
- Formatting Paragraph and Pages
- Creating Styles, Themes, Number and Bullets
- Columns & Tables
- Macros and Proofing
- Sharing and Reviewing Documents
- Modify Word Document
- Exercise Files: Microsoft Word 2016
MICROSOFT WORD 2016 - ADVANCE TRICKS AND TIPS
- Introduction Word 2016 Advance Tricks and Tips
- Set a Default Front for Documents
- Text Replacement and Autoformat Options
- Use Different Tools
MICROSOFT EXCEL 2016 - BEGINNER
- Getting Started with Microsoft Excel
- Data Entering
- Creating Formulas and Functions
- Formatting
- Worksheet Views, Multiple Worksheets and Workbooks
- IF, VLOOKUP, and Power Functions, Security & Sharing
- Data Management, Data Analysis Tools
- PivotTables & Macros
- Exercise Files: Microsoft Excel 2016
MICROSOFT EXCEL 2016 - ADVANCE FORMULAS & FUNCTIONS
- Introduction to Excel 2016 Advance Formula and Functions
- Values and Formulas
- Operations in Formulas
- IF, AND, OR and NOT Functions
- VLOOKUP and HLOOKUP
- Tabulating Data and Multiple Criteria
- Median, Mode and Ranking Data
- Date, Time and Functions
- Array Formulas and Frequency Functions
- OFFSET and INDIRECT Function
- Different TEXT & Information Functions
MICROSOFT EXCEL 2016 - ADVANCE FORMATTING AND TECHNIQUES
- Introduction to Excel Advance Formatting & Techniques
- Adjust Fonts, Font Sizes & Font Colours
- Adjust Cells and Tools
- Work with Formulas & Tables
- Adjust Row, Columns and Sheets
- Different Formatting Styles and Set up Data for Outlines
- Formatting Picture Styles
- Formatting Techniques – Restore Missing Data in a Column
MICROSOFT POWERPOINT 2016
- Getting Started with Microsoft PowerPoint
- Working with Presentations & Slides
- Adding Pictures & Contents to Slides
- Adding Shapes, Diagrams, Charts, Video, Audio, and Animation to Slides
- Preparing & Delivering the Presentation
- Reusing and Sharing Presentations
- Exercise Files: Microsoft PowerPoint 2016
MICROSOFT ACCESS 2016 - BEGINNER
- Introduction to MS Access
- Creating Tables & Setting up Properties
- Queries
- Creating Forms & Reports
- Working with Macros, Integrating Access with Office Suite
- Database Management
- Exercise Files- Microsoft Access 2016
MICROSOFT ACCESS 2016 - ADVANCE QUESTIONS IN DEPTH
- Introduction to Access 2016 Advance Questions in Depth
- Understanding Queries
- Query Criteria
- Parameters Queries
- Use Mathematical Operations and Functions
- Summarise Data with Aggregate Functions
- Dates, Time and Numbers Functions
- IF Function and Calculations
- Records and Database
- Explore the Basics of SQL
- Values, Database and Markup
MICROSOFT ACCESS 2016 - ADVANCE TRICKS AND TIPS
- Introduction to Trick and Tips of Access 2016
- Explore Startup Options
- Embed Queries in Reports
- Create a Back End and Front Ends
- Build the Forms and Reports
- Add Customised Functions and Visual Basics
MICROSOFT OUTLOOK 2016
- Introduction to MS Access
- Creating Tables & Setting up Properties
- Queries
- Creating Forms & Reports
- Working with Macros, Integrating Access with Office Suite
- Database Management
Course Duration:
You will have 2 Months (60 days) access to your online study platform from the date you purchased (enrolled) the course. The course is self-paced so you decide how fast or slow the training goes. If you need to extend your course access duration, it can be done at any time by extending your subscription.
How will I be assessed?
- At the end of the course you will have one Quiz test that will be marked automatically and you will be received an instant grade.
- You will have a mock exam that you can prepare yourself for the final exam. After successfully passed your exam, you only need to pay £30 for your certificate.
Additional information
Completing this training course will show any potential employer that you are comfortable and confident with using key Microsoft applications.
This Qualification is helpful for any Office job, such as PA, Secretary, and Administrator or any other role in the office environment. Being able to demonstrate you have a high level of Microsoft Office skills will help you stand out to employers.
Microsoft Office 2016 Training - Advanced Level