START
 

Excel - Level 2

SquareOne Training
Course summary
Length: 2 days
Price: 320 GBP excl. VAT
Language: English
Course type: Open / Scheduled
Next available date: 15/05/2017 09:30 - Liverpool
Course Dates
Liverpool
15/05/2017 09:30  (English)
320 GBP
Contact us for future dates  (English)

Course Description

Excel - Level 2 (2003/2007/2010 & 2013)Excel - Level 2 (2003/2007/2010/2013 & 2016)

This Level 2 Excel training course is offered as an open/scheduled 2-day workshop by SquareOne Training. The course is designed to show delegates how to improve their understanding of Excel and produce powerful well presented spreadsheet models. This training course is also suitable for existing users of Excel who have recently upgraded. The course follows on from the Level 1 course and is full of shortcuts and tips.

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. This course can also be delivered in-house at your location and tailored to your liking.

Suitability - Who should attend?

This Level 2 Excel training course is suitable for existing Microsoft Excel users seeking to improve their understanding of so they can produce powerful, well presented spreadsheets. The course follows on from our Level 1 course and is full of shortcuts and tips.

Training Course Content

The content for this Level 2 Excel training course is structured as follows:

Overview of Microsoft Excel Level 1 Course

  • Recap of Shortcuts and Tips from the Level 1 course
  • Recap of Absolute Cell Referencing
     

Range Names

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

3D Worksheets

  • Setting up worksheets
  • Copying worksheets
  • Grouping worksheets
  • Calculating multiple sheets
     

Linking Data from Other Spreadsheets

  • Copying worksheets quickly and tips on copying to new spreadsheet
     

Advanced Functions

  • IF Statements
  • Nested IFs
  • VLookup
     

Conditional Formatting

  • Apply shading and formats to cells by setting up conditions
  • Creating Conditions using Formulae
  • Format Painter for Conditions
     

Data Validation

  • Setting up the restriction on how cells are input as dates, numbers, or time
  • Setting up cells entries as a list
  • Limit the characters of cell entries
  • Create Error Messages
     

Working with Large Data

  • Split
  • Freeze Panes
  • AutoFilter
  • Sort
  • Custom Sort
     

Text Functions

  • Trim, Proper, Left, Right
  • Concatenate
  • Text to Columns
  • Removing Duplicates
     

Tables (Lists)

  • Creating Tables
  • Formatting Tables
     

Pivot Tables

  • Overview of Pivot Tables
  • Create Pivot Tables
  • Format Data
  • Group Data in Pivot Tables
  • Show Pages
  • Refresh Data
     

Slicers (Excel 2010 Feature)

Sparklines (Excel 2010 Feature)

Advanced Charting

  • Producing Charts using a Function Key
  • Changing the Chart Type
  • Formatting Charts
  • Adding Titles
  • Customising the Chart
  • Drawing on Charts

Expenses

This Level 2 Excel 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 - In-House IT & Computer Training

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


Read more and show all courses with Provider: SquareOne Training

Request information - obligation free

Fill out your details to find out more about Excel - Level 2.

  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)
Course participant   |   12/06/2015
Excellent day. Good pace of delivery, content and useful for my current role. Thank you
          (5)
Course participant   |   12/06/2015
Thank you Alan, it was very interesting Enjoyable Presentation Great trainer, good facilities and nice food!
          (5)
Course participant   |   12/06/2015
Really good course - good content and it was well tailored to our needs as a group. Lots of attention given to individually people’s needs.
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 - Level 2 course - simply fill out your details:

 
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