Skip to content
KnowledgeCity

Excel 2016 Introduction

Learn what is new in MS Excel 2016, as well as explore the Excel 2016 platform.
Preview the first lesson free — get full access to all 81 lessons.
Course: On-Demand
Beginner Provider Lori Robinson  9 chapters ·  81 Lessons ·  5h 1m  in Arabic, English, Spanish 

Course Description

Microsoft Excel spreadsheets provide users with a powerful program for storing, organizing, and manipulating data. This course serves as an introduction for users with a novice to intermediate amount of experience using the program. Users will learn how to create a new workbook, insert charts, use formulas, and much more. In addition to introductory concepts, this online training course also provides information about the newest features within the 2016 Microsoft Excel update.

What You'll Learn

  • Create new workbooks and enter text, numbers, and dates into cells
  • Edit data using AutoFill, Find and Replace, and Undo and Redo
  • Insert charts and use formulas to organize and manipulate data
  • Customize the interface with the Quick Access Toolbar, Ribbon, KeyTips, and Status Bar
  • Format cells with font styles, alignment, borders, backgrounds, and the Format Painter
  • Explore the new features introduced in the 2016 Microsoft Excel update

Key Takeaways

  • Microsoft Excel spreadsheets provide a powerful program for storing, organizing, and manipulating data.
  • The course introduces creating new workbooks, inserting charts, using formulas, and more.
  • It covers introductory concepts as well as the newest features within the 2016 Microsoft Excel update.
  • Lessons include navigating the interface, entering and editing data, and formatting cells.
  • The course is intended for users with a novice to intermediate amount of experience with the program.

Frequently Asked Questions

Who is this course for?

It serves as an introduction for users with a novice to intermediate amount of experience using Microsoft Excel.

What does this course cover?

Users learn how to create a new workbook, insert charts, use formulas, and much more, along with information about the newest features in the 2016 Microsoft Excel update.

What skills will I gain?

The course covers Microsoft Excel, Spreadsheets, AppSheet, Excel Macros, ExcelPackage, and Microsoft Office Specialist (MOS) - Excel.

Does this course cover the 2016 update features?

Yes, in addition to introductory concepts it provides information about the newest features within the 2016 Microsoft Excel update.

What topics are taught about working with data?

Lessons cover creating workbooks, selecting cells, entering text, numbers, and dates, editing data, entering data with AutoFill, finding and replacing data, using Undo and Redo, adding comments, and saving workbooks.