What's New in Excel 2019?
New Functions, New Ink Tools, and New Features Make Excel 2019 Even More Useful
What you will learn
Describe the new IFS, TEXTJOIN, and SWITCH functions
Demonstrate the new Ink Tools including Ink to Shape and Ink Replay
Discuss the changes to Cut/Copy and Selection features
Description
Updates in Excel 2019 optimize the world’s most popular spreadsheet for modern business – making it easier to draw, add graphics, manipulate text, and more!
The updated Microsoft Excel 2019 includes new tools and capabilities that can help experienced users and new users alike. Excel trainer Barbara Evers walks you through many of the new features that have been added to this version. From new text functions to new IFS functions, these functions will help you streamline your data analysis. In addition, you’ll learn how to use the charts and graphics features available, as well as the ink and drawing tools. And new sharing features will make collaboration even easier.
Topics covered include:
Using new Funnel Charts, SVG Images, Icons, and 3D Images
Learning improved sharing features
Working with new functions such as TEXTJOIN, CONCAT, IFS, MAXIFS, MINIFS, and SWITCH
Using ink and drawing tools
Working with new features in the Backstage view
De-selecting ranges
Learning cut and copy techniques
This course includes eight easy-to-understand lessons that show how to take advantage of new tools that are designed to make Excel 2019 more accessible to new users and more useful to seasoned users.
Over fifty minutes of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!
Objectives. You will be able to:
Describe the new IFS, TEXTJOIN, and SWITCH functions
Demonstrate the new Ink Tools including Ink to Shape and Ink Replay
Discuss the changes to Cut/Copy and selection features