Become a master of Microsoft Excel 2019 with this essential bundle. Through 16 hours of video tuition combined from 2 in-depth courses, you will master the exceptionally popular program and gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.
What You’ll Learn
· What’s new in Excel 2019
· Creating workbooks
· Entering text, numbers and working with dates
· Navigating workbooks
· Page setup and print options
· Working with rows, columns and cells
· Cut, Copy and Paste
· Introduction to functions and formulas
· Formatting in Excel, including formatting cells and numbers
· Creating charts and graphs
· Sorting and Filtering
· Introduction to PivotTables
· Logical and lookup formulas – the basics
· 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
This is a video-led course.
This course includes practice exercises so you can practice as you learn.
This course is suitable for Windows users.