Duration: 1-dayMaterials: 1600+ Page Manual Included
Advanced Excel On-Site Training Focus
|
Microsoft Excel VBA Essentials Onsite Training for Business |
Materials: 1600+ Page Manual Included
Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to automate common everyday Excel tasks and to construct automated data processing tools. VBA, a general purpose programming language, comes standard with Excel or Office. This workshop covers the fundamentals of using VBA programming and as well as how to apply it to common Excel and data processing tasks.
For a complete outline, click the Workshop Outline button below. You can also enroll in our public and webcast workshops from that page. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
What You Learn at a Glance
How to use the Visual Basic (VBA) Editor and its debugging tools
Excel macro language review (Subs, Functions, variables, arrays, loops, logic...etc)
How to streamline tasks in Microsoft Excel using VBA
How to use Microsoft Excel VBA to analyze and reconcile data on worksheets
How to use Excel visual basic (VBA) to perform calculations on data
How to create summary sheets (reconcile data) using VBA
How to create charts using VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
Beginning Microsoft Excel VBA Onsite Training for Business |
Materials: 1600+ Page Manual Included

Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to construct automated business tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using Microsoft Visual Basic with Excel, powerful business analysis tools can be developed quickly and with minimum cost. VBA can be used for business tasks like report generation, creating dashboards, communicating with business databases, analyzing business data, reconciling data, automating worksheet construction, business model calculations, creating charts, the list is endless. This workshop covers the fundamentals of using VBA programming and as well as how to apply it in real world situations.
For a complete outline, click the Workshop Outline button below. You can also enroll in our public and webcast workshops from that page. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
What You Learn at a Glance
How to use the Visual Basic (VBA) Editor and its debugging tools
Complete review of the VBA language (Subs, Functions, variables, arrays, loops, logic...etc)
How to command Microsoft Excel using VBA. Also discussed is how control Word and PowerPoint
How to use Microsoft Excel VBA to analyze data on single and multi worksheets
How to use Excel VBA to perform calculations on data
How to create summary sheets using VBA
How to create basic dashboards in Microsoft Excel using VBA
How to create and format single and multiple charts using VBA
Using VBA to create report generation tools in Microsoft Word and Microsoft PowerPoint using Excel VBA
How to use Excel VBA to build your own custom worksheet functions
How to use the Visual Basic Macro Recorder and interpret its recordings
How to download data from the web using VBA
How to automate the data analysis tool pack add-in using VBA
Advanced Microsoft Excel VBA Webcast (Webinar) Training for Business |
|
|
|
|
|
| Newsletter | Contact Us | Self-Study | Training Help |
Materials: 1600+ Page Manual Included
The capability exists within Microsoft Excel and VBA to construct complex dashboard driven analysis and data processing business tools. These business tools can go far beyond simple macros becoming actual applications. Excel has a vast array of automated features like graphics, ActiveX controls, worksheets, userforms and cell ranges that when combined together allow these dashboard driven programs to be created. When you tie other programs and computer languages to Excel through VBA like Word, PowerPoint, Access, SQL Server, Lotus Notes, C and VB .Net, Excel VBA can tap into these environments obtaining the functionality it does not have. This workshop focuses on using all of these elements to construct sophisticated data processing and analysis programs in Microsoft Excel.
For a complete outline, click the Workshop Outline button below. You can also enroll in our public and webcast workshops from that page. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
What You Learn at a Glance
An advanced review of the Excel VBA language
Advanced VBA data processing techniques for multi worksheets and multi workbooks
Advanced summary worksheet construction in Excel using Excel VBA
Advanced techniques for scanning Windows folders for workbooks and then opening them using VBA
How to read text files using VBA.
Advanced VBA programming techniques for creating multiple charts from multiple data sheets
How to create advanced business user interfaces on worksheets using ActiveX controls, VBA and graphics
Advanced excel dashboard construction
How to create and use userforms in VBA (wizards)
How to create event driven programs using VBA
Advanced VBA error protection techniques
How to create custom toolbars and menus to run your VBA code
How to communicate with databases using DAO and ADO in VBA and how to download data from the web using VBA
Advanced VBA techniques for communicating with other languages and programs
Microsoft Excel Onsite Training for Engineering / Science |
|||
Duration: 2-daysMaterials: 1600+ Page Manual Included
Beginning Excel VBA On-Site Training
Focus What is VBA? This workshop covers the fundamentals of using VBA programming in the engineering and science world. From loops, variables and logic to controlling Microsoft Excel, Microsoft Word and PowerPoint to data processing. It also covers automated engineering chart construction, beginning dashboard topics, system modeling, custom worksheet functions (UDF's) and numerical analysis approaches. For a complete outline, click the Workshop Outline button below. You can also enroll in our public and webcast workshops from that page. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
Duration: 3-daysMaterials: 1600+ Page Manual Included
Advanced Excel VBA
On-Site Training
Focus What is VBA? This workshop covers VBA topics like automated engineering chart construction for multi worksheets; advanced control techniques of other applications such as Microsoft Word and Microsoft PowerPoint; advanced engineering dash board construction using charts, pictures, ActiveX controls and drawing shapes; engineering wizard construction using userforms; advanced worksheet layout including navigation; advanced system modeling; team linking; database communication using ADO and DAO and communicating with other computer languages like FORTRAN. For a complete outline, click the Workshop Outline button below. You can also enroll in our public and webcast workshops from that page. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
Duration: 5-daysMaterials: 1600+ Page Manual Included
Excel Aided Engineering &
Science On-Site Training Focus This all in one Excel and Excel VBA onsite workshop covers basic engineering and science formula design on the worksheet to numerical techniques on the worksheet like linear systems, Runge Kutta, Newton's method, integration, differentiation and boundary value problems. It also covers complex number operations and advanced engineering and science charts. EAE also covers system modeling, design optimization using Solver and integrating engineering teams. Also reviewed is beginning and advanced VBA programming including userform design and how to integrate FORTRAN into your coding solutions. For a complete outline, click the Workshop Outline button below. You can also enroll in our public and webcast workshops from that page. Repeat this workshop for free as many times as you want. View offer details. Military and government discounts available, call us for details.
Additional Onsite Workshops for Engineering / Science |
|
Additional Pages Microsoft Excel Classes Microsoft Excel VBA Courses Microsoft Excel Training Microsoft Excel Macros Microsoft Excel VBA Consulting Microsoft Excel Add-Ins Copyright © 2002-2010 EMAGENIT All Rights Reserved |