Green Shoots Learning | Excel Courses | workshops

Microsoft Excel Training Options

MS Excel is a powerful software application which can be used to create simple calculations or form complex data analysis and financial forecasting.  Excel is used widely within the workplace, but many of us have never received any help in getting the very best out of it. We often find delegates have started out using Word and progressed to Excel, but unfortunately many of the techniques we use in Word are not suitable or are time-consuming in Excel.

Let us run a free skills analysis for you. Find out what tools could help your employees become more productive and then decide whether a workshop, 1:1 coaching session or access to online e-learning content could help your business.

 

If you are looking for an off-the-shelf course, here are a selection of short courses which will give you lots of practical skills to put into action. They allow you to build up your skills set in the areas you need, over a time period that's right for you. 

New Features Excel 2019 & Office 365

A workshop for existing Excel users who are moving or have moved to Excel 2019 or 365. It looks at the new tools and advanced features now available.

  • Map Charts and Funnel Charts
  • Insert SVG's
  • Insert 3D models
  • Precision selecting tools​
  • Improved auto-complete tool
  • New themes
  • Improved translation tools
  • Improved Power Pivot tools
  • Improved connectors in Get & Transform tools

This workshop is designed to be run on-site for up to 8 delegates.  All support materials and exercises are provided.  Hardware can be provided at an additional charge.

Starting Out with Excel 2019 & 365

Designed for those who haven't used Excel before. This workshop gives a great overview and essential skills including:-

  • The language of Excel

  • Different ways of navigating the Excel screen

  • Inputting data & understanding data types

  • Data manipulation techniques

  • The importance of print preview 

  • Printing options to suit your spread sheet

 

This workshop is designed to be run on-site for up to 8 delegates.  All support materials and exercises are provided.  Hardware can be provided at an additional charge.

Fundamental Formulae in Excel 2019 & 365

This workshop concentrates on the common rules and structure of formula and functions in Excel. It is perfect for delegates wanting to progress and get into good habits.

  • BODMAS
  • Absolute Cell Referencing
  • Creating basic formula
  • Using Auto-functions
  • The Formula ribbon and bar
  • Introduction to IF Statements
  • Use of SUMIF
  • Use of COUNTIF
  • Error checking

This workshop is designed to be run on-site for up to 8 delegates.  All support materials and exercises are provided.  Hardware can be provided at an additional charge.

Advanced Functions in Excel 2019 & 365

This workshop is designed for delegates who are already using basic functions. It will look at popular functions and how to combine them.

  • Nested If statements with And / Or
  • V Lookup & H Lookup
  • Combining functions
  • Creating Named Ranges
  • Linking between spreadsheets

This workshop is designed to be run on-site for up to 8 delegates.  All support materials and exercises are provided.  Hardware can be provided at an additional charge.

Creating Professional Reports in Excel 2019 & 365

This workshop is a must do for anyone wanting to create professional looking reports in Excel. 

  • Construction rules
  • Apply different formatting options
  • Create conditional formatting rules 
  • Customise headers & footers
  • Change page layout options to best suit your report
  • Customise Excel themes to reflect your house style
  • Create and customise charts and graphs
  • Create and save personal templates

This workshop is designed to be run on-site for up to 8 delegates.  All support materials and exercises are provided.  Hardware can be provided at an additional charge.

Automating Workbooks in Excel 2019 & 365

This course is for anyone regularly using Excel. It looks at the tools we can use to automate repetitive tasks and increase productivity

  • Terminology 
  • Recording a simple macro
  • Key principles of Visual Basic
  • Visual Basic Developer window
  • Saving macros in templates

This workshop is designed to be run on-site for up to 8 delegates.  All support materials and exercises are provided.  Hardware can be provided at an additional charge.

Summary Tools in Excel 2019 & 365

A great workshop for delegates working with large data sets. This provides an overview of the many tools available in Excel to help you consolidate, group and summarise numerical data.

  • Summary functions
  • Consolidation tools
  • Grouping tools
  • Get & Transform Tools
  • Pivot tables

 

This workshop is designed to be run on-site for up to 8 delegates.  All support materials and exercises are provided.  Hardware can be provided at an additional charge.

Creating Visual Content in Excel 2019 & 365

A half day course providing everything you need to know about creating visually pleasing charts and graphs in an Excel spreadsheet

  • Layout rules for Charts
  • Types of Charts and Graphs
  • Recommended Charts & Graphs
  • Quick format options
  • Personalisation
  • Advanced customisation
  • Use of SmartArt in Excel

 

This workshop is designed to be run on-site for up to 8 delegates.  All support materials and exercises are provided.  Hardware can be provided at an additional charge.

Please reload

Creating memorable learning through flexibility

We won’t categorise your employees into beginner, intermediate and advanced as we find this restricting. However we will design workshops around the skill sets your employees need to succeed in their current and future roles.

 

We probably can’t provide all of the answers to all of your questions online so please call us on 0333 344 4031  to discuss your requirements or book your free 1 hour no-obligation consultation. 

 

The workshop content above is provided purely as a guide as all Green Shoots Learning courses are customised to best suit your business requirements. Pre-workshop consultancy is provided for all bookings, either in person or over the telephone where we will work with you to build in your company procedures and best practice.  

 

All workshops and courses include full support materials accessed from The GSL-Anytime platform, note-pad and pen, all exercises and any printed handouts required for the day, on-line evaluation, personal action cards, individual 4 week delegate follow up and a full post-workshop Client report.

 

Our workshops can be run on-site or at a convenient public location (we will even sort out room hire for you if needed), across Bedfordshire, Cambridgeshire, Essex, Hertfordshire, Norfolk and Suffolk.

  • Twitter Classic
  • YouTube Social  Icon
  • LinkedIn App Icon
  • c-facebook