This training program will help attendees identify the differences in Excel 2016 from previous versions. Attendees will also learn which worksheet functions are available in Excel 2016 but not in other earlier versions of Excel. Understand the nuance involved between the 32-bit and 64-bit versions of Excel.
Why Should You Attend:
In this webinar, attendees will:- Determine the benefits of upgrading from an earlier version to Excel 2016.
- Learn how Excel 2016 differs from earlier versions of Excel.
- Explore new chart options in Excel 2016.
- Learn about a variety of new features available in Excel 2016.
- Avoid the frustration of disabled features in Excel 2016 caused by .XLS workbooks.
Learning Objectives:
- Use the new Tell Me feature to locate hidden commands and capabilities in Excel 2016.
- Identify the differences in Excel 2016 from previous versions in order to avoid the pitfalls and frustrations than can result from a lack of understanding.
- Learn which worksheet functions are available in Excel 2016 but not in other earlier versions of Excel.
- Understand the nuance involved between the 32-bit and 64-bit versions of Excel.
- Disable worksheet animation within Excel 2016.
- Filter lists of data by way of the Slicers feature.
Areas Covered in the Webinar:
- Illustrate financial statements by way of the new Waterfall Chart format.
- Comparing user interface changes in Excel 2013 and 2016 that have vastly simplified chart-related tasks.
- Convert .XLS workbooks to modern formats with just two keystrokes.
- Creating interactive geographic maps from Excel data with the free Bing Maps app.
- Use the Treemap and Sunburst chart formats to compare numbers based on relative shapes.
- Filter pivot table data by date ranges with the Timeline feature.
- Extrapolate trends by way of the new Forecast feature in Excel 2016.
Who Will Benefit:
- Accountants
- CPAs
- CFOs
- Financial Consultants
- Controllers
- Banking Staff
- Insurance Advisors
- IT and Telecom
- Marketing
- Sales
- Investments
- Pharmaceutical
- Medical Devices
- FDA
- Aviation
- Energy
- Retail
- Human Resource
- Logistics and Supply Chain
- Audit
Course Provider
David H Ringstrom,
