Excel courses Northern Ireland

...Data Labels, Data Table, Etc) Customising Page Setup Orientation & Margins Headers & Footers Gridlines, Titles & Page Order Scale Print Set Row & Column... Learn about: Microsoft Office...

...Web Queries Publication sheets on site (static and dynamic) Publication PivotTables Automation of work Conditional Formatting Create your own formats Check... Learn about: Database Management, Database training, MS Excel...

...charts, AutoShapes) Database management (list) Data consolidation Grouping and outlining data Sorting data (over 4 columns) Advanced data filtering Database... Learn about: Visual Basic, Database training, MS Excel...

...Error GoTo On Error Resume Next Excel Model Object Application Object Workbook Object and Workbooks Collection Worksheet Object and Worksheets Collection ThisWorkbook... Learn about: MS Excel, Visual Basic, Visual Basic training...

...the Page Setup Print preview A dialog box, printing Using lists Lists Transforming the range of the list Application forms AutoFilter Advanced filters... Learn about: MS Excel, Ms Office...

...charts, AutoShapes) Database management (list) Data consolidation Grouping and outlining data Sorting data (over 4 columns) Advanced data filtering Database... Learn about: MS Excel, Database training, Data analysis...

...using ScreenUpdating The time measurement by the method Timer Event handling in VBA What is an event? Responding to an event and create an event handler... Learn about: MS Excel, Visual Basic, Visual Basic training...

...and delete cells Copying cells Copy and Paste commands The fill handle Fill command Series data and Autofill option Copying formulas Relative reference... Learn about: Ms Office, Office IT, Microsoft excel training...