Excel courses Northern Ireland

...You will feel more confident using Excel and be able to create a spreadsheet from scratch. Understanding and using some of the built in calculation... Learn about: Microsoft Office...

...and workbook Secure and encrypt files Collaboration and track changes, comments Inspection sheet Create your own templates (charts, worksheets... Learn about: Data analysis, MS Excel, Database Management...

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

...as a three day course. Macros Recording and Modifying Macros Assigning Macros to Toolbar, Buttons, Shortcut key Visual Basic for Applications Environment... Learn about: MS Excel, Visual Basic, Visual Basic training...

...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...

...the correctness Recording and editing macros Visual Basic for Applications Create your own functions Results in VBA VBA Forms... Learn about: Database training, Data analysis, Visual Basic...

...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 training, Visual Basic...

...and absolute reference Appeals mixed Moving the cell The Office Clipboard Recall, repeat and redoing operations Working with workbooks Excel Files Spreadsheets... Learn about: Office IT, Microsoft excel training, MS Excel...