Excel 2019 – Advanced

Excel 2019 – Advanced

  • Von
  • Simon Sez IT

Flatrate

149

inkl. 5 % MwSt.

  • Einzellizenz
  • 12.42 pro Monat
  • 20% sparen
  • Verlängert sich automatisch

Teilen Sie dieses Produkt

Get beyond the basics and supercharge your current skill level in Excel. With this 9-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve 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 awesome 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