Type and hit enter to Search
×

Introduction to Microsoft Excel 2016

  • 4.6(45,336 Rating)

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.

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 July 2024
Introduction to Microsoft Excel 2016
15 October 2024
Introduction to Microsoft Excel 2016
15 January 2025
Introduction to Microsoft Excel 2016
15 April 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.

Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?