Training Course Outline
After the Course
You will be able to record macros, create templates to be used for future calculations, summarise information with pivot tables and use passwords to protect your work. You will also be able to combine powerful mathematical functions to automate tasks and use array formulas.
|Store, sort and filter lists such as names and addresses|
|Create financial templates such as invoices or expenses sheets|
|Display your data on a chart|
|Summarise large volumes of information in pivot tables|
|Create sophisticated formulas to calculate information |
|Link to external databases|
|Name a Cell or Range||Array Formulas|
|Spreadsheet Security||How to Use what You’ve Learnt|
|Left, Mid & Find||Date-Based Functions|
|More Functions||Conditional Formatting|
|Print Options||Customise Toolbars & Menus|
|VLookup & HLookup||Solver|
Microsoft Excel Level 4
Microsoft Excel is a spreadsheet programme which allows you to store lists of text and numerical information, and make calculations and projections.
Microsoft Excel training courses are available at our state of the art training centre in Dublin City Centre or we are happy to travel to your company premises anywhere in Ireland.
Fill out Microsoft Excel Pre-Course Questionnaire