3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
LOGIN
HOME / COURSE / MICROSOFT OFFICE / EXCEL / VIDEO COURSE / DIPLOMA IN MICROSOFT OFFICE 2016 EXCEL
Diploma in Microsoft O ce 2016 Excel ( 8 REVIEWS )
HOME
591 STUDENTS
CURRICULUM
REVIEWS
Microsoft has provided us with various useful O ce tools over the years and the 2016 version of Excel is one of them. Statistics suggest that Excel is the most used spreadsheet program in the world, which is why you should heed this Diploma in Microsoft O ce 2016 Excel course. This course will help you master the basics of excel, perform calculations, modify & format worksheets, and print & manage workbooks. Following which you will learn about working with functions & lists, analyze data, visualize data through charts, and use PivotTables & PivotCharts. The advanced portion of the course will cover multitasking, collaborating, automating functionality and much more. Finally given the audio visual interface used, this is a must have course for anyone looking to learn Excel.
Course Highlights Internationally recognised accredited certi cation on successful completion https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
1/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Free accredited e-certi cate Study at your own pace, anytime and anywhere Access to all courses with a monthly membership plan of £29 High quality video and text course materials E cient exam system, assessment and instant results Improve your chance of gaining professional skills and better earning potential Eligibility for NUS Extra card which gives you a discount from thousands of retailers
Requirements There is no experience or previous quali cations required for enrolment on this course. It is available to all students of all academic backgrounds.
Assessment and Certi cation You can test your learning as you progress through the course by undertaking mock tests. On completion of the course, there will be an assessment consisting of multiple choice questions for which the pass mark is 60%. On passing, you will gain instant access to your e-certi cate. PDF and hard copy certi cates can be ordered for an additional fee. PDF Certi cate – £9 Hardcopy by Post- £19 Both PDF and Hardcopy – £24
Tutor Support With all our courses, you will receive access to dedicated tutors and technical support. You will also be provided with unlimited email, phone and live chat support to help answer any questions you might have whilst studying the course.
Course Compatibility All our courses are fully compatible with PC’s, Mac’s, tablets and smartphones.
Career Path Completing this course will help you to increase your knowledge and improve your skills and instil in you the con dence to progress. You will also be able to add your quali cation to your CV, enhance your career and become more competitive within your chosen industry.
COURSE CURRICULUM
Getting Started with Microsoft O
ce Excel 2016
Navigate the Excel User Interface
00:28:00
Use Excel Commands
00:10:00
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
2/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Create and Save a Basic Workbook
00:19:00
Enter Cell Data
00:12:00
Use Excel Help
00:05:00
Performing Calculations
Create Worksheet Formulas
00:15:00
Insert Functions
00:17:00
Reuse Formulas and Functions
00:17:00
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
00:10:00
Search for and Replace Data
00:09:00
Use Proo ng and Research Tools
00:07:00
Formatting a Worksheet
Apply Text Formats
00:17:00
Apply Number Formats
00:08:00
Align Cell Contents
00:09:00
Apply Styles and Themes
00:12:00
Apply Basic Conditional Formatting
00:11:00
Create and Use Templates
00:07:00
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
3/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Printing Workbooks
Preview and Print a Workbook
00:10:00
Set Up the Page Layout
00:08:00
Con gure Headers and Footers
00:07:00
Managing Workbooks
Manage Worksheets
00:05:00
Manage Workbook and Worksheet Views
00:07:00
Manage Workbook Properties
00:05:00
Working with Functions
Work with Ranges
00:18:00
Use Specialized Functions
00:11:00
Work with Logical Functions
00:23:00
Work with Date & Time Functions
00:08:00
Work with Text Functions
00:11:00
Working with Lists
Sort Data
00:10:00
Filter Data
00:10:00
Query Data with Database Functions MFR
00:09:00
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
4/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Outline and Subtotal Data
00:09:00
Analyzing Data
Create and Modify Tables
00:15:00
Apply Intermediate Conditional Formatting
00:07:00
Apply Advanced Conditional Formatting
00:05:00
Visualizing Data with Charts
Create Charts
00:13:00
Modify and Format Charts
00:12:00
Use Advanced Chart Features
00:12:00
Using PivotTables and PivotCharts
Create a PivotTable
00:13:00
Analyze PivotTable Data
00:12:00
Present Data with PivotCharts
00:07:00
Filter Data by Using Timelines and Slicers
00:11:00
Working with Multiple Worksheets and Workbooks
Use Links and External References
00:12:00
Use 3-D References
00:06:00
Consolidate Data
00:05:00
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
5/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Using Lookup Functions and Formula Auditing
Use Lookup Functions
00:12:00
Trace Cells
00:09:00
Watch and Evaluate Formulas
00:08:00
Sharing and Protecting Workbooks
Collaborate on a Workbook
00:19:00
Protect Worksheets and Workbooks
00:08:00
Automating Workbook Functionality
Apply Data Validation
00:13:00
Search for Invalid Data and Formulas with Errors
00:04:00
Work with Macros
00:18:00
Creating Sparklines and Mapping Data
Create Sparklines
00:07:00
MapData
00:07:00
Forecasting Data
Determine Potential Outcomes Using Data Tables
00:08:00
Determine Potential Outcomes Using Scenarios
00:09:00
Use the Goal Seek Feature
00:04:00
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
6/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Forecasting Data Trends
00:05:00
Mock Exam Final Exam
COURSE REVIEWS
4.7 8 ratings
5 STARS
0
4 STARS
0
3 STARS
0
2 STARS
0
1 STARS
0
NO REVIEWS FOUND FOR THIS COURSE.
RELATED COURSES https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
7/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Diploma in Microsoft O ce Excel 2013
£279.00 £29.00
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
470
8/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Diploma in Microsoft O ce 2013 Word
£279.00 £29.00
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
488
9/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Diploma in Microsoft O ce PowerPoint 2013
£279.00 £29.00 489
TAKE T H I S COURSE
£350.00 £29.00
1 YEAR ADVANCED, BEGINNER, INTERMEDIATE COURSE BADGE COURSE CERTIFICATE NUMBER OF UNITS https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
59 10/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
0
NUMBER OF QUIZZES
10 HOURS, 25 MINUTES
Instructors GARY CARROLL
591 STUDENTS ENROLLED
APPROVED COURSE CENTRE
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
11/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
î…˛ îƒś
OUR STUDENTS SAY.. An extremely helpful and informative Great Course Content! Learn from course, especially in conjunction with quiz anywhere using personal devices and and video tutorial. Video is a good way to learn.
Mike
Kiara
Student, Finance
Student
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
Course content are awesome! course I had this time.
Ginny Student
12/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
OUR COURSES PARTNERS
Registered with the UK Register of Learning Providers (UKRLP) UKPRN: 10063816
All Visio Learning students are entitled to apply for an NUS card
YOU MAY LEARN Windows Server 2008 Applications Infrastructure Training Diploma
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
13/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Windows Server 2008 Applications Infrastructure Training Diploma BY TAYLOR CHRISTOPHER
Con guring Windows Devices – 70-697 BY JAC WALSH
Accounting Skills Training Diploma BY JOHN ADAMS
Active Listening Training Diploma BY JOHN ADAMS
Administrative Assistant Skills Training BY ALVERT
Advanced Server Infrastructure Implementing Diploma BY JAC WALSH
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
14/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
Advanced Windows Server 2012 R2 Services (MCSA/MCSE) Con guring Diploma BY NICHOLAS ALVARADO
Agile Master Training Diploma BY NICHOLAS ALVARADO
Appreciative Inquiry Diploma BY NICHOLAS ALVARADO
Attention Management Diploma BY BRECKEN EMERSON
ABOUT We are a company who is best known for offering awarding body accredited courses for anyone who wishes to take their professional life to the next level. 15 St Botolph St, London EC3A 7DT, United Kingdom. 020 3743 0883 info@visiolearning.co.uk CERTIFICATE CODE Enter Certi cate Code
VALI DAT E https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
15/16
3/6/2018
Diploma in Microsoft Office 2016 Excel - Visio Learning
IMPORTANT LINKS About Us FAQ Terms & Conditions Privacy Policy Cookie Policy Contact Us COMING SOON
© VISIO LEARNING.
https://www.visiolearning.co.uk/course/diploma-in-microsoft-office-2016-excel/
16/16