Excel courses Northern Ireland

...Average, Max, Min, Etc) Replicate Command (Use With Formula/ Functions, Fill Formats/ Series/ Trends, Days, Etc) Cell References Absolute Relative Range Names Create... Learn about: Microsoft Office...

...on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets. Adjustment of the working environment Hotkeys... Learn about: Database Management, MS Excel, Database training...

...of cells and ranges Protect worksheet and workbook Secure and encrypt files Collaboration and track changes, comments Inspection sheet Create your own templates... Learn about: Visual Basic, MS Excel, Database training...

...Functions and Sub-routines Data Types Control Flow If ...Then.Elseif.Else.Endif Case Do...Loop , While For... Next Exit Arrays and Loops Strings Visual... Learn about: MS Excel, Visual Basic training, 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 Excel, Ms Office...

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

...On Error Resume Next, On Error GoTo Excel Object Model The Application Object Workbook object and a collection of Workbooks Worksheet Object and Collection... Learn about: MS Excel, Visual Basic, Visual Basic training...

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