Home
[PACKTPUB] MICROSOFT EXCEL ADVANCED 2019 [VIDEO]

[PACKTPUB] MICROSOFT EXCEL ADVANCED 2019 [VIDEO]

 FCN0
, , , , , , , , , , , ,
[PACKTPUB] MICROSOFT EXCEL ADVANCED 2019 [VIDEO]
Simon Sez IT
July 24, 2019

8 hours 5 minutes

Learn and master Excel 2019 by learning advanced functions and formulas

More Information

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
About 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.Upon completion of this course, you’ll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.

You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you’ll have advanced understanding of Excel that will positively impact your professional capability.

All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/Microsoft-Excel-Advanced-2019
Features
  • Learn and understand advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information
  • Learn and master advanced charting and graphing in Excel
Course Length 8 hours 5 minutes
ISBN 9781839219832
Date Of Publication 24 Jul 2019

 

Size: 2.26GB

https://www.packtpub.com/programming/microsoft-excel-advanced-2019-video

Please complete the required fields.




Related Posts:   Microsoft Excel – Excel, Pivot Tables & Power Pivot (Bundle)

This site comply with DMCA digital copyright. We do not store files not owned by us, or without the permission of the owner. We also do not have links that lead to sites DMCA copyright infringement.

 

If You feel that this Course is belong to you and you want to unpublish it, Please Contact us .

Related Posts