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