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 18 June 2014 until 28 Aug 2014.

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 will be a bargain price of €40 for the Basic/Intermediate session and €50 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 get in touch with us on 01 443 4321 or info@cet.gno.ie