Learn the skills every Microsoft Excel user needs to know - no matter how new (or how experienced) you are...
Whether you want to learn Excel 2019 or 2016, or upgrade from one version to the next, our expert instructors will use a hands-on, engaging approach to teach you all of Excel's powerful features.
Watch a single title or watch them all, as many times as you like for an entire year - all at one low price.
Example Video (From Excel 2016)
Many students ask us why we create our larger course bundles, when some people may not have time to complete all the courses inside the 12 month subscription window...
Well, essentially they're created to enable you to dip in and out of multiple related programs and obtain cross-referenced knowledge
; the intention is not for you to study it all or sit all the exams
! With any kind of technical learning, building your background knowledge on closely related areas makes a lot of sense. Therefore, having access to a wide range of connected programs enables you to research related topics to the actual program you're studying for (often just watching the video/tutorial), enhancing your overall understanding. This is why we create the larger bundles; to build the breadth of your knowledge
. Also, many IT professionals use them as reference material after certification
, as we usually provide discounts on subsequent re-subscription
- to enable you to have the material as a constant professional reference.
Microsoft Excel 2019 - Beginners
With the Microsoft Excel 2019 - Beginners’ course, you will gain a solid grounding in the basics of Excel and progress towards becoming more confident with spreadsheets. Length: 7 hours | Project Files included!
This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.
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
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
Excel 2016 Beginners
This course assumes you’ve never worked with Microsoft Excel in your life, or you are upgrading from a previous version. Your professional trainer will start you from the very beginning from installing the program to creating your first Workbook and entering data. Before you know it, you’re using Excel 2016 like a pro with advanced functions. You will have the expertise you need to impress the boss at work. You can also use this essential application to accomplish all kinds of tasks for your personal life or business.
Contents and Overview
This course starts with where to find Microsoft Excel and installing the program. Then you learn step-by-step, simple 1-2-3 methods for getting up and running with Excel 2016. Watch just the first few videos to have a basic knowledge of Excel. Then continue through the detailed 16 chapters of video lessons and 5 exercise files to gradually become a proficient user.
It’s important to note that we don’t assume you know anything about Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use Help to get additional answers when you need them.
Then we show you how to personalize Excel for your own use with exciting Excel Options. We discuss all the Ribbons and Toolbars, entering and editing data, backup and recovery, fill and series, and printing your projects. We also work with Worksheets and formulas and functions.
If most Excel courses seem to be designed for people who already have experience with the program, this course will be a breath of fresh air. The videos keep things simple and carefully step you through each process!
Microsoft Excel 2016 Intermediate
Picks up where the beginner course left off
More advanced mastery of Excel
Perfect for advancing at work
Easy to follow instruction shows you how
Step by step tutorials are easy to understand
More advanced use of working with data
Mastery of charts and graphs
Covers Dynamic Formula and Named Ranges
Hours of fun for anyone interested in Excel
Helps you become an Excel power user
Practice what you learned with included exercise files
Microsoft Excel 2016 Advanced
Practice what you learned with included exercise files
Detailed easy instruction to master Microsoft Excel 2016
Everything explained step-by-step for quick comprehension
The next step after completing Microsoft Excel 2016 for Beginners
Learn how to import and export data to and from Excel
Learn how to create various charts and graphs
Effectively create and use functions and formulas
Import and export data
Create and effectively use Pivot Tables
How to use Excel for data analysis
Discover practical methods for financial & statistical functions
- 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.
For Detailed Course Outlines Visit:
* BONUS - Titles Include All Project Files to Work Along with the Instructor
Learn anytime, anywhere, at home or on the go.
Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.
Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.