Search:

» Home » Business » Applications » Complete Excel and VBA Course 1

Company:	OzGrid Business Applications
License:	Demo
Version:	1
System:	Win 3.x/95/98/ME/2000
Size:	185KB
Date Released:	February 6, 2003
Price:	$50.96
Screenshot:	No Screenshot
Downloads:	40
Homepage:	http://www.ozgrid.com/
Date added:	Sep 19, 2005
Click here to Download

Lesson 10 of Excel VBA has Time Saving Microsoft Excel Solutions. It is a downloadable book in Windows help file format that contains hundreds of solutions to Microsoft Excel problems. You do not need to purchase and it does not expire - it is freeware. Download and use whenever you have the time or need. It is a great way to improve your Excel skills and find time saving Excel solutions.

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!

EXCEL LEVELS 1,2 AND 3 OUTLINE

The Fundamentals of Excel, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function

Excel Fundamentals, Worksheet Formulas, Specific Worksheet Formulas, Extract Data and Decision Making, Data Validation and External References, Advanced Filters, AutoFilters, Names Charts, Under Utilised Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining

Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the WeB, Macros 1, Macros 2

VBA AND VBA USERFORMS 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.

NEWS

So far, nothing for that!

RECOMMENDED DOWNLOADS IN THIS CATEGORY

» Home » Business » Applications (2278)

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

» George the Window Cleaner`s Assistant 3.54

George the Window Cleaner`s Assistant is new, inexpensive software for the small to medium sized cleaning business. It controls your Work Schedule and Debts, produces finance histories and forecasts, it even backs up your data for you. ...

Co.uk | 0 | Win 95/NT/2000/XP/98/ME | $75 | Downloads: 34

Date added: Sep 19, 2005 | » Details

» Reallusion PresentPack 1.0

PresentPack is a series of Microsoft PowerPoint Templates. Each PresentPack pack includes 10 subtopics each with 3 different designs providing a total of 30 templates in all. Each PowerPoint Template is a professionally designed including graphics, font a ...

Reallusion Inc. | 312KB | Win 95/98/ME/2000/XP | $29.95 | Downloads: 25

Date added: Sep 20, 2005 | » Details

» EarthTime 1.4.2

EarthTime displays the local time and date of any place in the world. It has a built-in database of more than 3000 cities worldwide but users can add any number of custom locations. Alarms can be set on the local time of any city in the world. Many option ...

DeskSoft | 460KB | Win 95/98/ME/NT/2000/XP | $10.00 | Downloads: 45

Date added: Sep 19, 2005 | » Details

» ZoneTick - Single User Edition - English 2

ZoneTick is an enterprise-class solution that replaces Windows` system clock with a customizable amount of time zone clocks, utilizing custom prefixes, tool-tips and actions on double-click for each timezone. The program also offers customizable skins, al ...

Wrconsulting.com | 0 | Win 95/2000/XP/98/ME | $14.99 | Downloads: 20

Date added: Sep 19, 2005 | » Details

» Atomic Time Zone Server with 50 Client Licenses 5

Atomic Time Zone Server Edition keeps your computers clock Atomically Correct and operates Atomic Clock Time Servers. This is done via the internet using Atomic Clocks, the worlds most accurate time pieces. If you`re interested in accurate time accross yo ...

Amo.net | 0 | Win 95/NT/2000/XP/98/ME | $149.95 | Downloads: 27

Date added: Sep 19, 2005 | » Details

» SpamBurner - Business License (50-99 copies) v1.64

SpamBurner is more than a spam filtering tool, it is also a great e-mail reader, which can help protect you from e-mail based viruses as well (as it allows viewing of messages in text form, even if the message has complex HTML and Javascript coding! ...

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

Date added: Sep 19, 2005 | » Details

» Blog Auto Machine 2.0

Automated blog and ping software Finally, A Desktop Tool That Automates The Entire `Blog & Ping` Process And Gets Your Web Pages Crawled, Indexed and Even Ranked in Less Than One Week. B.A.M.`s PATENT PENDING TECHNOLOGY TAKES AUTOMATED BLOG AND PING TO ...

Blog Auto Machine | 2102KB | Win 98/ME/2000/XP | $297 | Downloads: 41

Date added: Sep 20, 2005 | » Details

» TmPop3 Server Unlimited User License

TM-POP3 Server delivers your e-mail fast and fully integrates with Microsoft SMTP server for Windows NT/2000/XP. Supports multiple user mailboxes, multiple domains, e-mail aliases, distribution lists, remote administration, logging, and security controls. ...

Tmsoft.com | 0 | | $99.95 | Downloads: 32

Date added: Sep 20, 2005 | » Details

» XL Navigator 1.1

XL Navigator is an add-in that allows you to quickly and comfortably navigate and administer Workbooks, Spreadsheets, Names and Links of Microsoft Excel. XL Navigator shows all opened Excel workbooks as a thoroughly organized catalogue that allows you t ...

Afalina Co., Ltd. | 895KB | Win 95/98/ME/NT/2000/XP | $19.95 | Downloads: 43

Date added: Sep 19, 2005 | » Details

» Ability Write Education 2002

Ability Write contains all the features you would expect a good word processor to have: spell checker and thesaurus, bulleted and numbered lists, a wide range of file formats for export and import, headers and footers, numerous paragraph and font options, ...

Ability.com | 0 | Win 95/NT/2000/XP/98/ME | $16.98 | Downloads: 34

Date added: Sep 20, 2005 | » Details

» Belltech Label Maker With Data Merge 2.0

Belltech Label Maker With Data Merge, a feature rich professional quality business printing software to print address labels, letterheads, flyers, postcards, business cards, envelopes, brochures and more from your database files. It comes with many desi ...

Belltech Systems | 5841KB | Win 98/ME/NT/2000/XP | $49.00 | Downloads: 30

Date added: Sep 20, 2005 | » Details

» Teach Light Ã® 1.3.7

Dynamically reconfigurable under any language of the world (roman, cyrillic, arabic) multipurpose teaching a program shell (foreign languages, psychology and analytics). Algorithms of subsensory, virtual and audiovisual modes of teaching. Application of e ...

Ukrtel.net | 0 | Win 3.1/95/NT/2000/XP/98/ME | $49.95 | Downloads: 15

Date added: Sep 20, 2005 | » Details

» MonitApp - 20 1

With MonitApp you can have an Excel file, always, updated with a list of the application installed in you remote computer. If you put it running as a scheduled task it generates automatically: a sheet wit applications installed by machine and another she ...

Serprest.pt | 0 | Win NT/2000/XP | $179 | Downloads: 34

Date added: Sep 19, 2005 | » Details

» EasyConvertor Currency Convertor 1.0

Converting currencies without retyping, just select the amount to convert and hit CTRL+C! ...

Easyconvertor.com | 0 | Win 95/98/ME | E15 | Downloads: 38

Date added: Sep 19, 2005 | » Details

» CyberCafePro Client 4.1

CyberCafePro Version 4 offers Internet Cafe, Cyber Cafe, and Gaming Cafes a host of new features. Security, Pricing, Timing, POS, Chat and much more... Easy install & setup - CCP operates on standard peer-to-peer networks including Wireless LANs (On any W ...

Celco Software Ltd. | 4882KB | Win 98/ME/NT/2000/XP | $$199 & up | Downloads: 47

Date added: Sep 20, 2005 | » Details

» Print Studio 2E

A complete office solution for all your labeling and printing needs (label, bar code, photo id badge with magnetic stripe, envelope, CD label, and more). Print Studio provides a wide variety of powerful, yet easy to use tools (such as shapes, gradient, ar ...

Jolly Technologies | 15625KB | Win 98/ME/NT/2000/XP | $289.99 | Downloads: 54

Date added: Sep 20, 2005 | » Details

» HiClock Pro Corporative 2.9.21

HiClock gives you an easy, thorough way to synchronize your system clock to the exact time using the Internet. This program queries the timeservers of the National Institute of Standards and Technology, which return the correct standard time directly to y ...

Kgsoft.com | 0 | Win 95/NT/2000/XP/98/ME | $150 | Downloads: 28

Date added: Sep 19, 2005 | » Details

» ESBCalc Pro 4.6

ESBCalc Pro is a Enhanced Win32 Scientific Calculator with Infix Processing, Exponential Notation, Brackets, Scientific Functions, Memory, Optional Paper Trail, Printing, Result History List, Integrated Help and more. Functions include Trigonometric, Hype ...

Esbconsult.com | 0 | Win 95/NT/XP/98/ME | E16 | Downloads: 36

Date added: Sep 20, 2005 | » Details

» Easy Directory 2.3

Easy Directory is a program for managing addresses. The program arranges entries in an alphabetical order. Each entry consists of a full name, an address, a home phone number, a home fax number, mobile phone number, work phone number, web site (URL addres ...

de Willebois Consulting | 798KB | Win 95/98/ME/NT/2000/XP | $17 | Downloads: 26

Date added: Sep 20, 2005 | » Details

» EstiMaker PalmOS 1.1a

EstiMaker is designed to help electrical professionals with the estimating/bidding process, letting an estimator create a take-off estimate in, generally, at least a third of the usual time. Includes database of over 4600 electrical parts, with pricing ...

Arkansoft | 1582KB | Win 3.x/95/98/ME/NT/2000/XP | $24.95 | Downloads: 26

Date added: Sep 20, 2005 | » Details

go to top

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