Currency Converter


Rates are based on those published by the European Central Bank. Please note that these rates are indicative and may differ from those used to calculate prices on our site. If purchasing in GBP, EUR or USD on our site the rates listed on the product pages will be what is used at checkout.

MS Excel 2016: Intermediate

Price is per online user of this course. EU applicable VAT is added.

In the course MS Excel 2016: Intermediate, the presented interactive lessons focus mainly on performing various calculations. You will broaden your basic knowledge by the application of logical and text functions. You will get acquainted with the principles of referencing to the values in other cells. You will learn to fill cells with series of data. You will familiarise yourself with the advanced options of sorting and filtering data or searching for specific values in extensive tables. You will also examine how to split longer text entries in tables into individual data placed into several columns.

See below for further information.

Sold By: Gopas IT Training

Description

Course Content

  • Customisation of the Quick Access Toolbar
  • Customising the Ribbon
  • Manipulation with sheets of multiple workbooks
  • Advanced paste options
  • Copying multiple items
  • Pasting external data into Excel
  • Advanced number formats
  • Custom number format
  • Worksheet protection
  • Advanced work with Excel tables
  • Using references in formulas
  • Comparing and connecting values using operators
  • Cell and range references
  • Conditional formatting rules
  • Conditional formatting based on a formula
  • Function library
  • Text functions
  • Advanced text functions
  • Math functions
  • Statistical functions
  • Date and time functions
  • Logical functions and conditional calculations
  • Nested functions
  • Errors in cells and their checking
  • Naming cell ranges
  • Data validation
  • Advanced fill series
  • Advanced sorting
  • Data filtering
  • Using slicers to filter data
  • Finding and replacing specific values
  • Removing duplicate data
  • Splitting text into columns
  • Flash Fill
  • Outline

Discounts

For multiple purchase discounts or to find out if discounts are available on mixed course purchases please phone a customer advisor on 0844 85 9218.

Payment Options

The most straight forward method of payment is to select the number of users you require and add the product to your shopping cart by selecting Add to Cart. You will then be able to make payment using most credit and debit cards or a Paypal account. If you would like to pay by BACs transfer or by invoice please contact a customer advisor on 0844 854 9218 or email [email protected].

Level

Course Duration in Minutes

1050

Course Publisher

Gopas IT Training

Access Duration

Available for immediate enrolment

Yes

FAQs

There are no FAQs for this course.

£15.00

View price in your currency

Keep up to date with what’s happening in the world of education, training and skills. Receive details of offers and newly launched courses, and tips on effective online and blended learning practise by signing up to our monthly newsletter. We guarantee not to sell or pass on your details and you can unsubscribe at any time.