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 November 2019 December     2019 January 2020 Duration  Price
Evening – Content A 6 17 14 2 hours Contact for Details
Evening – Content B 27 4 31 2 hours Contact for Details
Excel – Intro 12 4 30 1 day Contact for Details
Excel – Advanced 20 12 14 1 day Contact for Details
Excel VBA – Intro 18 & 19 4 & 5 21 & 22 2 day Contact for Details
Excel VBA – Advanced 13 2 10 1 day Contact for Details
Spreadsheet Tips and Tools for Accountants 29 13 31 1 day Contact for Details
Rolling Forecasts – Excel 2007/2010/2013 21 16 14 1 day  Contact for Details
Business Plan Modelling 18 11 17 1 day Contact for Details
PowerPivots – Level 1. 22 19 9 1 day Contact for Details
Upgrading to Excel 2010/2013 28 5 27 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

 

 

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks