Microsoft Excel 2016 Advanced
This course teaches you how to master the advanced functions of Excel 2016. You'll learn how to apply a range of Excel formulas and functions to advanced financial data to produce sophisticated financial analyses and visualisations. The course is designed for professionals in data science, finance, and accounting, who already have comprehensive Excel knowledge but are ready to take their skills to the next level.
Course Overview
Get beyond the basics and supercharge your Excel 2016 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:
- How to create amazing looking charts and graphs
- Complex Time and Date functions
- VLOOKUP, HLOOKUP
- Statistical functions
- Using Excel for forecasting
- Connecting to external databases including Access and live web sources
- Advanced Tables, including Styles and References
- Advanced PivotTable uses including using filters, slicers and Pivot Charts
- Goal Seek, Scenario Manager and Solver
- Advanced charts such as Stock charts, Bubble Charts, Radar Charts and Sparklines
- Using the Excel web app
