What's New in Excel 2019?
What you'll 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
Requirements
- Access to Microsoft Excel 2019 is recommended.
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 regular users and new users alike.
Updated features we cover for Excel 2019 include:
· New Funnel Charts, SVG Images, Icons, and 3D Images
· Improved Sharing Features
· New Functions TEXTJOIN, CONCAT, IFS, MAXIFS, MINIFS, and SWITCH
· New Ink & Drawing Tools
· Updated Backstage View features
· Improvements to De-Selecting Ranges and Cut/Copy
This course includes eight easy-to-understand modules that show how to take advantage of the new tools that are designed to make Excel 2019 more accessible to new users, and increase the usefulness of savvy users alike.
Who this course is for:
- Office 365 and Microsoft Excel users who want to learn about Excel 2019's new features.
Course content
- Preview13:02
- 07:43Sharing
- 06:44TextJoin and Concat
- 07:17Max Ifs and Min Ifs
- 02:53Switch
- 05:18Ink and Drawing
- 05:37New in Backstage View
- 04:57Extra Features
Instructor
Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.
Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.
Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa.