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.

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: 15th November 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: 17th January 2020
  • 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: 30th January 2020
  • 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

CHARTS AND PIVOT TABLES (85% Charts / 15% Pivots)

This is a new course and is open to any level of Excel user. Will be beneficial if delegates are familiar with calculations in Excel.

Delegates will go from the basics right through to more Advanced Combination Charts and will be shown all the common charts that can be used to graphically represent their data. We will explain all the key calculations that will lead to successful charting and demonstrate the best formatting options that will enhance the look of a chart. Various aspects of chart automation will also be taught.A small section of the course will be devoted to the use of pivot tables with charts.

NEXT DATE: 16th December 2019
  • Correct storage and layout of data

  • The key calculations that will be needed for charting – calculations for summarising big sets of data and extra calculated columns that will give extra reporting options.

  • Calculations specifically for date analysis

  • Basic charts – understanding the four key types, the chart elements, the chart formula

  • Enhancing charts: secondary axis, combination charts, chart templates

  • Automating charts by calculations, by macro

  • Basic Pivots: colour schemes, layouts, custom colour schemes

  • Slicers – single, multiple, linking to multiple pivots

  • Automating pivots with macros

  • Combination of Pivots and charts on a dashboard

MAKE AN ENQUIRY