Excel Courses Milton Keynes

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

Ready for Action?

Are you ready to check dates and book? Then take action now and click below.
Check Dates

Harben House Hotel
Tickford Street
Newport Pagnell
MK16 9EY

Tel: 01908 92 50 58
        0330 32 100 58
(Calls may be recorded for quality purposes) 

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close