Excel | Word | PowerPoint | Outlook | Milton Keynes | Rugby | Northampton

Excel level 2 – Intermediate

COURSE OBJECTIVES:

  • Use Logic Functions
  • Use Lookup Functions
  • Sort and Filter data
  • Understand and use Nested Functions
  • Chart Formatting

1: Who is the Course for?

This course is designed for users who wish to increase their skills and knowledge of spreadsheets and Microsoft Excel. This level will help the delegate to produce more productive spreadsheets using formulas and function techniques.

2: The Course

The course is tutor led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment the tutor will give one to one support as required.

3: Certificates

Each delegate will receive a manual and a certificate of attendance

4: Course Content

 The Ribbon Bar
Basic Maths
Import CSV or Txt
Custom Fill
Absolute & Relative Referencing
IF function
Nested IF Function
IFERROR
Logic
TRUE – FALSE
AND OR NOT
Naming Cells & Ranges
VLookup
HLookup
Sorting Data
Filter Data
Basic Charts
Embedded Chart
Chart Formatting

 

Download Content>>>

Available In-House Courses

Microsoft Excel Microsoft Word Microsoft PowerPoint Microsoft Outlook
Excel Introduction Word Introduction PowerPoint in a Day (All Levels) Microsoft Outlook in a Day
Excel Intermediate Word Intermediate
Excel Advanced

Achieve for Success – Learning for Success – Progress for Success – Training for Success – Planning for Success – Develop for Success

Milton Keynes Chamber Member

InIT Learning Computer Courses Milton Keynes

Blog Post Tags

0330 32 100 58


 

Simple Pricing Structureslidecbc63a156cc04de8813a463a020004cc1Courses @ Yours
£640.00 per course of 3-8
£428.00 per course of 2
£258.00 One to One
(Plus Travel @ 45p/mile)

Scheduled Courses
@ Ours
£129.00 per delegate

1 to 1 Courses
@ Ours
£258.00 per delegate


InIT Learning
Harben House Business Centre
Tickford Street
Newport Pagnell
MK16 9EY

01908 92 50 58

0330 32 100 58

Sales Training Courses

Sales Training Courses