Advanced Microsoft Office 2016

Study 365

Add to wishlist

Duration / Course length: Upto 40 Hours Start now
Accredited by: CPDiAP
Certificates:
Sample certificate
Course delivery: This course is delivered in video format

Course details

To prove that you can use Microsoft Office, the most popular database management software, get a recognised qualification from Study365. Enhance your CV and give yourself an advantage.
Most organisations use Microsoft Office and we can show you how to get the most out of it. This course aims to give essential skills and enables you to produce professional work using the Microsoft Office suite, including Word, Excel, PowerPoint, and Access. Whether you are a beginner or have some experience with Office, this course covers everything and you can go through the material at your own ;This course bundle includes both basic and advance features of Microsoft Word 2016, Excel 2016, PowerPoint 2016, and Outlook 2016.
There are five core subjects focusing on each of the Microsoft Office software packages, such as Word, Excel, PowerPoint, Outlook, and ;The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.
This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests, and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

Course Curriculum

1. 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

2. Microsoft ord 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

3. 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

4. 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

5. MIicrosoft 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

6. 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

;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

8. 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

9. 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

Course Duration:

You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.

Method of Assessment:

At the end of the course, learners will take an online multiple choice question assessment test. The online test is marked straightaway, so you will know immediately if you have passed the course.

Certification:

Successful candidates will be awarded certificate for “Advanced Microsoft Office 2016 Training”.

PLEASE NOTE:
We do not provide Microsoft Office 2016 software with this course, this must be installed on your computer separately.
Helpful Link for Software Downloading: Click for Download

Updated on 23 February, 2024

Eligibility / Requirements

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Job roles this course is suitable for:

Secretary , Business Developer , Administrative Assistant , Personal Assistant , Office Administrator , Office Manager

About Study 365

Study 365 is an online course provider, offering more than 400 courses to students across the globe. We have built a solid reputation which has elevated us to become one of the most trusted and reliable course providers in the online learning marketplace. With over 100,000 students on our books, we’re the preferred choice for many online learners.

Unrivalled choice

At Study 365, we offer a diverse range of online courses, where students can study everything from accounting, to design, beauty therapy, IT and education and training. All of our courses are completely relevant to the real world, so you can gain vital skills applicable to your chosen career.

Accessible and affordable

We aim to make it easy to help you gain new skills, so you’ll find that many of our courses are open to students without previous experience or qualifications. Of course, if you’re looking for a course that builds on existing skills, we offer these too, in which case, entry requirements may be stipulated. Crucially, our courses are affordable, making it easy for anyone to kick-start a new career.

Informative and secure

With our comprehensive course information, we make it simple for you to decide if a particular course is right for you. As well as detailing what the course involves, we reveal who might suit the course, and what career path you could take with it. With real student reviews, you can also find out what others have to stay from their experience of a course.
Once you’ve chosen a course, getting started is quick and fuss-free. Our online system is very secure, so your personal details will be kept safe at all times.

Learn at your own pace

Many people choose to study online because they have other commitments in their daily lives, such as juggling family and work. The beauty of learning through Study 365 is that you can learn at your own pace in the comfort of your own home, at any time of day or night, on any device, to suit your personal circumstances. This flexibility means studying with us is easy, even if your life is already busy.

Expert tutor support

Although you learn on your own with our courses, we appreciate that you’ll need expert guidance to make sure you’re on the right track and to offer support as and when it’s needed. That’s why each course is supported by professional tutors who are experienced and knowledgeable in your chosen course topic.

As good as the classroom

As an expert online course provider, we understand that students expect the same level of course quality as if they were in a classroom situation. At Study 365, all of our courses have been meticulously designed, so they easily rival any style of course offered in a classroom setting.

Versatile and motivated learning

We appreciate that some students can find it hard to motivate themselves to learn online under their own initiative, so we’ve tried to make the courses as inspiring and interesting as possible, to ensure students stay motivated, from start to finish. Tuition comes in the form of professional video tutorials, narrated e-learning modules, interactive quizzes, tests and exams.