HOME
 

Microsoft Excel Master Online Training Bundle

Learning247
Course summary
49 GBP excl. VAT
English
Online courses
Next available date: Enquire for more information - Online courses
Professional Training

Course description

Course Outline

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.

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. 

Course Description

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 BeginnersThis 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 OverviewThis 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

Course Highlights:Picks up where the beginner course left offMore advanced mastery of ExcelPerfect for advancing at workEasy to follow instruction shows you howStep by step tutorials are easy to understandMore advanced use of working with dataMastery of charts and graphsCovers Dynamic Formula and Named RangesHours of fun for anyone interested in ExcelHelps you become an Excel power userPractice what you learned with included exercise files

 

Microsoft Excel 2016 Advanced

Course Highlights:Practice what you learned with included exercise filesDetailed easy instruction to master Microsoft Excel 2016Everything explained step-by-step for quick comprehensionThe next step after completing Microsoft Excel 2016 for BeginnersLearn how to import and export data to and from ExcelLearn how to create various charts and graphsEffectively create and use functions and formulasImport and export dataCreate and effectively use Pivot TablesHow to use Excel for data analysisDiscover practical methods for financial & statistical functions

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.

 

For Detailed Course Outlines Visit:

  • Microsoft Excel 2016 Beginner to Advanced
  • Microsoft Excel 2019 Beginner to Advanced

* 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.

About provider

Learning247

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...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Excel Master Online Training Bundle.

  Contact the provider

  Get more information

  Register your interest

Contact info

Learning247

61 Caroline Street
B3 1UF Birmingham

 Show phone number

Request information

Find out more about this Microsoft Excel Master Online Training Bundle course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here