About this Course:

This beginner-level course is designed for professionals who are willing to gain first-hand knowledge of Microsoft Excel 2016. This course helps professionals build familiarity with key features and functions of Excel 2016. Professionals get to learn basic functions such as Spreadsheet Creation, Tables & Graphs Insertion, and other fundamental functions. This course covers the key concepts of Excel 2016 such as Ribbon and Quick Access Toolbar, Interface, Backstage View, Shortcuts, and many more.

Professionals will also get to learn the fundamental functions of Excel 2016 including Worksheet Designs & Themes, Freezing Panes Option, Customized Viewing, and Worksheets Grouping. Professionals having the surface knowledge of the Microsoft Excel 2013 fundamentals can greatly benefit from this course and will get to know about the upgrades and new features in the 2016 version.

Course Objectives:

The core objective of this course is to help professionals develop a better understanding and sound knowledge of the following key concepts:

• Knowhow of Ribbon and Quick Access Toolbar
• Microsoft Excel Backstage View, Interface, and Share Pane
• Excel Smart Lookup Feature and Navigations
• Microsoft Excel Shortcut Keys & Data Insertion
• Number Formatting and Deletion in Excel 2016
• Microsoft Excel 2016 AutoSum and Cell Styling
• Worksheet Designs and Themes
• Microsoft Excel Templates
• Grouping of Worksheets in Excel
• Customized Viewing Options
• Freezing Panes Option in Microsoft Excel

Audience:

• Microsoft Excel Beginners and Entry-Level Professionals
• Professionals striving to learn the new features and functionalities of Excel 2016
• Candidates willing to learn Excel from a Business Analysis & Productivity Standpoint

Prerequisites:

There are no prerequisites for the Excel 2016 Intermediate Course. However, it is highly encouraged for professionals to keep in mind the following recommendations:

• Fundamental Knowledge of Working with Microsoft Excel 2013
• Excel 2013 Beginner Course is Recommended before registering in this course