On Course for Success – Excel Spreadsheet Training

Level 3

Level 3 – Advanced

1: 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: COURSE OBJECTIVES

  • Using built-in Features
  • Subtotals and Grouping
  • Intro to Macros & VBA
  • Data Validation
  • What If Analyses
  • Working with Scenarios
  • PivotTables

4: Certificates

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

5: Course Content

  • Excel Forms
  • Scenario Manager
  • Goal Seek
  • Installing Solver
  • Solver
  • Subtotals
  • Grouping & Outlining
  • Pivot Tables
  • Pivot Charts
  • Slicers
  • Tables
  • Cleansing Data
  • 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
  • VBA Code

Check Availability and Book>>>

One Day Scheduled Training 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 Courses
Milton Keynes

£134.00 per person

Level 1, 2 & 3 £134.00
Level 4 Power Pivot £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>>>