8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - John Academy
LOGIN
HOME / COURSE / MICROSOFT OFFICE / EXCEL / VIDEO COURSE / MICROSOFT OFFICE 2016 EXCEL BEGINNERS - COMPLETE VIDEO COURSE
Microsoft O ce 2016 Excel Beginners Complete Video Course ( 8 REVIEWS )
493 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-beginners-complete-video-course/
1/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - John Academy
£350.00 £17.00
1 YEAR BEGINNER COURSE BADGE COURSE CERTIFICATE
23
NUMBER OF UNITS NUMBER OF QUIZZES
2
4 HOURS, 55 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. Therefore after completing this 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 di erent 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-beginners-complete-video-course/
2/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - 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 Beginners – Complete Video Course 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 Beginners – Complete Video Course 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
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-beginners-complete-video-course/
FREE
00:28:00
00:10:00
3/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - 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-beginners-complete-video-course/
4/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - 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
00:20:00
00:20:00
Mock Exam
-
Mock Exam- Microsoft O Video Course
ce 2016 Excel Beginners – Complete
Final Exam
-
Final Exam- Microsoft O Course
ce 2016 Excel Beginners – Complete Video
COURSE REVIEWS
4.7 https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-beginners-complete-video-course/
5/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - John Academy
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-beginners-complete-video-course/
6/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - John Academy
Microsoft Excel Basics
£199.00 £10.00 492
Microsoft O
ce Essential Skills
£269.00 £14.00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-beginners-complete-video-course/
488
7/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - John Academy
Workplace Essential Training: Team Player
£199.00 £10.00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-beginners-complete-video-course/
588
8/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - John Academy
Workplace Essential Training: Collaboration
£199.00 £10.00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-beginners-complete-video-course/
564
9/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - John Academy
Progressive Employer Training
£199.00 £10.00
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-beginners-complete-video-course/
583
10/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - John Academy
Microsoft Power BI
£199.00 £10.00 527
493 STUDENTS ENROLLED
HAVE YOU ANY INQUIRY?
https://www.johnacademy.co.uk/course/microsoft-office-2016-excel-beginners-complete-video-course/
11/12
8/13/2018
Microsoft Office 2016 Excel Beginners - Complete Video Course - 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-beginners-complete-video-course/
12/12