On Course for Success – Excel Spreadsheet Training

Level 2

Level 2 – Intermediate

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. Please make sure you can carry out at least 80% of the Level 1 content and be able to enter formulas to carry out calculations.

2: The Course

Courses delivered by InIT Learning are 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: COURSE OBJECTIVES

  • Use Logic Functions
  • Use Lookup Functions
  • Importing  Data
  • Understand and use Nested Functions
  • Using Dates and Times

4: Certificates

Each delegate will receive a manual and a certificate of attendance.

5: Course Content

  • Logic Functions
  • TRUE – FALSE
  • SumIF
  • AverageIF
  • IF
  • Nested IF
  • IFERROR
  • AND OR NOT
  • Naming Cells & Ranges
  • Managing Names
  • Using Names
  • Lookup Functions
  • Import CSV or Txt
  • Custom Fill
  • Static Dates and Times
  • Custom Date Formats
  • Custom Time Formats
  • Dynamic Dates and Times
  • Basic Date Calculations
  • Date Functions
  • Times
  • Handy Shortcuts

Check Availability and Book>>>

Other One Day Scheduled Courses Available 10:00 to 4:30

PowerPoint Courses Milton Keynes Microsoft Word Courses Milton Keynes Outlook Courses Milton Keynes Excel Power Pivot Courses Milton Keynes

Click the required image/course above to find out more


0330 32 100 58
01908 92 50 58

One Day Courses

Excel Training
Milton Keynes

£134.00 per person

Level 1, 2 & 3 £134.00
Level 4 Masterclasses £154

Includes:

Manual

Certificate of Attendance

InIT Learning for In-house computer courses
InIT Learning

Milton Keynes Chamber Member

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

01908 925058

0330 32 100 58

Map

Only 10 minutes from Central Milton Keynes or 4 minutes from M1 Junction 14

  • Easy to find
  • Plenty of Free Parking on-site for delegates

More>>>