Microsoft Excel 2019 Advanced
This course is for users with existing Microsoft Excel experience who want to learn more advanced features and gain a deeper understanding of the most useful features for business, including consolidation, analysis and reporting of financial information.
What you'll learn
- Identify new features in Excel 2019 for enhanced productivity.
- Master advanced charting and graphing techniques in Excel.
- Utilize detailed formatting tools for precise data presentation.
- Apply lookup and advanced lookup functions effectively.
- Execute financial functions, calculating interest and depreciation with proficiency.
- Employ statistical functions for data analysis and forecasting.
- Connect to external workbooks, Access databases, and web datasets.
- Create compelling visualizations using sparklines and data bars.
- Achieve mastery in PivotTables and Pivot Charts for dynamic data analysis.
- Utilize Scenario Manager, Goal Seek, and Solver for strategic decision-making.
- Create advanced charts like Surface, Radar, Bubble, and Stock Charts and enhance your Excel skills for real-world applications and analytical success.
Build on the Excel skills you already have and take your expertise to new heights with this advanced-level course on Excel 2019. You will deepen your understanding of more advanced Excel features by delving into high-level consolidation, analysis and reporting of financial information.
Use the expert insight you gain from this course to tackle problem-solving differently. When you master Excel’s myriad of functions, you're equipped to successfully complete every type of task, from the most practical to the most complex. The only prerequisite for this course is an intermediate-level knowledge of Excel.
