Microsoft Excel (Advance)

by The Glasgow Training Group Claim Listing

A hands-on instructor-led Microsoft Excel training course allowing people based in Scotland with an existing knowledge of Excel fundamentals to improve their skills and create better spreadsheets.

$200

Contact the Institutes

Fill this form

Advertisement

The Glasgow Training Group Logo

img Duration

1 Day

Course Details

A hands-on instructor-led Microsoft Excel training course allowing people based in Scotland with an existing knowledge of Excel fundamentals to improve their skills and create better spreadsheets. 

A useful capability with analysing and presenting data with Excel is achieved through learning, discussion and practice with an expert trainer in a professional classroom environment.

 

Course Content:

  • • Consolidate data in different workbooks Advanced List Management
  • • Subtotals
  • • Data Validation
  • • Database Functions Analysing Data
  • • Goal Seek
  • • Solver
  • • Scenarios
  • • Trendlines Pivot Tables
  • • Creating a PivotTable
  • • Rearranging PivotTables
  • • Formatting PivotTables
  • • PivotCharts
  • • Create Slicers Collaborating with Other Users
  • • Protect a Worksheet
  • • Protect Workbooks
  • • Set a Workbook password
  • • Share a Workbook
  • • Set Revision Tracking Advanced Formulas
  • • Using Names
  • • Decision-making
  • • Nesting
  • • Financial functions
  • • Match and Index Macros
  • • Record a Macro
  • • Run a Macro
  • • Attach a Macro to a button Importing and Exporting data
  • • Importing data
  • • Exporting data

 

Course Prerequisites:

Attendees should certainly already have a working capability with Excel prior to coming along to this training event. It will have been useful to have previously attended an Excel Managing Data course and/or perhaps an Excel 2016 Presenting Information course - or alternatively already have been accomplishing spreadsheet tasks working within Excel for a period of time.

 

Who Should Attend?

This training is for existing Excel 2016 users and is designed to be an advanced level training course for people who would like to achieve a high level of capability in what Excel 2016 is capable of.

  • Glasgow Branch

    1330 South Street, Glasgow

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy