Excel courses Northern Ireland

...After completing this course you will be prepared to attend our Advanced MS Excel training course. Course Content Screen Tour Toolbars & Menu Bar Sheets... Learn about: Microsoft Office...

...Functions Subtotal (partial) Tables and Pivot Charts Cooperation with other applications Get External Data (CSV, TXT) OLE (static and link) Web Queries... Learn about: Data analysis, Database Management, MS Excel...

...the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks. Adjustment... Learn about: MS Excel, Database training, Visual Basic...

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

...Enter a Function Math and trigonometry function Statistical Functions Logical Functions Search and address Information functions Date and Time Functions... Learn about: Ms Office, 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...

...(opening worksheet cell update etc) by means of the handler, Create form Macros Recording and editing macros Assigning macros to forms, toolbars... Learn about: Visual Basic training, Visual Basic, MS Excel...

...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: Microsoft excel training, Office IT, MS Excel...