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

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.

Microsoft Office 2016 Excel Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and IAO. 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.

CPD

COURSE CURRICULUM

Getting Started with Microsoft Office Excel 2016

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help

• Performing Calculations

• Create Worksheet Formulas

• Insert Functions
• Reuse Formulas and Functions

• Modifying a Worksheet

• Insert, Delete, and Adjust Cells, Columns, and Rows

• Search for and Replace Data
• Use Proofing and Research Tools

• Formatting a Worksheet

• Apply Text Formats

• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates

• Printing Workbooks

• Preview and Print a Workbook

• Set Up the Page Layout
• Configure Headers and Footers

• Managing Workbooks

• Manage Worksheets

• Manage Workbook and Worksheet Views
• Manage Workbook Properties

• Working with Functions

• Work with Ranges

• Use Specialized Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions

• Working with Lists

• Sort Data

• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

• Analyzing Data

• Create and Modify Tables

• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

• Visualizing Data with Charts

• Create Charts

• Modify and Format Charts
• Use Advanced Chart Features

• Using PivotTables and PivotCharts

• Create a PivotTable

• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers

• Working with Multiple Worksheets and Workbooks

• Use Links and External References

• Use 3-D References
• Consolidate Data

• Using Lookup Functions and Formula Auditing

• Use Lookup Functions

• Trace Cells
• Watch and Evaluate Formulas

• Sharing and Protecting Workbooks

• Collaborate on a Workbook

• Protect Worksheets and Workbooks

• Automating Workbook Functionality

• Apply Data Validation

• Search for Invalid Data and Formulas with Errors
• Work with Macros

• Creating Sparklines and Mapping Data

• Create Sparklines

• MapData

• Forecasting Data

• Determine Potential Outcomes Using Data Tables

• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
• Forecasting Data Trends

Assessment and Certification:

Upon completion of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and the results will be given to you immediately. Before sitting your final exam you will have the opportunity to test your proficiency with a mock exam. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of GBP24 for a PDF copy and GBP39 for an original print copy sent to you by post

We are a company who is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level.

As an online learning site, we are aware of the fact that there are a lot of people out there who considers themselves to be a curious learner but the courses that they are interested in are not available in the area. So, we have decided to give them a chance to learn in a convenient way – in their own convenient place and time.