Microsoft Excel is a spreadsheet application that features calculation, graphing tools, pivot tables and a macro programming language called VBA. It is used by a large proportion of the workforce for a variety of different purposes from storing lists through to complicated analysis.
Microsoft Excel is an extremely powerful and easy to use application.
This course introduces techniques employed by experienced users to enhance your use of Excel and build feature rich spreadsheets. This will not only benefit your business but will develop your own key skills.
Our training allows you to capitalise on this extremely useful resource. Our standard Advanced course is outlined below but we can discuss bespoke courses and also collaborative development of any spreadsheet you wish to create.
Anyone who has had previous training and a working knowledge of Excel before embarking on this course.
The Programme Topic Areas are:
• Working with advanced formulas
• Lookups and data tables
• Advanced list management
• Working with PivotTables and PivotCharts
• Exporting and importing
• Using analytical options
• Working with macros
• Interactive Web pages
• Summary & action plans agreed