-
All
-
Online
-
Filters
-
Location
-
Online
-
Type of studies
-
+ Filters
Excel macros & vba courses
- Training
- Online
- Advanced
- 1 Day
... of Microsoft Excel... Learn about: Date Functions, Goal seek, Data tables...
- NVQ
- Online
- Different dates available
- 1 Year
... and editing macros, and utilising advanced formulas, as well as broader business administration and IT skills... Learn about: MS Excel, Microsoft Excel, Excel Interface...
- Training
- Inhouse
...To develop automated procedures in Excel using the Visual Basic for Applications language...
- Course
- Inhouse
- Advanced
- 1 Day
...You will learn: Advanced worksheet formatting and Excel shortcuts. Using named ranges in formulae. Formula Auditing - tracking changes. 'What if' forecasting using one and two variable data tables and scenarios. Formula building. LOOKUP functions. Automatic Outline. Restricting input using...
- Course
- Readingand2 other venues
- Birmingham, London-City
.... TARGET AUDIENCE The course is designed for existing, experienced users of Excel 2007, 2010, 2013 or 2016 who need to use VBA to automate their spreadsheets. Delegates should therefore have a solid grounding in, and understanding of, Microsoft Excel to a high level. Familiarity with the content... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...
- Training
- Sunderland
- Advanced
- Different dates available
- 2 Days
...Become fully proficient with Microsoft VBA Programming. Individuals will be able to make use of the most powerful features of Microsoft Excel available through programming VBA code. Some of topics covered include macros, writing/editing code, variables, objects, properties and methods, control... Learn about: VBA (Microsoft Access / Office), Excel Objects, Excel Functions...
- Short course
- Cambridge
- Advanced
- 2 Days
...Description Excel dashboards enable visualisation of data to produce high level management reports. Dashboards often have user interactivity to convey the most important information at a glance. At the end of this course, delegates will be able to manipulate tables of data & use relevant functions... Learn about: MS Excel, Microsoft Office, Microsoft Excel...
- Course
- London
- Advanced
- 2 Days
...create custom templates to be more productive. automate repetitive and/or complex tasks using macros. summarise data using pivot tables. analyse and extrapolate data using scenarios and solver. create complex formulae using combinations of functions like vlookup and match. use array formulae...
- Course
- Inhouse
...If you're already up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create...
-
I'm looking forward to do my next course here!
← | →
-
The teacher kept the session moving, it was fun and easy to understand!
← | →
-
Great course and excellent trainer.
← | →
- Course
- Inhouse in London
- Intermediate
- Different dates available
- 2 Days
... that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA... Learn about: Text Functions, Excel Formulas, Microsoft excel training...
... that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA... Learn about: Text Functions, Excel Formulas, Microsoft excel training...
-
I'm looking forward to do my next course here!
← | → see all
-
The teacher kept the session moving, it was fun and easy to understand!
← | → see all
-
Great course and excellent trainer.
← | → see all
- Course
- Online
- Beginner
- Different dates available
- 2 Days
... and much more besides. Microsoft Excel VBA macros are fun - let us show you why! Suitable for: This Excel VBA macros course is aimed at people who have a good existing working knowledge of Excel 2003, Excel 2007 or Excel 2010 and want to learn how to speed up their worksheets using macros... Learn about: Automating Excel, Visual Basic, Loops & conditions...
- Course
- Online
- Advanced
- Different dates available
- 1 Year
...At work, are you required to use the Microsoft Office 2016 suite, including Word, Excel, PowerPoint, Access, and Outlook? If so, then why not master both the basic and advanced features of these in order to fully benefit your career. Whether you’re a Microsoft Office 2016 beginner or otherwise... Learn about: Office IT, MS Excel, Ms Office...
- Training
- London
- 2 Days
...This course will show you how to Automate and Simplify complex tasks in Excel. At the end of the course, users will be able to record and run macros, edit the VBA code, build in loops structures and create custom forms... Learn about: MS Excel...
- Course
- Worthing
- 2 Days
... with Controls Creating Custom Dialog Boxes Userform Properties Methods & Events Event Handling VBA Editing & Debugging Auto Macros Error Handling...
- Course
- Online
..., or with a simple copy and paste of your new data into your spreadsheet. TARGET AUDIENCE Anyone with an advanced knowledge of Excel who wants to learn how to create dashboards which will enhance their spreadsheets with easily understood and interactive data displays. Excel Dashboards provide insight, analysis... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...
-
Really, truly delighted in it all.
← | →
-
The thing that I loved most about the course was that it was very much charming, nicely clarified/educated and placed hypothesis into practice.
← | →
-
The mode of instruction was awesome and the clarifications were great.
← | →
- Short course
- Nottinghamandanother venue.
- Timperley
- Advanced
- Different dates available
- 1 Day
...Emagister adds to its catalogue the Microsoft Excel VBA Training, which will enable you to use Excel Visual Basic for Applications (VBA) to automate and customise spreadsheets. Were appropriate your own work requirements may be used as course examples. Click on our website emagister.co.uk in order... Learn about: MS Excel, Microsoft Excel VBA training, Microsoft excel training...
...Emagister adds to its catalogue the Microsoft Excel VBA Training, which will enable you to use Excel Visual Basic for Applications (VBA) to automate and customise spreadsheets. Were appropriate your own work requirements may be used as course examples. Click on our website emagister.co.uk in order... Learn about: MS Excel, Microsoft Excel VBA training, Microsoft excel training...
-
Really, truly delighted in it all.
← | → see all
-
The thing that I loved most about the course was that it was very much charming, nicely clarified/educated and placed hypothesis into practice.
← | → see all
-
The mode of instruction was awesome and the clarifications were great.
← | → see all
- Short course
- London
- 1 Day
... In A Workgroup · Sharing Your Projects · Using Routing Slips · Receiving A Routed Project Project VBA · Using Existing Macros · Examining The Macro Code...
- Course
- London
- Advanced
- 2 Days
...create custom templates to be more productive. automate repetitive and/or complex tasks using macros. summarise data using pivot tables. analyse and extrapolate data using scenarios and solver. create complex formulae using combinations of functions like vlookup and match. use array formulae...
- Short course
- Washington
- 1 Day
...If you're already up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create...
-
Excellent pace and freedom to ask questions but also got through content and exercise
← | →
-
Excellent! Great to have one on one training and able to go at a pace to suit
← | →
-
It was a great course. Some of the things that I needed in everyday work will be much easier after applying what I’ve learnt. The things I’ve learnt are practical. It was also great that Geoff took time to answer some of the questions
← | →
- Short course
- Twickenham
- Different dates available
- 2 Days
...This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items... Learn about: Intrinsic functions, VB Editor, Deleting macros...
...This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items... Learn about: Intrinsic functions, VB Editor, Deleting macros...
-
Excellent pace and freedom to ask questions but also got through content and exercise
← | → see all
-
Excellent! Great to have one on one training and able to go at a pace to suit
← | → see all
-
It was a great course. Some of the things that I needed in everyday work will be much easier after applying what I’ve learnt. The things I’ve learnt are practical. It was also great that Geoff took time to answer some of the questions
← | → see all