Microsoft Excel 2013 Advanced
Mastering the advanced capabilities of Excel 2013 will enable you to reach new heights in your career. This advanced course introduced sophisticated Excel concepts that delve into high-level consolidation, analysis and reporting of financial information. This course is designed for data scientists and professionals in the accounting and finance industry and will supercharge your Excel skills.
Course Overview
Get beyond the basics and supercharge your Excel 2013 capabilities. With this 9-hour, expert-led video training course, you’ll gain an in-depth understanding of the most business useful advanced features of Microsoft Excel that delve into high-level consolidation, analysis and reporting of financial information.
Target Audience
Data Analysts, Data Scientists, Statisticians, people in Financial Services, Accountancy, Audit, Tax
Learning Objectives
In this course you will:
- Learn to apply advanced functions and filter data
- Create advanced charts and graphs that visualize your data
- Use detailed formatting tools
- Understand trends, differences and relationships in charts
- Use charting and graphing for financial information
- Use sparklines for data visualization and data bars
- Master PivotTables using advanced techniques
