Excel Evening Courses in Belfast City Centre
Our evening Courses have been tailored to meet the needs of professionals who need to improve their own peronal development and meet the requirements set by their particular institutes.
They run between 6pm and 8pm.
Please feel free to attend both sessions or whichever session content suits your specific requirements – feel free to contact us if you would like to discuss content or book a place on a course
CONTENT A
| Course | February 2020 | March 2020 | April 2020 | Duration | Price |
| Evening – Content A | 14 | 26 | 8 | 2 hours | Contact for Details |
| Evening – Content B | 20 | 27 | 17 | 2 hours | Contact for Details |
| Excel – Intro | 6 | 26 | 27 | 1 day | Contact for Details |
| Excel – Advanced | 28 | 26 | 30 | 1 day | Contact for Details |
| Excel VBA – Intro | 10 & 11 | 11 & 12 | 9 & 10 | 2 day | Contact for Details |
| Excel VBA – Advanced | 27 | 3 | 3 | 1 day | Contact for Details |
| Spreadsheet Tips and Tools for Accountants | 5 | 2 | 2 | 1 day | Contact for Details |
| Rolling Forecasts – Excel 2007/2010/2013 | 7 | 10 | 6 | 1 day | Contact for Details |
| Business Plan Modelling | 11 | 16 | 16 | 1 day | Contact for Details |
| PowerPivots – Level 1. | 12 | 30 | 30 | 1 day | Contact for Details |
| Upgrading to Excel 2010/2013 | 17 | 13 | 23 | 1 day | Contact for Details |
CONTENT B
Advanced Functions
- IF Function & Nested IF Statements
- And & Or Functions
- Conditional Formatting
Advanced Functions
- Lookup Functions (Horizontal and Vertical Lookup)
3D Ranges
- Create & Maintain (Within Worksheets in a single file & between external files)
3D Ranges
- Consolidate Data (via 3D Ranges & using the Consolidate Tool)
Data
- Sort data into Lists
- Filter data – Autofilter, Advanced Filter
- Validation Rules to restrict data entry
Pivot Tables
Comments