Making the Microsoft Excel 2016 environment look exactly the way you want it to is easy. In this course, you will learn how to configure how you want a workbook and the work area itself to appear. You will also learn how to add and customize templates and styles to really make Excel 2016 work for you.
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
1 Hours, 2 minutes
None
Intermediate
Customizing Views
Applying Custom Styles and Templates
Practice: Visual Elements and Views
A picture may paint a thousand words but Microsoft Excel 2016 makes adding both words and pictures to your workbooks very straightforward. In this course, you will learn how to insert and style text boxes, shapes, and SmartArt. You will also learn about applying and customizing themes and watermarks.
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
55 minutes
None
Intermediate
Shapes, Text Boxes, and SmartArt
Practice: Customizing a Worksheet
Watermarks and Themes
Splitting Text
Practice: Visual Effects
Microsoft Excel 2016 gives you a number of options for sorting and organizing data. In this course, you will learn about basic alphabetical and numerical sorts through color sorting and custom configured sorts. The course also covers grouping, filtering, searching, and ensuring valid data is entered.
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016.
1 Hours, 5 minutes
None
Intermediate
Sorting Data
Grouping Data
Filtering Data
Data Validation
Searching Data
Practice: Organizing Data
Using macros in Excel 2016 lets you save time when performing repetitive tasks. This course covers the options available when you are running macros, and also how to create your own custom macros. You will also learn about advanced functions that allow you to perform calculations using date and time, how to look up data, and how to perform advanced conditional queries.
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
1 Hours, 11 minutes
None
Intermediate
Macros
Practice: Working with Macros
Date and Time Functions
Transposing and Looking Up Data
Functions in Formulas
Practice: Advanced Functions
In Microsoft Excel 2016, PivotTables and PivotCharts let you dynamically reorganize and display your data. They can summarize huge amounts of data by category without the need to input complex formulas or spend long hours manually reorganizing your spreadsheet. You can choose and change what you want to summarize. In this course, you will also learn how to use advanced chart features like trendlines and dual axis charts.
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
52 minutes
None
Intermediate
PivotTables
PivotCharts
Advanced Charts
Practice: PivotTables and PivotCharts
Microsoft Excel 2016 provides a number of tools that allow you to share your work with others, and collaborate on Excel projects. With your Microsoft account, you can access services that facilitate online collaboration, and link to data in other workbooks and even databases. In this course, you will also learn about reviewing Excel documents and how to convey your thoughts on a document to others.
End users at all levels, including those who have little or no familiarity with Microsoft Excel and more experienced Excel users who want to learn about the new interface and features in Microsoft Excel 2016
1 Hours, 2 minutes
None
Intermediate
Sharing Your Work
Working With Others
Reviewing Workbooks
Practice: Collaborating and Reviewing