Category Archives: Spreadsheets

14Dec/14

Excel Level 3 and Excel VBA Courses

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. Each lesson is drawn from ‘real world’ experience and not made up class room scenarios. There are 20 lessons, each between 5 and 10 Word Document pages long, and 10 Workbook examples. There is also online Microsoft Pivot Table tutorial.

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 LEVEL 3 OUTLINE:

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

EXCEL VBA 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.

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!

Purchase the full version for unlimited use

14Dec/14
dave-hawley-password-for-ozgrid-custom-functions-add-in-logo.gif

Password For Ozgrid Custom Functions Add-in

Password For Ozgrid Custom Functions Add-in

After you install the add-in, you will have new Category in Excel’s Native “Insert Function” dialog box. Most Custom Functions are grouped together. That is, Function preceded with L_ means it’s a Lookup Function. D_ means Date Function, B_ means Boolean (TRUE/FALSE) Function, C_ means Color Function, S_ means String (Text) Function. PRE200* means the lowest version the custom function will work on.

Try Password For Ozgrid Custom Functions Add-in
Purchase the full version for unlimited use

14Dec/14

Time Sheet Advanced Upgrade to Open Source

With this version the password for the Worksheets and the VBA code is supplied. This extremely easy and simple to use Excel Time Sheet will keep track of your employees hours. It allows you to specify and set unpaid breaks in 5 minute intervals on a daily and employee basis. If your employees work hours that span into a new day, no problem, the time calculations will accommodate this. All Start and End times span a 24 hours period in 15 minute intervals, all you do is select a Start time and End time from a drop down list. This makes it impossible to enter times that Excel wont recognize.

The Time Sheet can incorporate up to a 12 week period with any week and/or day being optional. All you do is enter your employee names once, save as a Template and you are set.

1Enter your employee names in the cells below Employee Name. The same names will automatically flow through to Weeks 2 to 12.

2 Select the starting date from directly below Week 1 Includes. 7 day periods will automatically flow through to Weeks 2 to 12.

3 If any weeks are not needed, simply ignore them and do not enter any times on them. You can hide these Sheets via Format>Sheet>Hide. If one the period only includes part one Week, simply do not fill in times for those other dates. For example, if you wish to cover an entire month, simply select the starting date from directly below Week 1 Includes and then only fill out times that include the same month on Week5.

4 Once you have done this, go to File>Save As and Save as a Template into the path that Excel defaults to. Next period, simply pull up the Time-Sheet Template again.

The Totals sheet has a very easy to use Pivot Table which is based off all employees and their hours. You can simply specify to display results by Week and/or by Name or show All Names and/or All Weeks. Double clicking on any hours within the Total Hours field will give you a Break Down of the displayed data.

Purchase the full version for unlimited use

14Dec/14
dave-hawley-excel-2007-level-2-training-logo.gif

Excel 2007 Level 2 Training

Excel 2007 Level 2 Training

These lessons have been written by OzGrid Business Applications who develop Excel spreadsheets on a professional basis. Each lesson is drawn from ‘real world’ experience and not made up class room scenarios. There are 10 lessons, each between 5 and 10 Word Document pages long, and 5 Workbook examples.

BASIC COURSE OUTLINE:

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.

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!

Purchase the full version for unlimited use

14Dec/14
dave-hawley-ozgrid-excel-addins-collection-logo.gif

OzGrid excel Addins Collection

OzGrid excel Addins Collection

The OzGrid Add-ins Collection contains all 8 of our Excel Add-ins. We have bundled these together to offer them at a greater than 50% discount! $79.95

The Add-ins in the Collections are:

1. Duplication Manager. Normally $29.95
2. Formula Manager. Normally $29.95
3. Text Manager. Normally $29.95
4. Number Manager $29.95
5. Name Manager $29.95
5. Sheet Index Formula Reference Changer. Normally $24.95
6. OzGrid Excel Plus.Normally $29.95
7. Workbook Size Reducer. FREE

TOTAL COST NORMALLY = $203.95
BUY AS COLLECTION = $79.95
YOU SAVE = $124.00 OVER 50%

* 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.

Purchase the full version for unlimited use

14Dec/14
dave-hawley-forms-combobox-wizard-add-in-logo.gif

Forms ComboBox Wizard Add-in

Forms ComboBox Wizard Add-in

If you often work in Excel with ComboBoxes from the Forms toolbar this Excel add-in can save you many hours and prevent errors.

After selecting a range of cells, contiguous or non-contiguous, you can add x number of ComboBoxes to the Worksheet in just a few clicks. All Cell Links, Names, Input Ranges and much more can be set en mass.

All ComboBoxes are added to the cells you have selected at the time of running the ComboBox Wizard. All your selected cells are shown in the All “ComboBoxes will be added to selected cell(s)” box.

You can use non-contiguous cells simply by holding down the Ctrl key (before launching the Combo Wiz) and select ranges like A1:A10, C5:C30, D5, G6:G12

The default size for all ComboBoxes added via the wizard is the same as that of the cell housing it. Clicking the “Specify Size” button will force a specified size for all ComboBoxes.

After clicking the “Specify Size” you can uncheck the “Make Same Size As Cell Housing it” Checkbox and use the “Width” and “Height” Spinbuttons to specify a size. The Preview shows you the size that will be applied.

You can also delete all specified comboboxes on the current sheet in just a few clicks. The ComboBox Wizard does all the above and more.

It also comes with a 30 Day Money Back Guarantee and a BIG discount for an Unlimited License Version.

Purchase the full version for unlimited use