Vb Courses for Sunderland

The Advanced After Effects Course is a great next step if you have already attended the beginners After Effects course and want to learn the more advanced features for producing motion graphics and visual effects. You will go through topics such as masking, keyframes, shapes, path animation, working with effects, 3D, tracking plus lots more.

This 2 day Instructor led Advanced After Effects Class runs at our York Centres and can also be held as a closed course at your preferred location for a team of people.

This 2 day live course covers all of the basic skills needed to start using Adobe After Effects properly.

During the course you will learn to work with layers in After Effects, understand keyframing, control animations, work transparency, and better understand rendering and output.

By the end of the class you will be able to competently edit your video content using After Effects and applying best practice techniques taught by an Adobe Certified Instructor.

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.

Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.

This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.

This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.

This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.

This course is designed to help experienced Word users automate common tasks and create end user systems. The user does not have to be a programmer to benefit from this course but any programming experience will be of value

This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.

We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.

It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.

For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.

Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.