Microsoft Excel - Advanced

Introduction

Designed for power users or those who typically would produce spreadsheets of a more complicated nature and who wish to further develop their skills.  Also for those wishing to analyses data using Excel as a database.

Pre-requisites

Participants attending this course should have a good understanding of the basics and be able to confidently demonstrate them. A pre-course questionnaire is available for participants to confirm their existing knowledge before attending this programme.

Benefits

Time efficient and effective creation, manipulation and reporting of data to support business decisions.

Programme Objectives

The aim of this course is to develop participants’ usage of Excel and enable them to utilise the Add-ins in order to produce sophisticated reports containing relevant information.  The power and adaptability of macros will also be practiced in order for participants to return to their own environments with an all-round knowledge and understanding of the software.
 

Programme Content

• Using Excel as a Database
• Formatting as a Table
• Quick Analysis (versions 2013 onwards)
• Nested IF Statements
• Combined Functions i.e. IF, Vlookup, And, Offset, Match, Choose
• Sorting
• Filtering
• Data Validation
• Pivot Tables
• Slicers (versions 2010 onwards)
• Data Models and Relationships (versions 2013 onwards)
• Timeline
• Forecast Sheets ((versions 2016 onwards)
• Using Views and Creating Reports
• Goal Seek
• Scenarios
• Data Tables
• Recording a Macro
• Assigning Macros to Buttons
• Viewing Code
• Editing Code
• Linking Data with Other Applications
• Screenshots- (versions 2010 onwards)
• Apps for Office (versions 2013 onwards)
• 3D

Exact content will vary depending on version