On Course for Success – Excel Spreadsheet Training

Level 3

Level 3 – Advanced

Who is the Course for?

This course is designed for users who have a good knowledge and understanding of spreadsheets and wish to use more advanced features of the programme.

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: Certificates

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

4: Course Content

  • Naming Cells & Ranges
  • V & H Lookup
  • Index & Match
  • Logic – AND OR NOT
  • Excel Forms
  • Scenario Manager
  • Goal Seek
  • Installing Solver
  • Solver
  • Data Validation
  • Subtotals
  • Grouping & Outlining
  • Toolbars
  • Pivot Tables
  • Pivot Charts
  • Excel Macros
  • Macro Security
  • Saving a Macro Workbook
  • Recording & Running a Macro
  • Relative Cell References (Macros)
  • Viewing & Editing a Macro
  • Assigning Macros
  • Global Macros
  • Object to run Macros

 

Check Dates and Booking Form>>>

Other Courses Available

PowerPoint Courses Milton Keynes Microsoft Word Courses Milton Keynes Outlook Courses Milton Keynes

0330 32 100 58

Software Training

One Day Courses

Excel Training
Milton Keynes

£129.00 per person

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

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>>>

Other Scheduled Course Dates

Outlook Course

Contact us for Dates

Details>>

Word Level 1

23rd October 2017

Details>>

Word Level 2

31st October 2017

Details>>

PowerPoint

16th November 2017

Details>>