• My account
  • Cart
English courses / USD

Microsoft Excel – Advanced - Level 4 - Accredited

Regular Price: $330

Special Price: $32

  • 12 Months
  • 2 students have purchased
  • Express
Centre
Oplex careers
Town
London
Address
26 York STreet W1U 6PZ See in Google maps
Contact
info@oplexcareers.com
https://deals.oplexcareers.com/?id=9
Map
Description
Welcome to Oplex Careers. Firstly, from everyone at Oplex Careers we would like to thank you for visiting our website today at www.oplexcareers.com. Here at Oplex Careers we provide a wide range of high quality training courses that help people all over the world to gain new skills, qualifications or simply update their knowledge.

Benefits

  • Unlimited 24/7 access for 12 months
  • Make your own study schedule and take advantage of online tutoring hours
  • Obtain a certified diploma once you finish the course.

Details

The online Microsoft Excel 2013 Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at 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 Advanced course is perfect.


The Microsoft Excel Advanced course is split into the following modules:

Introduction to Excel Advanced
Using Text to Columns
The Paste Special Function
Data Validation
Subtotals and Grouping
Consolidating Data
Scenario Analysis
Data Tables in Scenario Analysis
What-if Analysis
Mats and Trig Functions
Text Functions in Excel
Using Lookup Functions
Vlookups
HLookups
Using Statistical Functions
Databse Functions
Formaula Auditing and Error Tracing
Hyperlinks in Excel
Linking Data
Understanding Pivot Tables
Using Pivot Charts
Workbook Properties
Protecting and Sharing Worksheets
Data Encrypting and Finalising Workbooks
Understanding to Macros
Custom Number Formats in Excel
Using Custom Lists
Working with Templates
Tracking Changes in Excel
Merging and Compare Excel Workbooks
Final Assessment
Microsoft Excel Software

This course relates to Microsoft 2013 software. In order to complete the course, learners should have their own copy of Microsoft Excel 2013. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2013.

Assessment

To assess the learners ability and knowledge to effectively understand the topics contained within the Microsoft Excel Advanced course, the course features a number of end of module interactive quiz questions.

Additionally, at the end of the course learners will also take an online multiple choice assessment test. This online multiple choice test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Conditions

Thanks to this offer, valid exclusively for one person, you will obtain a Microsoft Excel – Advanced - Level 4 - Accredited Course.

How to register

By buying the course in Emagister Express, you will obtain an access coupon. We will send you the codes and keys to the coupon. Send the coupon code and the key to info@oplexcareers.com. The training provider will then give you access to the course.

This course has not been reviewed yet
Hi! According to your location, we have changed your payment currency to USD.
You can change to other currency by using the option on the header.