PACKT MICROSOFT EXCEL ADVANCED 2019-JGTiSO
Submitted by milohaze on Sun, 08/18/2019 - 18:25
Category:
Genre:
Learn and master Excel 2019 by learning advanced functions and formulas.
- 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
- 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