EXCEL

The Excel introduction course will provide you with the skills and confidence to work with existing spreadsheets or create new ones from scratch. The course will cover all the basic topics including basic text and number entry, performing calculations, and using charts.

Microsoft Summer Training School Special £120 + vat per delegate – Enquire for further details!

EXCEL INTRODUCTION

The Excel introduction course will provide you with the skills and confidence to work with existing spreadsheets or create new ones from scratch. The course will cover all the basic topics including basic text and number entry, performing calculations, and using charts.

NEXT DATE: 8th July 2019
  • Getting to know the Excel screen, menus and Icons
  • Basic text and number entry, moving and copying
  • Cell formatting using icons and shortcuts
  • Inserting and deleting
  • The autofill shortcut
  • Applying decimals and percentages
  • Formatting spreadsheets
  • Entering basic formulas
  • Understanding cell references
  • The sum function
  • Other common Excel functions
  • Setting up lists(databases)
  • Sorting lists alphabetically
  • Using the autofilter tools
  • Printing options for basic and longer spreadsheets
  • Working with column, pie and line charts
  • Formatting chart elements

EXCEL INTERMEDIATE

Designed for delegates who already know the basics of Excel, this course will concentrate on various way to analyse your data. Learn how to use Excels in built functions and how to summarise data by using the fantastic Pivot table tool, as well as other tools to analyse longer Excel lists.

NEXT DATE: 10th July 2019
  • Recap of Excel basics
  • Using calculations across different worksheets
  • Setting up 3d workbooks
  • Naming cells and ranges
  • Recap on Excel functions
  • Entering statistical functions
  • Using conditional functions
  • Validation to improve functions
  • Date calculations
  • Introduction to nested functions
  • Correct set up to manage longer database
  • Creating subtotals and outlines
  • Setting up pivot tables
  • Pivot table layout options

EXCEL ADVANCED

The Advanced Excel course will benefit the more experienced spreadsheet users. The course will cover logical and lookup functions and how to combine functions to solve specific problems. Learn how to use Excels what-if tools and start recording macros to automate repetitive tasks and increase productivity.

NEXT DATE: 11th July 2019
  • Using advanced filters to extract data
  • Dynamic named ranges
  • Basic and more complex validation using functions
  • Database functions
  • If statements
  • Other logical functions
  • Multiple ‘If’ statement decisions
  • Vlookup and multiple lookup combination formulas
  • Nested functions
  • “What-If” utilities- goal seek, the solver tool
  • Working with scenarios
  • Adding data tables
  • Understanding macros
  • Storing and recording macros
  • Running macros
  • Attaching macros to a button
  • Excels auditing tools

MAKE AN ENQUIRY