Ultimate Microsoft Excel 2019, Beginner - Advanced 7-Course Bundle
Master Microsoft Excel with this 7-course bundle taking you from Excel novice to VBA superstar
Stream Skill
Summary
- Certificate of completion - Free
Overview
Learn Microsoft Excel 2019/365 From the Basics to VBA with this Huge 7-Course Bundle
- Includes courses: Microsoft Excel - Beginners, Microsoft Excel 2019 Advanced, VBA for Beginners & Intermediate VBA
- Also includes 2016 editions as a bonus: The Excel 2016 Beginner Course, Learn Excel 2016 Intermediate Level - Beyond the Basics & The Excel 2016 Advanced Course
- Includes over 55 hours of high-quality, video training by experienced Excel experts
- Practice as you learn using downloadable exercise files
- Certificates of Completion with each course.
- Covers Microsoft Excel 2016, 2019 and 365 editions
Course media
Description
What You'll Learn:
Microsoft Excel 2019 - Beginners Course:
- 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 Course:
- 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
2016 courses follow a similar structure to the above
VBA Editions
VBA for Beginners
- Introduction to VBA as a language (syntax and keywords)
- How to automate repetitive tasks
- Macros, sub routines and logical constructs
- Introduction to VBA functions including returning values from functions
- Writing an array formula
- Key Objects and error handling in VBA
- PivotTable and Chart Objects
Intermediate VBA
- Deeper dive into the VBA Language
- Core VBA module interactions
- Advanced parameter definitions
- Excel events including pre-defined and event parameters
- Custom Objects including creating and defining a Class
- Creating and designing a Userform
- Modifying the Excel interface and UI
- External references and Office Interlop
- The ADODB and Scripting Libraries
Course Format
This is a video-led course that you can follow along with in Excel 2016, 2019, 365 (downloadable exercise files also included)
This course is suitable for Windows users.
Course Certificate Included
The courses in this bundle include an optional online test that will generate a course certificate upon completion.
Why Trust Us?
Stream Skill is part of the Simon Sez IT family. Simon Sez IT has been in business 10+ years and taught over 400,000 students in that time. We’ve created over 90 software training courses, 5,000+ video tutorials, and we’ve helped thousands of people across around the world learn how to use MS Office Apps.
We’ve now created hundreds of hours of Microsoft Office courses and continue to help people understand how to get the most from MS Office.
Who is this course for?
Beginner, Intermediate or Advanced users of Microsoft Excel looking to improve their spreadsheeting skills.
Requirements
Microsoft Excel 2016, 2019, 365 or later
Career path
Completing this training course will show any employer that you are job-ready and have the necessary Microsoft Excel skills to be successful in your role.
Questions and answers
Is this course CPD accredited?
Answer:Hi Ailish, It's not CPD accredited. Though, please keep in mind that the course has been developed to a standard that matches/is higher than that required for CPD accreditation. Also, most professional bodies do not require CPD accreditation for a course to be counted as continued professional development. I hope that helps!
This was helpful.Hi please will this teach me how to do a stock inventory?
Answer:Hi, It will teach you the Excel skills you need to enter, process, and analyse data. Whether it prepares you for a stock inventory really depends on your specific stock inventory. If you are simply required to enter data into Excel and perform some basic functions then yes, this bundle covers that and a lot more.
This was helpful.
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.