Advanced Excel Training

ActionPoint is delighted to bring Advanced Excel training to our Virtual Academy.

Microsoft Excel allows the user to create digital spreadsheets which enables information to be stored, organised and manipulated with powerful data visualisation and analysis tools.

Timeframe: 1/2 day session

Suitable for: This course is targeted at those who have been using Excel for some time and who wish to achieve more with the platform.

Course Objectives

On completion of this course you will be more skilled on the technical aspects of Excel including the creation of tables, advanced formulas and working with macros.

Course Outline

Topic 1: Working With Multiple Worksheets and Workbooks

  • Creating Tables in Excel
  • Advanced List management
  • Forms and Form controls in Excel

 

Topic 2: Advanced Formulas and Functions

  • Use Lookup, Index and Match Functions
  • Database and Text Functions
  • Trace Cells
  • Watch and Evaluate Formulas

 

Topic 3: Sharing and Spreadsheet Security

  • Collaborate on a Workbook
  • Protect Spreadsheets and Workbooks

 

Topic 4: Automating Workbooks

  • Use Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Creating and editing templates

 

Topic 5: Working with Macros

  • Creating and Inserting a Macro
  • Running and Editing Macros
  • Assigning a macro to the keyboard, buttons and menu

 

Topic 6: What If Analysis

  • Scenarios, Data Tables and Goal Seek

 

To choose a time or date that suits your team or to discuss your tailored training needs, please email academy@actionpoint.ie.
  • 00

    days

  • 00

    hours

  • 00

    minutes

  • 00

    seconds

Register Your Interest Here

Advance Excel
Available Tickets: 10
The Advance Excel ticket is sold out. You can try another ticket or another date.

Cost

€275

Location

ActionPoint Virtual Academy
ActionPoint Virtual Academy

Organizer

ActionPoint Academy
Email
academy@actionpoint.ie
Website
http://actionpoint.ie
Register Your Interest
QR Code

Comments are closed.

ISO27001 Certification logo
Dell Platinum Partner Logo
vm ware partner logo
Veeam partner logo
sophos-platinum-logo
Commvault Logo

Get our Company Brochure

Please enter your details to download our Company Brochure. We will also send a copy to your inbox.