Search:

» Home » Business » Applications » Excel VBA and Excel UserForms Training 1 FREE DOWNLOAD

Your download will start in 3 seconds... If not, try the following links:
Download Link 1 Report broken link

No special software is needed to use - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches!

BASIC COURSE OUTLINE:
The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects , Object Hierarchy, Application, Workbook, Worksheet, Range, CommandBars, Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls, Effective Decision Making, If/And/Or, Select Case, Dates and Times, Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, Runtime Errors, Excel WorksheetFunctions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent.

UserForms Introduction, Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control, Filling a ListBox and/or ComboBox using Loops, Multi-Page Control, Creating a wizard using the Multi-Page Control, Validating the User Inputs, Some Useful Methods and Functions, When to apply Validation, Control Events, Which Controls to use and When, Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls, Option Buttons and Checkboxes in Detail, True or False, Creating Template Controls, Using the RefEdit Control, Finding the Active Control, Creating Controls at Runtime.

WHY USE US FOR EXCEL TRAINING?
Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! Over time we have focused our business directly towards Excel. Other training companies will offer training in many different Applications, and while they may supply information from good trainers it is very unlikely the trainers will know Excel to the extent we do! Remember we develop Excel spreadsheets in our day-to-day business so we know what you will encounter in your day-to-day use of Excel. We are not just Excel teachers, but also Excel developers!

RECOMMENDED DOWNLOADS IN THIS CATEGORY

» Home » Business » Applications (2278)

Select page: [1] 2 3 4 5 6...

» Imanami SmartR 1

Empower your administrators with SmartR, a simple reporting tool that allows administrators to view or print accurate reports on objects within your directory or GAL. Out-of-the-box SmartR contains canned reports every administrator cannot live without. S ...

Imanami Corporation | 3500KB | Win 2000/XP | 0 | Downloads: 43

Date added: Sep 20, 2005 | » Details

» Belltech Business Cards Designer Pro 1.2

Belltech Business Cards Designer Pro helps you create amazing business cards in a matter of minutes and print them right-away on any Windows compatible printer. It is a professional quality business card designing and printing software. Product Highlight ...

Belltechsystems.com | 0 | Win NT/2000/XP/98/ME | $29.95 | Downloads: 21

Date added: Sep 20, 2005 | » Details

» DOCUMENT MASTER [Scheme 3] 6.0

Document Master provides a totally integrated workflow, document management, and image editing techniques in a single compact package. The software essentially targets 4 aspects of Document Management:- Scanning and storing documents in a Single Databa ...

Psdcplus.com | 0 | Win 95/NT/2000/XP/98/ME | $120 | Downloads: 20

Date added: Sep 19, 2005 | » Details

» Fax UserControl for WinFax/TalkWorks 1.5

Do you run a small business with WinFax? Perhaps you have more than one business, or want to send personal faxes without your business name on them. Do you have more than one family member that uses your PC to send faxes? Do you often find yourself changi ...

GetFaxing.com | 4140KB | Windows 95/98/NT/2000 | $19.95 | Downloads: 23

Date added: Sep 20, 2005 | » Details

» ZIP Maxima 1

ZIP MAXIMA 1.0 allows you to locate all the existing ZIP Codes within a specific radius area in the US. Just enter the ZIP Code and radius area number (e.g. 30 miles/kilometers), and this application will provide you a complete list of the ZIP Codes and C ...

SharewareLab.com | 10742KB | Win 98/ME/NT/2000/XP | $18.99 | Downloads: 57

Date added: Sep 20, 2005 | » Details

» PawCalc

PawCalc is a scientific calculator for PalmOS 2 and later. The main features are: * Expression-based notation. * Programmable. * Built-in mathematical, physical, and chemical constants. * Conversion between more than a hundred different units. * Function ...

Paweng.com | 0 | Palm OS | $20 | Downloads: 86

Date added: Sep 19, 2005 | » Details

» MindChart 2.3

MIND MAPPING done by MindChart`, involves writing down a central idea and thinking up new and related ideas, which radiate out from the center. By focusing on key ideas written in your own words, and then looking for branches out and connections between t ...

Avant4u Inc. | 5527KB | Win 95/98/ME/NT/2000/XP | $44.00 | Downloads: 32

Date added: Sep 20, 2005 | » Details

» GsLantern EASY! Unlimited 2

GsLantern EASY! helps to distribute documents in standard formats compatible to any computer system, and the internet. It reduces the danger to distribute computer viruses or hidden information unintentionally. GsLantern EASY! transfers Windows and MS Off ...

Gslantern.com | 0 | | $339.8 | Downloads: 24

Date added: Sep 19, 2005 | » Details

» Personnel Organizer Pro 1.3

Personnel Organizer Pro is a flexible personnel management software for Windows users. Our software solution gives you an easy way to gather, organize and manage information about all employees in your company or organization. For the database novice, Org ...

PrimaSoft PC | 8000KB | Win 95/98/ME/NT/2000/XP | $195 | Downloads: 27

Date added: Sep 19, 2005 | » Details

» FCP Office Link 3.1.0 ML

FCP Office Link. is an unique and complete software solution for downloading, formatting and distributing the reports generated by any enterprise or ERP software, integrating them with Microsoft Word, Microsoft Outlook, Microsoft WinFax and Lotus Notes pr ...

Fcpconsulting.com | 0 | Win 95/NT/2000/XP/98/ME | E350 | Downloads: 24

Date added: Sep 19, 2005 | » Details

» SmartFax 2002 - Try&Buy 6.00.71.7

SmartFax 2002 is an easy-to-use and powerful fax software package that turns your PC into a complete fax messaging system. Advanced faxing and messaging capabilities make SmartFax the perfect companion for both mobile and stationary PC users. ...

Element5.com | 0 | Win 95/NT/2000/XP/98/ME | $79.95 | Downloads: 24

Date added: Sep 19, 2005 | » Details

» Job Seek Manager 2.1

Job Seek Manager was designed to help you manage jobs applications. The process is very simple you select a job from the Web and copy and paste data into this software. After you have stored job details you can track, sort and filter it by any data fields ...

Z5Com Pty Ltd | 65KB | Win 98/ME/NT/2000/XP | 0 | Downloads: 27

Date added: Sep 20, 2005 | » Details

» Akeni Messenger Jabber Edition For Linux 0.9

Akeni Messenger Jabber Edition is a cross-platform instant messenger client for Jabber/XMPP compliant servers. Akeni Messenger Jabber Edition includes features such as XML-based messaging protocol, private chat, conference, broadcast messages to gro ...

Akeni.com | 0 | Unix / Linux | $18.95 | Downloads: 20

Date added: Sep 19, 2005 | » Details

» ProCetus Academic Edition 2

ProCetus is a general purpose 3D FEA (Finite Element Analysis) Structural Design, Analysis and Optimization application software. ProCetus will handle the vast majority of your Structural Civil Engineering Projects in an easy, fast and very competit ...

Procetus.com | 0 | Win 95/NT/2000/XP/98/ME | $3497 | Downloads: 31

Date added: Sep 20, 2005 | » Details

» Calendar+ 2000 Pro 5 user license CD 3.02

...

Jsoftconsulting.com | 0 | Win 95/NT/2000/98/ME | $224.75 | Downloads: 22

Date added: Sep 19, 2005 | » Details

» MITCalc - Roller Chains Calculation 1.12

The calculation is designed for a geometrical design and strength check of common chain transmissions using roller chains. Application is developed in MS Excel, is multi-language, supports Imperial and Metric units and solves the following tasks: - Sele ...

MITCalc | 1397KB | Win 95/98/ME/NT/2000/XP | $14 | Downloads: 27

Date added: Sep 20, 2005 | » Details

» 4TOPS Compare Excel Files

4TOPS Compare Excel Files is an easy to use program that clearly reports where and what the differences between two Excel workbooks are. features: - Easy to interpret reports using HTML; - Differences in the Analysis report and Visualization reports are h ...

AGORA Software BV | 1891Kb | Windows 95/98/Windows Millenium/Windows 2000/Windows XP/Windows 2003 | 59 | Downloads: 16

Date added: May 04, 2006 | » Details

» BCW Finanzplaner 1.0

Do you edit your Finanzmovie in this Program, then controlling this your Dates and give a Output for control, have you to many bills for your Depts, then show you the Finanzplaner this, in his Calculations. This Program can be a important Tool for every B ...

Freenet.de | 0 | | E10 | Downloads: 35

Date added: Sep 19, 2005 | » Details

» Ampelkonto 2.0 (11 - 20 Mitarbeiter) 2

Flexitime is handy Â¬ and is hence gaining currency. However, many companies working flexitime have to cope with overflowing working time accounts Â¬ resulting in payments of expensive over-time. Additionally it is still very common to use simple charts f ...

Ximes.com | 0 | Win 95/NT/2000/XP/98/ME | E299 | Downloads: 28

Date added: Sep 19, 2005 | » Details

» PeddleGold 3.2

PeddleGold :: Host anywhere. Credit card ready. Instantly turn your web site into a storefront with PeddleGold. Create a table of products; add it to your web site with the PeddleGold container and you have a feature rich on-line store. Supports select ...

ImagineNation Inc | 116KB | Win 3.x/95/98/ME/NT/2000 | $9.95 | Downloads: 34

Date added: Sep 20, 2005 | » Details

go to top

Select page: [1] 2 3 4 5 6...