-
All
-
Online
-
Filters
-
Location
-
Online
-
Type of studies
-
+ Filters
Inhouse Excel Training
- Training
- Inhouse
- 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...
- Training
- Inhouse
- 2 Days
...To give users an understanding of macros and visual basic. Knowledge gained from the problem solving and error trapping exercises will enable delegates to code programmes within the Excel application. Suitable for: This course is suitable for users of Excel who want to gain a good knowledge of...
- Training
- Inhouse
...To develop automated procedures in Excel using the Visual Basic for Applications language...
Similar training in other typologies
- Short course
- Inhouse in Cambridgeshire
- Beginner
- 1 Day
... by automating many of the repetitive tasks that are part of spreadsheet development. In Excel...
- Course
- Inhouse
...This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures...
-
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
... 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: Excel Tables, Quick Analysis, Text Functions...
... 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: Excel Tables, Quick Analysis, Text Functions...
-
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
-
The venue was central, convenient to get to.
← | →
-
Help fill in a lot of gaps and enjoyed the lunch.
← | →
-
Exceptional lunch and a great course.
← | →
- Course
- Inhouse
- Different dates available
...This course is intended for participants who are familiar with Microsoft Excel 2013 who want to learn VBA programming. The course is run as a 2 Day program for a group of up to 8 or as a special 1 Day 1:1 version. Delegates wanting a 1:1 course can have the advantage of the coach helping... Learn about: MS Excel...
...This course is intended for participants who are familiar with Microsoft Excel 2013 who want to learn VBA programming. The course is run as a 2 Day program for a group of up to 8 or as a special 1 Day 1:1 version. Delegates wanting a 1:1 course can have the advantage of the coach helping... Learn about: MS Excel...
-
The venue was central, convenient to get to.
← | → see all
-
Help fill in a lot of gaps and enjoyed the lunch.
← | → see all
-
Exceptional lunch and a great course.
← | → see all
- Course
- Inhouse
- Advanced
- Different dates available
...Our Excel VBA Level 3 course is designed for experienced Excel VBA developers who are familiar with working with the Excel object model... Learn about: Excel on-site training, Excel in-house training, Excel training...
- Course
- Inhouse
- 1 Day
...Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code...
- Course
- Inhouse
- Advanced
- 1 Day
... protection and data validation. Using the form tools. Goal Seek and Solver analysis. Using the Scenario Manager. Importing data into Excel. Navigation using hyperlinks, command buttons and sheet and range naming. Excel macros. Suitable for: The experienced Excel user who wishes to examine the more advanced...
- Short course
- Inhouse
- Advanced
- 1 Day
... The Global Template Other Applications · Exporting Overview · Copying To Word/Excel · Exporting To Excel Using Mapping · Exporting To A Database Reporting...
- Short course
- Inhouse
- Intermediate
- Different dates available
...If you have mastered tables, queries, forms and reports in Access, it is maybe time to learn. This two-day course shows you how to use Access VBA to automate your databases, making your database development easier - and more fun! Suitable for: This Access VBA macros course is aimed primarily... Learn about: Debuggin and error handling, Creating functions, Linking to Excel & Word...
- Course
- Inhouse in Royal Leamington Spa
- Different dates available
- 2 Days
...This course is designed for delegates who have little or no knowledge of Visual Basic and are seeking to develop code for use within Microsoft Excel workbooks. It should give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, basic VBA programming, event... Learn about: Office systems, Microsoft Excel, Microsoft Project...
- Short course
- Inhouse in Cambridgeshire
- 1 Day
...Students will probably get the most out of this course if they want to learn the skills and concepts necessary to work with advanced features of Excel 2000. Students should have a basic knowledge of the concepts involved in using Excel 2000. For example, they should be familiar with data types...
- 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...
-
Amzing course, the topics covered were very interesting and the trainer was very clear using various examples
← | →
-
I really learnt in this course. Very fun and informative.
← | →
- Course
- Inhouse
- Intermediate
- Different dates available
... security settings Edit the macro Create a macro by using VBA Copy part of a macro to create another macro Delete a macro Assign a macro to a button... Learn about: Quick Analysis, Calculated columns, Excel Tables...
... security settings Edit the macro Create a macro by using VBA Copy part of a macro to create another macro Delete a macro Assign a macro to a button... Learn about: Quick Analysis, Calculated columns, Excel Tables...
-
Amzing course, the topics covered were very interesting and the trainer was very clear using various examples
← | → see all
-
I really learnt in this course. Very fun and informative.
← | → see all
-
Interesting 2 days, very knowledgable instructor.
← | →
-
Trainer had vast knowledge, even covered some data analytics.
← | →
-
Additional examples where a fresh approach to most courses that I have been on.
← | →
- Short course
- Inhouse
- Beginner
- Different dates available
...Microsoft’s Power Pivot and business intelligence tools allow you to effectively mine large amounts of data. In this advanced Microsoft Excel training course, you gain the knowledge and skills to import and merge large amounts of data, summarise and aggregate data, present strategic data, provide... Learn about: Data Analytics, MS Excel, Microsoft Excel...
...Microsoft’s Power Pivot and business intelligence tools allow you to effectively mine large amounts of data. In this advanced Microsoft Excel training course, you gain the knowledge and skills to import and merge large amounts of data, summarise and aggregate data, present strategic data, provide... Learn about: Data Analytics, MS Excel, Microsoft Excel...
-
Interesting 2 days, very knowledgable instructor.
← | → see all
-
Trainer had vast knowledge, even covered some data analytics.
← | → see all
-
Additional examples where a fresh approach to most courses that I have been on.
← | → see all
- Course
- Inhouse
- Advanced
- Different dates available
...Overview Our Excel VBA level 1 course shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment... Learn about: Excel on-site training, MS Excel, Visual Basic training...
- Course
- Inhouse
- 1 Day
...Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code...
- Course
- Inhouse
- Advanced
- Different dates available
...Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel's Visual Basic Editor... Learn about: Excel in-house training, MS Excel, Visual Basic...
"excel vba"
- Training
- Inhouse in London
- 4 Weeks
...You will be using Excel, Sage Line 50 and Sage Payroll, for you to prepare the following: Bookkeeping Purchase and Sales Ledger Self Assessment Sole Trader...