Beschreibung

Our Complete Microsoft Excel 2019 Course Bundle is here to help you become a master of Excel!

In this course bundle is 16 hours of specially crafted video tuition by industry-leading experts, alongside 2 in-depth courses to help you gain an in-depth understanding of advanced Excel features and master the popular worldwide used program.

You will get to delve into analysis, high-level consolidation, and reporting of financial information as well as much more!

This is a fully video led course, and it includes practise exercises so you can practise and get hands-on experience as you learn!

This course is suitable for Windows users.

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?

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

£299.00In den Warenkorb