Microsoft Office 2016 Excel Beginners - Complete Video Course - John Academy

Page 1

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


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.