Microsoft excel 2016 intermediate-john academy

05/12/2017

Microsoft Excel 2016 Intermediate - John Academy LOGIN

HOME / COURSE / MICROSOFT OFFICE / EXCEL / MICROSOFT EXCEL 2016 INTERMEDIATE

Microsoft Excel 2016 Intermediate ( 8 REVIEWS ) 

527 STUDENTS

Description: This will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. …

TAKE THIS COURSE

£249.00 £14.00

   

1 YEAR INTERMEDIATE COURSE BADGE COURSE CERTIFICATE

25

NUMBER OF UNITS

0

NUMBER OF QUIZZES



12 HOURS, 30 MINUTES



HOME







CURRICULUM

REVIEWS

https://www.johnacademy.co.uk/course/microsoft-excel-2016-intermediate/

1/4

05/12/2017

Microsoft Excel 2016 Intermediate - John Academy

Description: This Microsoft Excel 2016 Intermediate will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level.

If you have equivalent knowledge of Microsoft Excel 2016 Introduction then this course is perfect for you to expand your knowledge and skills. So, if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations you can join this course.

You will also work with charts and advanced formatting including styles.

So, why are you thinking? Come and be a part of this course now.

Learning Outcomes: Creating advanced formulas through utilizing range names in formulas and functions and specialized functions Analyze data using text, logical, lookup, date and nancial functions Create and modify tables, sort and lter data, using subtotal features, and working with database functions Creating trendline, advanced charts, also formatting and modifying charts in order to visualize data Using PivotTables, slicers and PivotCharts to analyze data Incorporate SmartArt, as well as insert, modify, layer and group graphical objects Customize workbooks, manage themes, and create and use templates Preparing and protecting workbooks for multiple users

Assessment: 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 Excel 2016 Intermediate 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 Excel 2016 Intermediate 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



Apply Range Names



00:30:00



Use Specialized Functions



00:30:00



Use Text Functions



00:30:00



Use Logical Functions



00:30:00



Use Lookup Functions



00:30:00



Use Date Functions



00:30:00



Use Financial Functions



00:30:00



Create and Modify Tables



00:30:00

https://www.johnacademy.co.uk/course/microsoft-excel-2016-intermediate/

2/4

05/12/2017

Microsoft Excel 2016 Intermediate - John Academy



Sort and Filter Data



00:30:00



Use Subtotal and Database Functions to Calculate Data



00:30:00



Create Charts



00:30:00



Modify and Format Charts



00:30:00



Create a Trendline



00:30:00



Create Advanced Charts



00:30:00



Create a PivotTable



00:30:00



Filter Data by Using Slicers



00:30:00



Analyze Data with PivotCharts



00:30:00



Insert and Modify Graphic Objects



00:30:00



Layer and Group Graphic Objects



00:30:00



Incorporate SmartArt



00:30:00



Customize Workbooks



00:30:00



Manage Themes



00:30:00



Create and Use Templates



00:30:00



Protect Files



00:30:00



Preparing a Workbook for Multiple Audiences



00:30:00

Mock Exam Final Exam

COURSE REVIEWS

4.9   8 ratings

https://www.johnacademy.co.uk/course/microsoft-excel-2016-intermediate/

3/4

05/12/2017

Microsoft Excel 2016 Intermediate - John Academy

5 STARS

0

4 STARS

0

3 STARS

0

2 STARS

0

1 STARS

0

NO REVIEWS FOUND FOR THIS COURSE.

RELATED COURSES

Microsoft Internet Explorer 6

£199.00 £10.00  

https://www.johnacademy.co.uk/course/microsoft-excel-2016-intermediate/

511

4/4