Description

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 find 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 prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. 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:

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 Complete Video Course - Beginner, Intermediate & Advanced 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 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 confidence to enrich yourself and brighten up your career in the relevant job market.

Getting Started with Microsoft Office Excel 2016
	Navigate the Excel User Interface	FREE	00:28:00
	Use Excel Commands		00:10:00
	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 Proofing 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
Printing Workbooks
	Preview and Print a Workbook		00:10:00
	Set Up the Page Layout		00:08:00
	Configure 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	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
Working with Multiple Worksheets and Workbooks
	Use Links and External References	FREE	00:12:00
	Use 3-D References		00:06:00
	Consolidate Data		00:05:00
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
	Forecasting Data Trends		00:05:00
Refer A Friend
	Refer A Friend		00:00:00
Certificate and Transcript
	Order Your Certificates and Transcripts		00:00:00

Course Images

Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced

By John Academy

Booking options

Highlights

Description

About The Provider

Tags

Reviews