Course Title: Microsoft Excel Visual Basic Applications (VBA) Aims: To illustrate how to use macro programming to speed repetitive tasks when employing Microsoft Excel Pre-requisites: Delegates MUST be familiar with the use and exploitation of Microsoft Excel at an Advanced level Duration: Two Days What is a Macro Read more…
Data Analysis Using ‘Get & Transform’ and Microsoft Excel Power Pivot Description: The topics included in this course provide the user with additionaltools for data analysis. The course covers importing data from avariety of sources, analysing quantities of data beyond the normalscope of Excel and speeds up linking data held in Read more…
Microsoft Excel Introduction Aims: Introduces the workings and concepts of spreadsheets in Excel including simple formulas and formatting Pre-requisites: Attendance of a Windows Introduction or a good understanding of the Windows Environment Duration: One day Excel Introduction Spreadsheeting concepts Using the keyboard and mouse The Read more…
Microsoft Excel Intermediate Aims: Looks deeper into Excel, including analytical and data retrieval formulas Pre-requisites: Must have attended the Microsoft Excel Introduction or have a good working knowledge of the product Duration: One day Workbooks Concepts of a Workbook Moving around a Workbook Inserting and deleting worksheets Renaming and moving worksheets Read more…
Microsoft Excel Advanced Aims: Enables users to customise Excel spreadsheets to produce valid and clear reporting of data integrated with macros for faster ways of working Pre-requisites: Must have attended the Microsoft Excel Introduction & Intermediate courses, or have an extensive working knowledge of the product Duration: One day Read more…