Microsoft Excel 2016 Level 2.1: Working with Functions
$5.95
Understanding the language of Excel enables users to increase the complexity of their data analysis. This course teaches how to use Microsoft Excel 2016 functions at a more advanced level. As a foundation for using Excel functions, viewers are shown how to name and edit ranges, which allows users to navigate the workbook much faster. They learn how to use named ranges to create formulas. Using named ranges instead of cell ranges in formulas makes it easier to identify the data contained within the formula. Watch this training course to learn how to do more with functions in Microsoft Excel 2016.
Description
Audience:
Everyone interested in learning more about Microsoft Excel 2016 functions
Workplaces:
Not Specified
Topics:
Work with Functions|Work with Ranges|Name and Edit Ranges|Use Defined Names in a Formula|Locate and Use Specialized Functions|Work with Logical Functions|IF Function|AND, OR and NOT Function|Combine Functions|Functions Similar to the IF Function|Work with Date and Time Functions|TODAY, NOW and DATE Functions|NETWORKDAY, WEEKDAY, WORKDAY and ISOWeeknum Functions|Work with Text Functions|LEFT, RIGHT and MID Functions|FIND Function|Text to Columns Feature|CONCATENATE Function|UPPER, LOWER and PROPER Functions
Languages:
en
Video Format:
HD
Quiz Questions:
27
Number of Lessons:
19
Training Time:
65-92 minutes
Closed Captioning:
Yes
Devices Supported:
Windows, Apple, Android, Chrome
Required Plugins:
None
Interactive Producer:
Mastery Training Content Network
Original Content Producer:
Sonic Performance Support GmbH
