WOOCS 2.2.1
Shop0

Basket

Microsoft Excel - Beginners, Intermediate & Advanced Levels

$486

Microsoft Excel – Beginners, Intermediate & Advanced Levels

$486

We are offering you an online Microsoft Excel 2016 Course for only £400. Improve your skills, add value to your CV and learn something new, order below to get started.

Description

Microsoft Excel Online Course

Searching for an Excel course for beginners to experts? This online course has something for everybody, covering beginner, intermediate and advanced aspects in Excel.

In this Excel training online, you will discover the fundamental techniques including how to utilise mathematics, statistical, logic and text functions, arrange data by sorting and filtering, efficiently present your information in a number of chart formats and more. You will also discover intermediate and advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more.

Whether you use Excel for work or study, these modules will start you on your journey to becoming an Excel expert! Discover more about how a Harley Oxford Excel certification can boost your career.

As soon as you have enrolled, our friendly support staff and tutors are here to assist with any course related queries.

Microsoft Excel – Beginners, Intermediate & Advanced Levels

This detailed course has been designed for anyone who wants to drive their career forward. The course covers a large variety of topics spanning over a number of detailed modules.

During the Microsoft Excel course, you will learn the fundamental techniques including how to utilise mathematics, statistical, logic and text functions.

In addition to this, you can learn how to arrange data by sorting and filtering, efficiently present your data in a number of chart formats and much more.

The great thing about this course is that there are no entry requirements. You don’t need any specific education or work experience, just the desire to learn, enhance your knowledge and skills and succeed in your desired career moving forward.

Once you select the Microsoft Excel course and your payment is received, you can start learning straight away. Everyone can study flexibly at different paces, which is why this course is such a great opportunity, enabling you to work and study in your available time. On completion of the course you will need to complete a multiple choice test and on passing, you will be issued a certificate that you can download and print which is recognised by industry professionals.

What you will learn in the Microsoft Excel Course

The Microsoft Excel beginners, intermediate & advanced levels comprises of a number often detailed modules for you to learn and gain knowledge from. In total the modules should take around thirty hours to complete, bearing in mind that everyone studies at different paces and some people will have more time to study than others.

The essential modules in this course include:

  • Create your first Excel file, enter data and create a table.
  • Format cells by selecting fonts and color fills to make information more attractive.
  • Utilise the keyboard or mouse to select cells and ranges in a spreadsheet.

Benefits of the Microsoft Excel Course

The Microsoft Excel course will provide you with a host of skills and knowledge you will be able to use on a daily basis. There are a number of benefits to completing the Microsoft Excel course:

  • Learn at your own pace
  • Unlimited tests and exams
  • Get a certified qualification
  • Mobile (learn on-the-go)

Course Modules/Units

Microsoft Excel Beginners

  • Before You Start
  • What is a Spreadsheet Program?
  • Getting Started with Microsoft Excel
  • Workbook Windows and Views
  • Basic Spreadsheet Skills
  • Using the Help System
  • Workbook File Formats
  • Creating New Workbooks
  • Selecting Cells
  • Cell Referencing
  • Auto Sum and Auto Fill
  • Formatting Numbers
  • Formatting Cells
  • Cells, Rows and Columns
  • Working with Worksheets
  • Edit, Copy and Move Cells
  • Proofing Workbooks
  • Printing and Previewing Worksheets
  • Basic Options
  • E-Mailing Workbooks

Microsoft Excel Intermediate

  • Before You Start
  • Defined Names
  • Sort Data and Remove Duplicates
  • Chart Basics
  • Chart Design
  • Chart Layout
  • Chart Format
  • More About Charts
  • Date Functions
  • Logical Functions
  • Information Functions
  • Financial Functions
  • Headers and Footers
  • Adding Comments
  • Conditional Formatting

Microsoft Excel Advanced

  • Before You Start
  • Text to Columns
  • Paste Special
  • Data Validation
  • Consolidate Data
  • What-if Analysis – Data Tables
  • What-if Analysis – Scenarios
  • Text Functions
  • Lookup Functions
  • Maths and Trig Functions
  • Statistical Functions
  • Database Functions
  • Linking Data
  • Hyperlinks
  • Getting External Data
  • Pivot Tables and Pivot Charts
  • Protecting and Sharing Worksheets and Workbooks
  • Workbook Properties and Inspection
  • Encrypting and Finalising Workbooks
  • An Introduction to Macros
  • Illustrations, Text Boxes and WordArt
  • Custom Number Formats
  • Custom Lists
  • Working with Template

+ more