Introduction to Microsoft Excel 2016

Overview Schedule Dates Course Content Faqs

Course Overview

The Professional Excel 2016 training course is a comprehensive program structured to help professionals master the popular data spreadsheet software. During this training, participants will be taught to create and develop Excel worksheets and workbooks to analyze critical business data. With this Excel 2016 Part 1 course, participants will be able to develop foundational data manipulation skills and knowledge that can give them a competitive edge in the job market. By the end of this training, participants would have the confidence to use one of the world’s most powerful applications that are highly sought after for many job roles across industries.

Course Outcome

Successful completion of the Excel 2016 Part 1 course will help you to:

Comprehend a range of fundamental functions and commands of Excel.
Learn how to perform worksheet calculations in Excel.
Understand Excel formulas and how to build custom formulas.
Learn to amend elements in a worksheet.
Describe how workbook properties are managed.

Demand & Opportunities

Excel skills are often required for many job positions, especially those in finance and accounting, and are often considered a prerequisite for higher-level roles. The Excel 2016 course imparts skills and knowledge essential for making high-demand job opportunities easier to avail.

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Target Audiance

Office Administrators seeking to enhance their data management skills.
Small Business Owners wanting to streamline their financial tracking and reporting.
Financial Analysts aiming to improve their data analysis and visualization techniques.
Human Resource Managers looking to efficiently organize and analyze employee data.

Schedule Dates

Introduction to Microsoft Excel 2016

15 October 2024

Introduction to Microsoft Excel 2016

15 January 2025

Introduction to Microsoft Excel 2016

15 April 2025

Introduction to Microsoft Excel 2016

15 July 2025

Course Content

Starting Microsoft Excel
Creating a Workbook
Saving a Workbook
The Status Bar
Adding and Deleting Worksheets
Copying and Moving Worksheets
Changing the Order of Worksheets
Splitting the Worksheet Window
Closing a Workbook

Tabs
Groups
Commands

Introduction to the Backstage View
Opening a Workbook
New Workbooks and Excel Templates
Printing Worksheets
Adding Your Name to Microsoft Excel
Managing Workbook Versions

Adding Common Commands
Adding Additional Commands with the Customize Dialog Box
Adding Ribbon Commands or Groups
Placement

Entering Text
Expand Data across Columns
Adding and Deleting Cells
Adding an Outline
Adding a Hyperlink
Add WordArt to a Worksheet
Using AutoComplete
Entering Numbers and Dates
Using the Fill Handle

Hiding Worksheets
Adding Color to Worksheet Tabs
Adding Themes to Workbooks
Adding a Watermark
The Font Group
The Alignment Group
The Number Group

Math Operators and the Order of Operations
Entering Formulas
AutoSum (and Other Common Auto-Formulas)
Copying Formulas and Functions
Relative, Absolute, and Mixed Cell References

FAQs

The course covers basic Excel functionalities including an introduction to the Excel interface, entering and formatting data, using formulas and functions, creating and modifying charts, sorting and filtering data, and basic data analysis techniques

This course is intended for beginners who have little to no experience with Excel. It is suitable for students, professionals, and anyone looking to enhance their data management and analysis skills.

No prior knowledge of Excel is required. The course is designed to start with the basics and progressively cover more advanced features.

Yes, most training providers offer a certificate of completion to participants who successfully finish the course

Participants are usually required to bring their own laptops with Microsoft Excel 2016 installed. Some training centers may provide computers for use during the course.