Excel macros & vba courses

...Using a step-by-step approach, this course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. Students learn to write macros to accept user input, read to and write from cells and manipulate data. They also learn to write custom functions... Learn about: Basic IT training, Visual Basic, MS Excel...

...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: MS Excel, Microsoft excel training, Microsoft Excel...

... Word and Excel. An Overview of Macros & Modules Explaining the differences and benefits of Macros and VBA Modules. Creating macros to assist users... Learn about: Microsoft Access VBA Training, Microsoft Access VBA course, Microsoft Access...

...Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code...

...This Microsoft Access VBA training course will teach you how to manipulate your Access database using VBA (Visual Basic for Applications) code, automating the database. Access VBA extends the features of the database, providing you with the full power of Visual Basic programming to manipulate... Learn about: Ms Word, Database training, Microsoft Access...

...This course has been specially designed for the advanced user who wants to make use of the more powerful facilities of Microsoft Excel made available by VBA. This course explores VBA language and delegates will be encouraged to write programs to ensure that future editing, amending and updating...

...This VBA for Excel Training course is designed to give a good working knowledge of Visual Basic for Applications concentrating on Microsoft Excel. Delegates should have attended the Advanced Excel Course and have a good understanding of Excel functions and Templates. The Visual Basic...

...This course is designed for the Power Excel user who wants to use his Excel spreadsheets as applications in their own right. It introduces VBA programming and custom forms...

...If you already know how to program in Access, Excel or Word VBA, maybe it is time to learn about some of the more advanced features of the language. Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean! Suitable for: This Advanced... Learn about: Passing arguments, Revision of VBA, Linking to data...

...This course is designed for the Power Excel user who wants to use his Excel spreadsheets as applications in their own right. It introduces VBA programming and custom forms...

...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: Visual Basic explained, Case Studies, The VBA code editor...

...This course looks at setting databases up for other people to use. You will learn how to automate the flow of your database using a start up screen (or Switchboard), and learn how to use macros in Access. Please note that macros are not...

...This course looks at setting databases up for other people to use. You will learn how to automate the flow of your database using a start up screen (or Switchboard), and learn how to use macros in Access. Please note that macros are not...

...This course has been designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access...

...This course has been designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access...

...Many Excel tasks become tedious and repetitive. To create macros will automate these repeated actions and saves you the time of doing it. You will learn to record Excel macros, create macros in Excel by coding in Excel VBA. The we add the macros to icons on a custom toolbar, and... Learn about: Microsoft Excel, MS Excel, Excel VBA...

...Instructor-led, Online. Many Excel tasks become tedious and repetitive. To create macros will automate these repeated actions and saves you the time of doing it. You will learn to record Excel macros, create macros in Excel by coding in Excel VBA. The we add the macros to icons on a custom toolbar... Learn about: MS Excel, Microsoft Excel, Excel VBA...

... custom functions Analyze how your code operates and locate the source of errors Write procedures that test conditions and then run only certain statements based on the results. Suitable for: This is an introduction to VBA programming. It will be useful for students to understand Excel as a user before...

...This intensive, hands-on one-day course has been designed for people who wish to learn the basics of the Excel VBA programming language, get used to the concepts and methods of VBA programming, and understand (and use) the relevant techniques... Learn about: Microsoft Excel, Excel Sheet, Microsoft excel training...

...This course will give students the ability to create advanced spreadsheets using the full range of Microsoft Excel 2003's tools and features. Suitable for: The course is intended for existing users of Microsoft Excel 2003 or XP who want to use the more advanced features of the software in order... Learn about: Microsoft excel training, MS Excel, Microsoft Excel...