CET: Excel 2013 @TheMostFromIT

CET Excel Training 2014

Capital Example Training (CET) will be running Basic/Intermediate workshops each Wednesday (09:30 - 12:30) and Advanced workshops each Thursday (09:30 - 12:30) from 3 Jan 2018 until 1 Feb 2018.

A maximum of 3 places are available at each session. Places are limited and spaces go quickly, so we would recommend booking early. A half day session cost €30 for the Basic/Intermediate session and €35 for the Advanced session.

Below are some of the things the course will cover:

Basic/Intermediate: Advanced:
Top Tips and Shortcuts Business Reporting
Introduction to Excel 2013
  • Navigation and Selection Tips
  • One-Touch Tips
  • Visualising Data
  • The one-touch chart
  • Linking charts with reports
  • Combination of charts
  • Intro to Formula and Function
  • AutoSum
  • IF functions (IF, Count IF)
  • Relative and absolute references
  • Summarising Data
  • Pivot Tables
  • Pivot Table options
  • List Management
  • Using VLookup
  • Data validation
  • Sorting and Filtering
  • Cash Flow Management
  • Creating a template
  • Summarising data
  • Linking with online banking
  • Spread Sheet Automation
  • Conditional Formatting
  • Introduction to Macros
  • Workbook/Worksheet protection
Intermediate/Advanced (can be covered in both courses):
Adv. Formula and Function
  • Local functions (IF, AND, OR, NOT)
  • Nested functions
  • Summary Functions
After the course you will have learnt:
  • Shortcuts to reduce the time taken to complete tasks
  • Enhanced workbook navigation skills to get you the information you need quickly and efficiently
  • Ways to enter data faster and more accurately saving time and resources
  • How to better record and analyse key business performance indicators and develop business analysis tools to suit your business

If you would like more information or to book your place, please email info@cet.gno.ie