Complete Microsoft Excel Course

Admin, Finance

Start date

25/01/2021

End date

25/04/2021

Overview

Microsoft Excel – Full Course - Beginners, Intermediate & Advanced - Complete Excel Course

This Complete Microsoft excel course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software from beginner to an advanced level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel course is perfect.

What you will learn

Beginners - The MS Excel beginner’s course will give you a full overview of all of the most common features of Excel and how to use them. Here are some of the highlights of the beginner’s course:

  • 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
  • Exercises included, so you can practice what you learnt.

Intermediate and Advanced - The MS Excel Intermediate and Advanced Courses will take what you learnt in the beginners course and expand upon it. Additionally, these courses will teach you more advanced concepts than those that were presented in the beginner’s course. Here are some of the highlights of the intermediate and advanced courses:

  • The next step after completing Microsoft Excel 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
  • Exercises included, so you can practice what you learnt.

What courses are included?

We have combined our Microsoft Excel Beginners, Intermediate and Advanced Courses to make the most in-depth Complete Excel Course on the market.

  • Microsoft Excel 2016 - Beginners Course 
  • Microsoft Excel 2016 - Intermediate Course 
  • Microsoft Excel 2016 - Advanced Course 
  • Microsoft Excel 2019 - Beginners Course 
  • Microsoft Excel 2019 - Advanced Course 

These courses are based on the Microsoft 2016 and 2019 excel software and are taught by a Microsoft Office Specialist (MOS) instructor . In order to work along with the instructor, it is recommended that learners should have their own copy of Microsoft Excel 2016 or 2019. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2016 and 2019.

Assessment

There are no formal assessment for any of the courses within this training bundle. Project files are included in each course to help you consolidate your learning. 

Course Format

  • This is a video-led course. 
  • This course includes practice exercises so that you can practice what you've learnt on the course.
  • This course is suitable for Windows users.

Entry Requirements

This course has no entry requirements and has been designed to provide you with the essential skills you will need to be proficient in Excel, in a work or home environment, in as short a time as possible.

Certificate

There are no formal assessment for any of the courses within this training bundle.

 At the end of each course, please get in contact with Student Support to request a copy of your certificate of completion.

Course Duration

The Complete Microsoft Excel course requires 39 hours to complete the course in full. This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session.

Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period.

Course Compatibility

Our Microsoft Excel course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices.

Bulk discounts

Bulk discounts are available on purchases of 10 or more courses.