Strategic Business IT Planning, Deployment & Management Courses


MS Excel - Advanced

REF: 15094_267882
DATE: 01 - 05 Jul 2024
LOCATION:

Barcelona (Spain)

INDIVIDUAL FEE:

5500 Euro



Course Content:

Unit 1: Review of Excel Skills:

  • Constructing formulae
  • Using functions
  • Absolute and relative cell referencing
  • Naming ranges

Unit 2: Automating Worksheets:

  • Creating and editing templates
  • Using data validation
  • Applying workbook & cell protection

Unit 3: Further Functions:

  • Nested IF functions
  • Using AND OR operators
  • Lookup and Reference functions
  • Text functions
  • Math and Trig functions
  • Financial functions

Unit 4: Summarising Worksheets:

  • Group and outline a worksheet
  • Hiding and displaying outlines

Unit 5: Pivot Tables:

  • Creating and modifying Pivot Tables
  • Refreshing the data
  • Grouping data within a Pivot Table

Unit 6: Data Management:

  • Using worksheet auditing tools
  • Tracing dependent and precedent cells
  • Checking for errors & highlighting invalid data

Unit 7: Macros:

  • Recording simple Macros
  • Running and editing Macros
  • Assigning Macros to the keyboard, toolbar buttons and menus

Unit 8: Analysis Tools:

  • Using the Goalseek tool
  • Creating ‘What If’ scenarios
  • Creating Data Tables

Strategic Business IT Planning, Deployment & Management Courses
MS Excel - Advanced (15094_267882)

REF: 15094_267882   DATE: 01.Jul.2024 - 05.Jul.2024   LOCATION: Barcelona (Spain)  INDIVIDUAL FEE: 5500 Euro

 

Mercury dynamic schedule is constantly reviewed and updated to ensure that every category is being addressed at least once a month, if not once every week. Please check the training courses listed below and if you do not find the subject you are interested in, email us or give us a call and we will do our best to assist.