Other courses available in:
Course Summary
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.
Course Certification
GTG Certificated
Get in touch
If you'd like more information about any of our courses, please contact our customer support team.
Make an Enquiry
