-
All
-
Online
-
Filters
-
Location
-
Online
-
Type of studies
-
+ Filters
Excel vba courses
- Course
- Online
- Intermediate
- Different dates available
- 12 Months
... level so you can transform everyday spreadsheets into elegant and powerful business assets. In this Excel 2010: Advanced series, new and longtime Excel users will learn how to take core skills to the next level by exploring advanced functions and chart features, connecting to external data, utilizing... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...
- Course
- London
- Different dates available
...This course covers the table and chart construction features of Microsoft Excel. By presentation and demonstration. The learners will have access to computers for practicing... Learn about: MS Excel...
- Course
- Online
- Beginner
... : what you need to know Large sets of data maintenance: tailoring your approach to maximise impact Mastering Creating Effective Spreadsheets Create Dynamic Report with Excel PivotTables Auditing Excel Worksheet Formulas... Learn about: Microsoft excel training, MS Excel, Microsoft Office...
- Training
- Online
- Advanced
- 1 Day
... of Microsoft Excel... Learn about: Goal seek, Data tables, Advanced pivot tables...
- 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...
- Course
- Online
..., or with a simple copy and paste of your new data into your spreadsheet. TARGET AUDIENCE Anyone with an advanced knowledge of Excel who wants to learn how to create dashboards which will enhance their spreadsheets with easily understood and interactive data displays. Excel Dashboards provide insight, analysis... Learn about: MS Excel, Microsoft Excel, Microsoft excel training...
- 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...
- Training
- London
- Intermediate
- Different dates available
- 2 Days
...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: MS Excel, Adding Data Bars, Microsoft Office...
- Course
- Online
- Different dates available
...In session of this course you will learn:What are the arrays in VBA? Why we use them? Why they are so powerful and holds so much weightage in VBA learning. Deep level discussion on Arrays from very basic level to super advanced levels using examples What is their by-default index system and... Learn about: MS Excel...
- Course
- London
- Advanced
- 2 Days
... - pivots, formulas automation -macros, record, run, relative & absolute, assign to buttons, customise toolbars, edit vba code workbook templates -new default...
- Short course
- Cambridge
- Advanced
- 2 Days
...; structure data efficiently in order to create Dashboards; use advanced charting techniques to visualise data and create interactive dashboards; understand the use of basic macros/VBA for automation. Target Audience Designed for users who need to interpret and communicate large quantities of information... Learn about: MS Excel, Microsoft Office, Microsoft Excel...
- Course
- Edinburgh
- 2 Days
... will write several applications to ensure that the concepts and statements taught are fully. Suitable for: This course introduces the Visual Basic For Applications Language. This is a subset of the VB language itself and is used in the Microsoft Office products. This course can be chosen for Word, Excel...
- Course
- Online
- Advanced
- Different dates available
- 1 Year
...At work, are you required to use the Microsoft Office 2016 suite, including Word, Excel, PowerPoint, Access, and Outlook? If so, then why not master both the basic and advanced features of these in order to fully benefit your career. Whether you’re a Microsoft Office 2016 beginner or otherwise... Learn about: Database training, MS Excel, Ms Word...
- Course
- Southwark
- 1 Day
...Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code...
- Course
- Worthing
- 2 Days
... Excel Constants Variable Constants Excel Objects Objects, Properties and Methods Getting & Setting Properties Calling Methods Passing Arguments Singular...
- Course
- London-cityand2 other venues
- Birmingham, Reading
... and Advance courses. Learning Objectives This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of tools and concepts for Excel 2007, 2010 and 2013 in order to further increase their knowledge and productivity... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...
- Short course
- Washington
- 1 Day
...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...
- Training
- London
- Intermediate
- Different dates available
- 2 Days
...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. This course delves deeper into the Excel object model and provides delegates with practical experience of developing their own VBA... Learn about: Dialogue boxes, Cut Copy, Alerts property...
- Course
- Online
- Different dates available
... files and then do the things like compiling data from them or modifying the files or moving them or deleting them. Learn how to use the file-dialogs so that user can choose any folder of his or her choice and work accordingly. Not just folders or Excel files -we are also going to see what to... Learn about: MS Excel...