Sale!

Microsoft Excel 2019: Beginner to Advanced Bundle

£179.00 £34.95

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.

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

Course Format:

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.

What’s Included?

Wiki_tick  Unlimited  12 months access
Wiki_tick  Access anywhere, any time
Wiki_tick  Fast effective training, written and designed by industry experts
Wiki_tick  Unlimited support
Wiki_tick  Save money, time and travel costs
Wiki_tick  Learn at your own pace and leisure
Wiki_tick  Easier to retain knowledge and revise topics than traditional methods

£179.00 £34.95Add to cart

Courses Included

Microsoft Excel 2019: Beginners
Microsoft Excel 2019: Advanced