8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
LOGIN
HOME / COURSE / MICROSOFT OFFICE / EXCEL / VIDEO COURSE / MICROSOFT OFFICE 2016 EXCEL COMPLETE VIDEO COURSE - BEGINNER, INTERMEDIATE & ADVANCED
Microsoft O ce 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced ( 8 REVIEWS )
499 STUDENTS
Description: Microsoft Excel, developed by Microsoft Corporation, is world’s leading spreadsheet program for Windows, macOS, Android and iOS. The program …
TAKE THIS COURSE
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
1/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
£379.00 £25.00
1 YEAR ADVANCED, BEGINNER, INTERMEDIATE COURSE BADGE COURSE CERTIFICATE
59
NUMBER OF UNITS
0
NUMBER OF QUIZZES
10 HOURS, 25 MINUTES
HOME
CURRICULUM
REVIEWS
Description: Microsoft Excel, developed by Microsoft Corporation, is world’s leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly nd any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts – beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a proli c user of the program. As the course is sectioned based on the level of di culty, you will know the basics of Excel at rst. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company.
Assessment: https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
2/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your nal exam you will have the opportunity to test your pro ciency with a mock exam.
Certi cation: After completing and passing the course successfully, you will be able to obtain an Accredited Certi cate of Achievement. Certi cates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
Who is this Course for? Microsoft O ce 2016 Excel Complete Video Course – Beginner, Intermediate & Advanced is certi ed by CPD Quali cations Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and quali cation required for this course, it is available for all students from any academic background.
Requirements Our Microsoft O ce 2016 Excel Complete Video Course – Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path After completing this course you will be able to build up accurate knowledge and skills with proper con dence to enrich yourself and brighten up your career in the relevant job market. COURSE CURRICULUM
Getting Started with Microsoft O
Navigate the Excel User Interface
Use Excel Commands
ce Excel 2016 FREE
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
00:28:00
00:10:00
3/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
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 Format
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.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
4/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
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
00:09:00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
5/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
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
00:12:00
Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
00:06:00
Consolidate Data
00:05:00
FREE
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
6/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
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.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
7/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
Forecasting Data Trends
00:05:00
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.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
8/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
Microsoft Excel Basics
£199.00 £10.00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
492
9/15
8/13/2018
Microsoft O
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
ce Essential Skills
£269.00 £14.00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
488
10/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
Workplace Essential Training: Team Player
£199.00 £10.00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
588
11/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
Workplace Essential Training: Collaboration
£199.00 £10.00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
564
12/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
Progressive Employer Training
£199.00 £10.00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
583
13/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
Microsoft Power BI
£199.00 £10.00 527
499 STUDENTS ENROLLED
HAVE YOU ANY INQUIRY?
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
14/15
8/13/2018
Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced - John Academy
Full Name *
Your Email *
Telephone
Message *
By submitting your information, you agree to the terms and conditions stated in our Privacy Policy
Submit
ABOUT We are a company who is best known for o ering awarding body accredited courses for anyone who wishes to take their professional life to the next level. 11 Floor, 15 St Botolph Street, London EC3A 7BB 020 3744 3990 info@johnacademy.co.uk CERTIFICATE CODE Enter Certi cate Code https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-complete-video-course-beginner-intermediate-advanced/
15/15