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

Course April 2013 May
2013
June 2013 July
2013
Duration Price (excl. VAT)
Evening – Content A 20 5  8 4
2 hours
£40.00
Evening – Content B   21 6 15 11
2 hours
£40.00
Excel – Intro   2 4 22 18
1 day
£110.00
Excel – Advanced 27 18 29 25
1 day
£160.00
Excel VBA – Intro 15 & 16  11 & 12  9 & 10  11 & 12
2 day
£330.00
Excel VBA – Advanced  15 11 29 19
1 day
£390.00
Spreadsheet Tips and Tools for Accountants  8 6 17 26
1 day
£215.00
Rolling Forecasts – Excel 2007  16 13 24 6
1 day
£215.00
Business Plan Modeling  22 20 4 13
1 day
£215.00
Upgrading to Excel 2007    29 21 31 20
1 day
£160.00

 

        CONTENT A   

 

        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