-
All
-
Online
-
Filters
-
Hampshire
-
Online
-
Type of studies
-
+ Filters
Excel Training in Hampshire
- Training
- Fareham
- Beginner
- 2 Days
... 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...
Similar training and in other locations
- Training
- Online
- Advanced
- 3 Days
...Visual Basic for Applications (VBA) is an object oriented programming language developed by Microsoft. VBA language has been integrated with Excel in order to have programming features which enables the developers to handle the data manipulation along with Excel function very easily. VBA is... Learn about: Microsoft excel training, MS Excel, Visual Basic...
- Training
- Online
- Advanced
- Different dates available
...The video tutorials in this course will show you how to automate Microsoft Excel tasks and operations. It is aimed particularly at Excel users, without much programming experience, who struggle to remember the syntax and structure of the VBA programming language. During the course, we will... Learn about: Excel VBA, Visual Basic, Next Loops...
- Training
- Online
- Advanced
- 1 Day
...This one day Microsoft Excel Advanced training course is for those with a sound working knowledge of Microsoft Excel. For those delegates who wish to progress to use the most complicated functions and features. At the end of this course you will investigated some of the higher functions... Learn about: Flash fill, Advanced pivot tables, Text Functions...
- Training
- Online
- Intermediate
- Different dates available
... and Graphs VBA (Visual Basic for Applications) basics – let’s get started Excel Shortcuts – for everyday use. Make yourself super-efficient and fast Tips... Learn about: Excel Files, Ms Office, Excel Formula...
- Training
- Online
- Different dates available
... do Google Earth para o AutoCad Civil 3D; Exportação de coordenadas do Civil 3D para o Excel; Importação automática de poligonal para o Civil 3D; Geração de curvas de nível dentro do Civil 3D através do Google Earth; Plotagem do LAYOUT. ALEM DO CONTEÚDO DESCRITO, DIVERSAS DICAS DO AUTOCAD CIVIL 3D. "... Learn about: AutoCAD training, AutoCAD Objects, AutoCAD 2D...
- Training
- Online
- Beginner
- Different dates available
...Excel VBA programming can seem baffling, especially when you don't fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations. This course is aimed particularly at Excel users without much programming experience... Learn about: Microsoft excel training, Object-oriented programming, Excel Formula...
- Training
- Online
- Intermediate
- Different dates available
...This course covers advanced options, features, formulas, graphs, computations in MS Excel and Google Sheets with a fair introduction to VBA programming... Learn about: MS Excel, Excel Files, Excel Sheet...
- Training
- Online
- Advanced
- Different dates available
...The ability to write, understand and maintain complex formulas is the key to mastering Excel. Complex formulas make use of multiple functions to achieve a specific operation; and it is the need to nest one function inside another that can sometimes make Excel formulas seem so impenetrable... Learn about: Optimizing Lookup, Excel Formulas, MS Excel...
- Training
- Online
- Intermediate
- Different dates available
...This is a practical, hands-on course for Excel middleweights looking to gain more confidence in using Microsoft Excel. It provides step-by-step practice in building Excel formulas with useful text functions like LEFT, RIGHT, MID, PROPER and CONCATENATE; conditional functions like IF, IFERROR, SUMIF... Learn about: MS Excel, Visual Basic 6, Microsoft excel training...
- Training
- Online
- Intermediate
- Different dates available
... calculations which only include those cells which match certain criteria. • And, naturally, no discussion of Excel functions would be complete without lookup functions. We discuss the use of VLOOKUP and, also, how the INDEX and MATCH functions can be used to lookup up data whose format makes the use of VLOOKUP... Learn about: VBA (Microsoft Access / Office), Excel Intermediate training, MS Excel...
- Training
- Online
- Advanced
- Different dates available
...This course follows on from where our Introduction to Word VBA Programming ends. This advanced Word VBA macro programming course is designed for users who are already comfortable with the basics of Word VBA macros, and who have progressed beyond relying on the Macro Recorder. If you are still... Learn about: Visual Basic 6, Microsoft Word, Ms Word...
- Training
- Online
- Beginner
- Different dates available
... your reasons for considering learning more about Word VBA macros, this course aims to equip you with everything you need to get started. This course was last updated on November 2015 with the addition of a module aimed at providing further practice by guiding the user, step-by-step, through... Learn about: VBA (Microsoft Access / Office), Ms Word, Word VBA training...
Similar training in other typologies
- Course
- Eastleigh
...You will then be qualified to progress to the VBA course for Excel. Candidates can be directed toward the European Computer Driving License Course... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...
- Course
- Southampton
...This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions... Learn about: Visual Basic training, Visual Basic, MS Excel...
- Course
- Southampton
...It is an introduction to procedural programming in VBA. Training allows you to gain a strong foundation for further learning and VBA environment. After the course you can: Record and edit the macro as required, Write procedures using data from the sheet, Create your own functions Handle the event... Learn about: MS Excel, Visual Basic training, Visual Basic...
- Course
- Southampton
...Adjustment of the working environment Hotkeys, facilities Create and modify toolbars Options excel (autosave, input, etc.). Options paste special... Learn about: Data analysis, Database Management, MS Excel...
"excel vba"
- Training
- Basingstoke
- 1 Day
...It also explores the use of more complex formulas in a business environment and includes techniques to simplify what could be complicated. We also investigate...
- Training
- Fareham
- Advanced
- 1 Day
...Enter Data Save a Workbook Obtain Help Modify a Worksheet Move and copy data between cells Fill cells with series of data Edit cell data Insert and delete cells... Learn about: Data editing techniques, Create a new spreadsheet, Edit and existing spreadsheet...
"excel vba"
- Training
- Fareham
- 2 Days
...although experienced programmers wishing to learn VBA will find it a quick and valuable introduction to the language. Throughout the course the theme...