Excel 2019 Advanced

$25.00

Get beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video training course, you’ll gain an in-depth understanding of the most business-relevant advanced features of Microsoft Excel. In this course, we’ll dive into high-level consolidation, analysis, and reporting of financial information.

Sold By: Simonsezit

Know More

Course Features

Categories: ,

Get beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video training course, you’ll gain an in-depth understanding of the most business-relevant advanced features of Microsoft Excel. In this course, we’ll dive into high-level consolidation, analysis, and reporting of financial information.
What You’ll Learn

What’s new/different in Excel 2019
Advanced charting and graphing in Excel
How to use detailed formatting tools
Lookup and advanced lookup functions
Financial functions including calculating interest and depreciation
Statistical functions
Connecting to other workbooks and datasets outside of Excel, e.g. MS Access and the web.
How to create impressive visualizations using sparklines and data bars
Mastery of PivotTables and Pivot Charts
Scenario Manager, Goal Seek and Solver
Advanced charts such as Surface, Radar, Bubble and Stock Charts

simonsezit logo

Simonsezit

You Could Be One Skill Away From Your Next, Big Career Move. Simon Ses IT Work smarter, not harder. Software exists to make life easier, let Simon Sez IT show you how.

View more products from this vendor