Entdecken Sie, was
Sie lernen können.Mit Videokursen für Beruf, Studium und Freizeit.
Microsoft Excel 2016 can help you organize, calculate, analyze, revise, update, and present your data in ways that will help you or other decision makers in your organization steer you in the right direction.
This course provides you with a foundation for Excel knowledge and skills, which you can build upon to become an expert in Excel 2016.
The instructor will explain all of the features and functionalities the application offers in an easy to understand, step-by-step method.
Exercise files are available to assist you. They can be downloaded and used to follow along with the trainer.
It’s easy to validate your knowledge with our end of chapter Quizzes.
Navigate the Excel User Interface: Introduction | 00:40 |
Navigate the Excel User Interface | 06:18 |
Use Excel Commands: Introduction | 00:41 |
Use Excel Commands | 04:14 |
Create and Save a Basic Workbook: Introduction | 00:29 |
Create and Save a Basic Workbook | 05:01 |
Enter Cell Data: Introduction | 00:29 |
Enter Cell Data | 05:15 |
Flash Fill and Auto Fill | 04:42 |
Use Excel Help: Introduction | 00:47 |
Use Excel Help | 03:13 |
Quiz zum Kurs „Getting Started with Excel 2016 (EN)“ |
Create Worksheet Formulas: Introduction | 00:35 |
Create Worksheet Formulas | 05:54 |
Insert Functions: Introduction | 01:09 |
Insert Functions | 05:44 |
Reuse Formulas and Functions: Introduction | 00:58 |
Reuse Formulas and Functions | 05:02 |
Quiz zum Kurs „Performing Calculations in Excel 2016 (EN)“ |
Insert, Delete and Adjust Cells, Columns and Rows: Introduction | 00:17 |
Insert, Delete and Adjust Cells, Columns and Rows | 04:48 |
Search for and Replace Data: Introduction | 00:18 |
Search for and Replace Data | 06:18 |
Use Proofing and Research Tools | 00:17 |
Check the Spelling in a Worksheet | 03:08 |
Insights Task Pane | 03:04 |
Quiz zum Kurs „Modifying a Worksheet in Excel 2016 (EN)“ |
Apply Text Formats: Introduction | 00:36 |
Apply Text Formats | 06:06 |
Apply Number Formats: Introduction | 00:57 |
Apply Number Formats | 03:15 |
Align Cell Contents: Introduction | 00:27 |
Align Cell Contents | 00:23 |
Apply Cell Styles and Themes: Introduction | 00:23 |
Apply Cell Styles and Themes | 05:59 |
Apply Basic Conditional Formatting: Introduction | 00:50 |
Apply Basic Conditional Formatting | 03:38 |
Create and Use Templates: Introduction | 00:31 |
Create and Use Templates | 04:22 |
Quiz zum Kurs „Formatting a Worksheet in Excel 2016 (EN)“ |
Preview and Print a Workbook | 00:30 |
Configure and Preview a Print Job | 03:02 |
Set Up the Page Layout: Introduction | 00:21 |
Set Up the Page Layout | 03:59 |
Configure Headers and Footers: Introduction | 00:28 |
Configure Headers and Footers | 02:13 |
Quiz zum Kurs „Printing Workbooks in Excel 2016 (EN)“ |
Manage Worksheets: Introduction | 00:17 |
Manage Worksheets | 05:13 |
Manage Workbook and Worksheet Views: Introduction | 00:46 |
Manage Workbook and Worksheet Views | 04:35 |
Manage Workbook and Properties: Introduction | 00:27 |
Manage Workbook and Properties | 03:15 |
Course Follow Up | 01:29 |
Quiz zum Kurs „Managing Workbooks in Excel 2016 (EN)“ |
Quiz zum Kurs „Excel 2016 - Beginner (EN)“ |