START
 

Excel - Express

SquareOne Training
Course summary
Length: 1 day
Price: 175 - 195 GBP excl. VAT
Language: English
Course type: Open / Scheduled
Next available date: 22/11/2017 09:00 - Liverpool
Course Dates
Liverpool
22/11/2017 09:00  (English)
195 GBP
Contact us for future dates  (English)

Course Description

Excel - Express (2003/2007/2010/2013 & 2016)

This Excel Express training course is offered as an open/scheduled workshop by SquareOne Training. The course is designed to show people all the clever Microsoft Excel Data Manipulation Features. We have found that these are the most popular features we show on our courses and we have therefore created this new and exciting course to help you get the most out of Excel quickly.

Our patient and dedicated trainers will help all users gain the skills needed to start working confidently on Windows PCs. This course is taught at an intermediate level.

Suitability - Who should attend?

This Excel Express (2003/2007/2010/2013 & 2016) 1 day course is suitable for existing users of Excel who want to learn more about data manipulation features.

Training Course Content

The content of this Excel Express (2003/2007/2010/2013 & 2016) course is structured as follows:

Range Names

  • Create Range Names
  • Navigate using Range Names
  • Print Range Name Areas
  • Create Formulae using Range Names
     

Advanced Functions

  • Advanced Functions such as IF, IF(AND, IF(OR, Countif, VLookup, ISERROR
  • Data Calculations
     

Text to Columns and Concatenate

Conditional Formatting

  • Apply shading and formats to cells by setting up conditions
  • Creating Conditions using Formulae
  • Sorting by Colour
     

Database Functions

  • Working with the AutoFilter feature
  • Advanced Filters
  • Data Form
  • Sub Totals
  • Data Tables
     

Pivot Tables

  • Create Pivot Tables
  • Group Data in Pivot Tables
  • Show Pages

Expenses

This Excel Express training course is offered both as an open/scheduled course and an in-house training course.

The in-house training will be delivered in the form of a closed course at your company's premises. SquareOne can come to you no matter where you are based throughout the UK. The cost of this training course is available upon request.

Provider: SquareOne Training

SquareOne Training

SquareOne Training

SquareOne Training is an internationally renowned IT Training company who create inspiring, motivational and cost effective training services which bring about tangible improvements in productivity. They specialise in providing classroom courses, Microsoft upgrade training, IT consultancy and large-scale rollout support...


Read more and show all courses with Provider: SquareOne Training

Request information - obligation free

Fill out your details to find out more about Excel - Express.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for SquareOne Training

SquareOne Training


2 Tower Road
CH41 1FN Birkenhead

 Show phone number
www.squareonetraining.com

Contact SquareOne Training

Reviews by course attendees

          (5)
Louise Parkes   |   31/05/2017
I learnt so much from this course. Would highly recommend. Especially the shortcuts.
          (5)
Course participant   |   12/06/2015
Trainer was excellent. Good atmosphere to learn in. She answered all questions and pushed learners. Excellent session, great tuition, learnt things I didn't know existed in a programme I use everyday!
Enter & win £50 voucher

 
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

 
Request information

Find out more about this Excel - Express course - simply fill out your details:

 
Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

 
Case Study
SquareOne Deliver IT Rollout Pro...

Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.

Read more
 
Find more courses here