Courses
SAVE – Special Offers – Click Here...
Latest News
SAVE – Special Offers – Click Here...

Excel - Adv - Evening Course (6-8 pm) - Content B

Enquire About This Course

CONTENT B

Our Belfast Excel training courses include Pivit Tables, Subtotals, etc

Advanced Functions

  • Lookup Functions (Horizontal and Vertical Lookup)

3D Ranges

  • Consolidate Data (via 3D Ranges & using the Consolidate Tool)

Pivot Tables

  • Create Pivot Table
  • Work with Row/Column Fields
  • Data Fields
  • Customise Table Display

Macros

  • Create Macros ?€? Record and Modify the VBA code generated
  • Relative Referencing
  • Assign to Toolbars/Keyboard
  • Make available to all new documents/current document only

Click here to download our Course Content:

ExcelEveningSessions_A&B

Enquire About This Course
Latest News
SAVE – Special Offers – Click Here...