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

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

...Formatting (style, format painter) Tool go to Organization of information Management sheets (naming, copying, color change) Assign and manage the names... Learn about: Database training, Visual Basic, MS Excel...

...This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in... Learn about: Visual Basic training, MS Excel, Visual Basic...

...workbook Windows workbooks Save files to disk Opening an existing workbook The use of functions in formulas Functions Construction features The function arguments... 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: Data analysis, Visual Basic, Database training...

...(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, MS Excel, Visual Basic...

...and points Chart Elements Chart types Options charts Titles Axles The grid lines Legend Data labels Data table Printing Printing Dialog, the Page Setup... Learn about: Office IT, MS Excel, Ms Office...