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

...The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations... Learn about: Database training, MS Excel, Database Management...

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

...Events Handling in VBA VBA Forms Creating and Using Forms Invoking Forms in VBA Code Using VBA Forms in Worksheet... Learn about: MS Excel, Visual Basic training, Visual Basic...

...column width and row height Auto-fit AutoFormat Remove formatting from cells Working with Graphic Objects Graphical objects Drawing Toolbar Drawing objects... Learn about: MS Excel, Ms 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: Visual Basic, MS Excel, Database training...

...to procedural programming Procedures: Function Sub Data types The if statement ... then ... elseif ... else ... end if Case statement Loops for... 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, Ms Office, Office IT...