Learn what is new in MS Excel 2016, as well as explore the Excel 2016 platform.
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.
Skills you’ll gain
Microsoft ExcelSpreadsheetsAppSheetExcel MacrosExcelPackageMicrosoft Office Specialist (MOS) - ExcelWhat 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.
Transcript
Show transcript (free preview lesson)
Transcript of the free preview lesson. Remaining lessons unlock with the full course.
Microsoft Excel has all the features and functionality you’ve come to expect from Microsoft’s premier spreadsheet program. It is one of the most widely used industry standard tools in Data Management. Our Microsoft Excel 2016 Introduction course will give you a basic understanding of how to get started with Excel as well as the new features for 2016. This course will help you to: Get up and running by learning to navigate the Excel 2016 Software Interface. Customize your worksheets by learning Formatting and Modifying Worksheets. Save time and complete tasks more efficiently using Basic Formulas and Functions. And make your data stand out by adding Charts and Graphics. Give your data a competitive edge by learning the fundamentals of spreadsheets with Microsoft Excel 2016: Introduction
Learn on the Go
Take your learning anywhere — the KnowledgeCity mobile app lets you watch lessons on the go.