Green Shoots Learning | Excel Courses | workshops

MS Excel Training Solutions

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.  Increase your own or your employees productivity, build more reliable and robust solutions and deliver more professional reports to those that need them.

This everyday software is full of tools which will, when used correctly, increase data quality, reduce data inputting time, improve the reliability of calculations and reduce repetitive tasks.  What's stopping you up-skilling your employees to be more effective?

So many business have historic .xlx files which are being regularly used. Unfortunately the new web apps and office 365/2019 software will not work well with these old files. Help you employees work more productively by giving them the right tools for the job. Let Green Shoots solutions sort them out, and get on with what you do best.

Book a free consultancy chat
Take a skills analysis 
Book virtual learning now 

Our face to face and live online training events are totally tailored to cover your requirements. We won't put you or your employees in a box as beginner, intermediate or advanced.

 

However, if you are looking for some standard topics, or just need a bit of inspiration, please review the course overviews below.

Course overviews are designed for Face to Face workshops, for up to 8 delegates, but feel free to pick specific elements if you would prefer to do live online learning.

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

Starting Out with Excel

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

Fundamental Formulae in Excel

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

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

Creating Professional Reports in Excel

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

Automating Workbooks in Excel

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

Summary Tools in Excel

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

A 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

Face to Face
Resource Library
Live Online
  • LinkedIn App Icon
  • Twitter Classic
  • c-facebook
  • Green Shoots Learning
  • YouTube Social  Icon