Description

Description:

This Microsoft Office 2016 Excel Intermediate - Complete Video Course 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.

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 final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:

After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.

Certificates 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 Office 2016 Excel Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our Microsoft Office 2016 Excel Intermediate - 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 confidence to enrich yourself and brighten up your career in the relevant job market.

Working with Functions
	Work with Ranges	FREE	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
	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
Mock Exam
	Mock Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course		00:20:00
Final Exam
	Final Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course		00:20:00
Certificate and Transcript
	Order Your Certificates and Transcripts		00:00:00

Course Images

Microsoft Office 2016 Excel Intermediate - Complete Video Course

By John Academy

Booking options

Highlights

Description

About The Provider

Tags

Reviews