
A-PDF Preview and Rename
DOWNLOAD TRIAL
PURCHASE ORDER
Models for all of your need from Top Brands like Monster,Soul and many more. Get special price here
There are various model and type that you can adjust them. Special discount only this week
Chic label and style inspiration. Just special day with them. Get special discount here
Get special discount for limited motorcycle accesories on current day with special adjustment
CURRENT SPECIAL Was $75.00 Now $39.95
These lessons have been written by OzGrid Business Applications, who develop Excel spreadsheets on a professional basis. All information within these lessons are drawn from 'real world' experience and not fictitious class room scenarios. There are five Workbook examples with the 20 lessons. Each lessson is between 5 and 10 Word Document pages long. There are also 10 Excel Workbook Examples.
Lesson 10 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!
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!
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.
* 1 User License allows installation of the software on 2 Computers only.
* Unlimited license allows installation of the software on an unlimited number of Computers, and/or Networks. Ideal and VERY cost effective for corporate environments!
* Resellers License allows you do what ever you like with the software, re-brand and re-sell. No Restrictions At All! Email the support email given immdediantly after purchase for passwords.
In order to ease the analysis of specific data in your spreadsheet, you might give it a special format (for example: highlighting it), using one of the most useful tool that Microsoft Excel has, "Conditional Formatting", but the bad thing is that it just supports until 3 conditional levels. Well, Jabsoft, thinking of this lack, has created: Conditional Formatting for Excel , an excellent addin, which allows you formatting all the cells and ranges that you need, using "n" conditions (in other words, all of conditions you desire)
This is essentially useful for who work with large quantities of info and/or dynamic data; like for example: stock quotes reports. Imagine, you are working with Jabsoft's product: Stock Quotes for Excel and Conditional Formatting for Excel . You might to know quickly, the Last quotes in your spreadsheets configuring the Stock Quotes addin updates the information every 30 minutes, and the Excel Conditional Formatting will paint with determinate color, all of the Last quotes.
In this new version 2.2.0 of Conditional Formatting for Excel:
Conditional Formatting for Excel is a part of Model Builder for Excel , whereby, if you purchase this product you can upgrade to it paying only the difference.