-
All
-
Online
-
Filters
-
Location
-
Online
-
Type of studies
-
+ Filters
Excel macros & vba courses
- Course
- Online
- Intermediate
- Different dates available
...The Microsoft Excel 2016 is a data processing program. If you have no idea or experience in using Excel then you don’t have to worry since this course can train you. Taking this Microsoft Excel 2016 and VBA Training Diploma will let you know how to develop macros, format worksheet using macros... Learn about: Developing Macros, Microsoft Excel, MS Excel...
- Course
- Online
- Intermediate
- Different dates available
... onto formatting worksheets as you look into inserting and formatting text, sorting and duplicating data, and generating reports using macros. Following that you will learn to identify the appropriate dialog box types and ways to capture user input through a variety of techniques. Finally, you will... Learn about: Edit a Macro, Macro Security, VBA Training...
- Course
- Online
- Different dates available
- 1 Year
..., and make informed decisions. You’ll also learn about calculating depreciation, interest, and loan EMI using Excel functions. The course also features information on INDEX and MATCH functions, using the CHOOSE formula, and how to create unique charts. The software is invaluable in financial analysis... Learn about: MS Excel, Excel Tables, Converting Tables...
- Course
- Online
- Different dates available
... Diploma teaches everything you need to know about creating workbooks, creating formulas and functions and analysing data through video lessons, online study materials, multiple-choice automated assessments and practical exercises. The microsoft excel bundle course is a comprehensive course covering... Learn about: MS Excel, Financial Training, Microsoft Excel...
- Course
- Online
- Different dates available
... Validate Data Using a Macro Automate Data Entry Using a Macro Convert a Macro to VBA Link Tables to External Data Sources Manage a Database Determine Object... Learn about: Convert a Macro to VBA, Work with Records, Summarize Data...
- Course
- Reading
- 2 Days
...To provide delegates with the confidence, knowledge and practical experience to be able to automate tasks in Excel for rapid numerical analysis & presentation of information. Delegates will learn how by using macros, they can create flexible solutions that can be used by colleagues with limited...
- Training
- Glasgow Cityandanother venue.
- Edinburgh
- Beginner
- Different dates available
- 2 Days
...Learn how to program Microsoft Excel using VBA code. The course is designed to give delegates a thorough overview of programming within the Excel environment, enabling them to improve the functionality of their Excel spreadsheets... Learn about: Microsoft Office, Excel Sheet, Microsoft excel training...
- Short course
- Londonand2 other venues
- New York, Amsterdam
- Intermediate
- 1 Day
...The purpose of this one day workshop is to take delegates VBA knowledge to the next level. After this course delegate will be quicker and more efficient in VBA programming. They will also be able to produce complex user interactions through advanced userforms and automate some fundamental tasks...
- Training
- Nottingham
- Advanced
- Different dates available
- 1 Day
...This day long Excel VBA programming course introduces advanced Excel users to the process of writing and editing Macros in Excel. No prior programming experience is required. You will learn how to Record a Macro, Run a Macro, create a Standard Module, create a Sub Procedure, create a Function... Learn about: Visual Basic, Excel 2007, Visual Basic training...
- Course
- London
- 2 Days
...On completion of this course the user will be able to design, write and debug Excel Visual Basic macros, create a dialog box and suitable control structures, and create custom Excel functions. Suitable for: This 2-day course is aimed at experienced Excel users, preferably with some awareness...
- Course
- Online
- Different dates available
...The Microsoft Excel 2016 is a data organization and processing application created for everyone who needs it. Knowing the basics will enable you to use the application but acquiring advanced skills will let you utilize everything the application has to offer. After taking this Microsoft Excel... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...
- Course
- Londonandanother venue.
- Leeds
- 2 Days
...The skills and knowledge acquired in Microsoft Excel VBA Introduction are sufficient to be able to use and operate the software at an efficient level. Suitable for: Microsoft Excel VBA Introduction is designed for users who are keen to extend their understanding and knowledge of the software...
- Training
- London
- Advanced
- Different dates available
- 3 Days
...Introduction to Excel VBA Programming Understanding Macros The Visual Basic Editor Excel VBA Fundamentals Variables, Data types, and Constants... Learn about: Analytic Expert...
- Course
- Online
- Beginner
- Different dates available
- 1 Year
...The Microsoft Access 2016 Beginner to Advanced course is the ultimate online training program for mastering Excel, ideal for those who want to improve their proficiency and confidence in managing data-based tasks. Through step-by-step guidance, it covers Excel 2016’s most important features... Learn about: Database training, MS Excel, Microsoft Access...
- Training
- Brighton and Hove
- 2 Days
...To develop automated procedures in Excel XP using the Visual Basic for Applications language. Suitable for: Anyone who has some experience of recording macros in Excel...
- Course
- Online
- Different dates available
... Data Using a Macro Automate Data Entry Using a Macro Convert a Macro to VBA Link Tables to External Data Sources Manage a Database Determine Object... Learn about: Office IT, Ms PowerPoint, Microsoft Office...
- Course
- Cardiff
- 2 Days
...This two day course is designed to provide delegates with the knowledge to manipulate Excel and gives developers greater opportunities to create rich desktop applications for end users. An improved programming model gives easier access to office functionality allowing for the delivery of powerful...
- Short course
- London
- 1 Day
...On completion of this course delegates will be able to: Automate workbooks with recorded macros. View and edit VBA code using the Visual Basic Editor. Create shortcuts to run macros. Create VBA code/macros from scratch. Create decision making code. Create Loops. Understand and Use data variables...
- Short course
- Londonand2 other venues
- New York, Amsterdam
- Beginner
- 1 Day
...The purpose of this one day workshop is to introduce participants to the VBA language which resides within Excel. No prior knowledge of programming is required and only a basic knowledge of Excel will be enough to maximise benefit from this session. In just one day participants will be... Learn about: Language and environment, VBA in Excel...
- Training
- Nottingham
- Advanced
- Different dates available
- 3 Days
...This 3 day course will provide you with skills necessary to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations... Learn about: Excel Programming, Visual Basic, Microsoft excel training...
- Training
- London
- Advanced
- 1 Day
...This course is the next step in exploring what Excel has to offer. The course is designed to introduce other features of Excel that will enable users to be more exploitative of Excel's abilities. Suitable for: If you have attended or understand the concepts covered at introductory and intermediate...
- Course
- Worthing
- 1 Day
... a Constraint 4). MACROS AND CUSTOM CONTROLS This is a basic introduction to Macros. Use of the Visual Basic Editor is covered in the Excel VBA course. WORKING...
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you