Attend upcoming webinar and earn continuing education credits. Pros and Cons of Excel 2016/Office 365 | | | | | | | February | | 15 | 1 pm - 2:40 pm ET | | Presenter: David Ringstrom, author and nationally recognized instructor | | Credits: CPE (Credit Details) | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | In this practical webinar, you'll learn from Excel expert David Ringstrom, CPA, how the Office 365 version of Excel 2016 differs from previous versions and perpetual licensed versions of Excel 2016. Each technique covered in the webinar will be demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in the Office 365 version of Excel 2016. Upon completion of the webinar, you will be able to: - Identify the updated features and worksheet functions available in the Office 365 version of Excel 2016
- Recall alternatives that work in all versions of Excel for the new CONCAT, TEXTJOIN, SWITCH, IFS, MAXIFS, and MINIFS worksheet functions.
- Apply pivot table specific options in the Office 365 version of Excel 2016 to minimize repetitive work.
- Apply keyboard shortcuts and tips that will help you work more efficiently in Excel and avoid any frustrations you might encounter
- Discover new worksheet functions available in Excel 2016
- Use the MAXIFS function available in the Office 365 version of Excel 2016
- Use the MINIFS function available in the Office 365 version of Excel 2016, as well as how to use the MIN function as an array formula that will achieve the same effect in any version of Excel
- Discover the Recommended PivotTables feature
- Set up the mapping of geographic data with just a couple of mouse clicks in the Office 365 version of Excel 2016
- Determine how to embed 3D models into Office 365 spreadsheets, while seeing what's viewable in other versions of Excel
| | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. | | | | | | | | | ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,300 on-demand courses | | | | | |
No comments:
Post a Comment