T: 01473 414414

select courses

we have a wide range of courses proven to be effective
select
courses

We have a wide range of diverse courses proven to be effective

explore
create your own
courses

Partnering with you to develop your solutions

explore
public sector
courses

We have a wide range of courses to suit you. Explore our full range here

explore

Free Download

Please complete this form to instantly receive your FREE PDF by email


Microsoft Excel - Advanced

1 Day

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

Customers who were interested in this course were also interested in...