Course description
Microsoft Excel 2019 Beginner to Advanced Training Course
This Two Part Mastering Excel 2019 course includes basic, intermediate, and advanced level lessons....Learn about functions, charts, macros, Sparklines, and so much more. By the time you've completed this 16+ hour training, you'll be a Microsoft Excel master.
Upcoming start dates
Outcome / Qualification etc.
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
Microsoft Excel 2019 - Advanced (9 Hours)
In this Microsoft Excel 2019 - Advanced course, you will learn:
- 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 delivery details
- 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.
Why choose Learning247
Gain a New Qualification - Get a verifiable qualification with Learning247 and improve your career prospects. Most of our courses CPD Accredited.
Wide Range of Courses - With over 800+ courses to choose from you're sure to find a course that interests you.
Study Anywhere & Any time - All of our online courses can be studied from your PC, MacBook , tablet or smart phone device.
Request info
Learning247
As one of the market-leaders in distance-learning and self-study multimedia-based training, Learning247 provides the most cost-effective route to enable you to update and improve upon your skills; and all without the massive prices that are regularly seen throughout the training...