| Dave Hawley software list |
1.
Excel Level 3 & Excel VBA & Excel UserForm Courses - Business & Finance-Spreadsheets
24/Jan/2003
Reviewer:
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 30 lessons, each between 5 and 10 Word Document pages long, and 15 Workbook examples.
|
|
2.
Excel Duplication Manager Add-in - Business & Finance-Spreadsheets
21/Aug/2002
Reviewer:
Manage duplicate data in your Workbook with ease.
|
|
3.
Text Manager - Business & Finance-Spreadsheets
21/Apr/2003
Reviewer:
Text Manager is a productivity Add-in for working with text in Microsoft Excel. It allows you to easily make modifications to the text of existing cells, range or entire worksheet. Changing the text from a range of cells to a different case, removing specific special characters (or multiple characters) and trimming the cells can all be carried out very effectively and easily. This Add-in also allows you to concatenate several cells together and add spaces for the text of the cells. This is a must have Add-in if your daily tasks involve working with text in Excel. It will definitely save you many hours of tedious work.
|
|
4.
OzGrid excel Addins Collection - Business & Finance-Spreadsheets
26/Aug/2002
Reviewer:
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
|
|
5.
Complete Excel Course - Business & Finance-Spreadsheets
24/Jan/2003
Reviewer:
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.
|
|
6.
Excel VBA Level 1 and Excel UserForms - Business & Finance-Spreadsheets
14/Oct/2002
Reviewer:
Excel VBA Training Level 1 and Excel UserForms and Controls
|
|
7.
Time Sheet Advanced Open Source - Business & Finance-Spreadsheets
05/Oct/2004
Reviewer:
Time Sheet Advanced Open Source is an esay-to-use Excel Time Sheet that can keep track of your employees hours.It is very useful for people who are engaged in business & fancial oppucation. This version is perfected with the password for the Worksheets and the VBA code. With this version, you can specify and set unpaid breaks in 5 minutes intervals on a daily and employee basis. If your employees work hours that span into a new day, the time calulations will accommodate it.
|
|
8.
Number Manager - Business & Finance-Spreadsheets
28/Apr/2003
Reviewer:
Easily work with numbers in Excel
|
|
9.
Excel Level 1, 2 and 3 Training - Business & Finance-Spreadsheets
14/Oct/2002
Reviewer:
Excel levels Basic to Advanced Training
|
|
10.
Forms ComboBox Wizard Add-in - Business & Finance-Spreadsheets
23/Nov/2004
Reviewer:
Forms ComboBox Wizard Add-in
|
|
11.
Excel Download Package - Business & Finance-Spreadsheets
08/Jan/2003
Reviewer:
Over 33 Excel & VBA Workbook Examples
|
|
12.
Formula Manager - Business & Finance-Spreadsheets
16/Apr/2003
Reviewer:
Easily manage formulas in Excel
|
|
13.
OzGrid Excel Plus Add-in - Business & Finance-Spreadsheets
21/Aug/2002
Reviewer:
Formula Report Generator,Dynamic Range Namer,Real Calendar,Sheet Creator and Sorter,A Random Number Generator,Conditional Row Deletion,
Duplication Report and Do On Time bundle together isOzGrid Excel Plus Add-in.
|
|
14.
Name-Manager - Business & Finance-Spreadsheets
20/Sep/2004
Reviewer:
Manage Excel Named Ranges
|
|
15.
TimeAndWageBook - Business & Finance-Spreadsheets
23/Sep/2002
Reviewer:
Calculate employee time and wages in an Excel Workbook
|
|
16.
Excel VBA Level 1 Lessons - Business & Finance-Spreadsheets
23/Sep/2002
Reviewer:
Learn about Excel VBA in 10 HTML lessons with 5 Workbook examples
|
|
17.
Excel VBA UserForm Lessons - Business & Finance-Spreadsheets
23/Sep/2002
Reviewer:
10 Lessons and 5 Workbook examples on Excel VBA UserForms
|
|
18.
Formula and Text Manager for Excel - Business & Finance-Spreadsheets
23/Apr/2003
Reviewer:
Easily manage text and formulas in Excel
|
|
19.
Excel Level 3 and Excel VBA Courses - Business & Finance-Spreadsheets
24/Jan/2003
Reviewer:
Excel Levels 3 and Excel VBA Course
|
|
20.
Excel Level 3 Lessons - Business & Finance-Spreadsheets
23/Sep/2002
Reviewer:
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.
|
|
21.
Excel Levels 1 and 2 Training - Business & Finance-Spreadsheets
24/Jan/2003
Reviewer:
Excel Levels 1 and 2 Courses
|
|
22.
Excel Manager Collection - Business & Finance-Spreadsheets
19/May/2004
Reviewer:
Duplication, Formula, Text & Number Managers Excel Add-ins
|
|
23.
Excel OzGrid Plus With Duplication Manager - Business & Finance-Spreadsheets
10/Feb/2003
Reviewer:
The OzGrid plus and Duplication Manager bundled.
|
|
24.
Excel Level 1, 2 and 3 Training 7924-14 - Business & Finance-Spreadsheets
08/Jan/2003
Reviewer:
MS Excel Training for newsletter members only
|
|
25.
Excel Level 2 and 3 Training - Business & Finance-Spreadsheets
05/Apr/2004
Reviewer:
Excel Level 2 and 3 Training
|
|
26.
Excel Level 2 Lessons - Business & Finance-Spreadsheets
23/Sep/2002
Reviewer:
10 Lessons and 5 Workbook examples on Excel level 2
|
|
27.
Excel and Excel VBA Tips and Tricks - Business & Finance-Spreadsheets
11/Oct/2002
Reviewer:
Tips and Tricks for Excel Workbook, plus free add-in demos
|
|
28.
Excel Level 1 Lessons - Business & Finance-Spreadsheets
23/Sep/2002
Reviewer:
10 Lessons and 5 Workbook examples on Excel level 1
|
|
29.
Ad Free Forums - Business & Finance-Spreadsheets
19/Aug/2008
Reviewer:
Ad Free Ozgrid Question & Answer Forums
www.ozgrid.com/forum
|
|
30.
Excel 2007 Level 1 Training - Business & Finance-Spreadsheets
01/May/2009
Reviewer:
<P>These Excel 2007 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 10 lessons. Each lessson is between 5 and 10 Word Document pages long.<P>
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.<P>
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!<P>
BASIC COURSE OUTLINE:<P>
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.<P>
WHY USE US FOR EXCEL TRAINING?<P>
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!<P>
|
|
31.
Excel 2007 Level 2 Training - Business & Finance-Spreadsheets
01/May/2009
Reviewer:
<P>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.
<P>BASIC COURSE OUTLINE:
<P>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.
<P>WHY USE US FOR EXCEL TRAINING?
<P>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!
|
|
32.
Password For Ozgrid Custom Functions Add-in - Business & Finance-Spreadsheets
15/Sep/2009
Reviewer:
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. http://www.ozgrid.com/excel-add-ins/free-excel-addin.htm
|
|
33.
Excel List Transposer - Business & Finance-Spreadsheets
30/Sep/2009
Reviewer:
Excel is designed to work with continuous data laid out in a classic table/database format. If your data is NOT laid out in this format, you are NOT doing yourself any favors
|
|
34.
Fill Blanks - Business & Finance-Spreadsheets
30/Sep/2009
Reviewer:
When setting up data in Excel it is good practice to ensure that all cells within a list are occupied. However, most people when creating a list in Excel will often leave a blank cell if the data for that cell is the same as the cell above
|
|
35.
Lists To Table Add-in - Business & Finance-Spreadsheets
30/Sep/2009
Reviewer:
As regular Excel users know, Excel works best when data is laid out in a classic table format. When set-up like a table we can take advantage of Excels many features, like AutoFilter , Pivot Tables and many more. Unfortunately we cannot always dictate the lay-out of data as it is beyond our control.
|
|
36.
Ozgrid List Manager - Business & Finance-Spreadsheets
30/Sep/2009
Reviewer:
3 Excel add-ins in one.
1) Fill Blanks will fill your blank cells in your list with the cell above
2) Lists to Table will tranform your lists into classic Excel tables
3) List Transposer will transpose your single column list into a multi-columned table
|
|
37.
Beginner & Intermediate Chart Lessons - Business & Finance-Spreadsheets
12/Oct/2009
Reviewer:
Beginner & Intermediate Chart Lessons
<P>Beginner = How to build a combination Column and Line chart.<BR>
<BR>
Intermediate = How to use custom data markers in XY-Scatter and Line charts.
|
|
38.
Intermediate To Advanced Chart Lessons - Business & Finance-Spreadsheets
12/Oct/2009
Reviewer:
Lessons
How to construct ?
<P>1) Bullet chart
<P>2) Bar and Line combination chart
<P>3) Add Total data label on Stacked Column chart
<P>4) Dual formatting of Line chart
<P>5) Pictorial Column chart
<P>6) Gauge chart
<P>7) Conditional data makers
<P>8) Arbitrary Axis labelling
<P>9) Shading plot area
<P>10) In-cell charts
|
|
39.
Intermediate Chart Lesson - Business & Finance-Spreadsheets
12/Oct/2009
Reviewer:
This intermediate chart lesson from Ozgrid gives step-by-step details and screen shots on how to use custom data markers in XY-Scatter and Line charts.
|
|
40.
Advanced Chart Lesson - Business & Finance-Spreadsheets
12/Oct/2009
Reviewer:
This advanced chart lesson from Ozgrid gives step-by-step details and screen shots on how to create a clustered-stacked column chart.
|
|
41.
Intermediate & Advanced Chart Lessons - Business & Finance-Spreadsheets
12/Oct/2009
Reviewer:
Intermediate & Advanced Chart Lessons
<P><BR>
Intermediate = How to use custom data markers in XY-Scatter and Line charts.<BR>
<BR>
Advanced = How to create a clustered-stacked column chart.
|
|
42.
Beginner,Intermediate & Advanced Chart Lessons - Business & Finance-Spreadsheets
12/Oct/2009
Reviewer:
Beginner,Intermediate & Advanced Chart Lessons
<P>Beginner = How to build a combination Column and Line chart.<BR>
<BR>
Intermediate = How to use custom data markers in XY-Scatter and Line charts.<BR>
<BR>
Advanced = How to create a clustered-stacked column chart.
|
|
43.
Beginner Combination Column & Line Chart Lesson - Business & Finance-Spreadsheets
12/Oct/2009
Reviewer:
This beginner chart lesson from Ozgrid gives step-by-step details and screen shots on how to build a combination Column and Line chart.
|
|
44.
Custom Excel Functions Add-In - Business & Finance-Spreadsheets
12/Oct/2009
Reviewer:
<P>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,
B_ =Boolean (TRUE/FALSE) Function
C_ =Color Function
D_ =Date Function,
L_ =Lookup Function.
S_ =String (Text) Function.
<P>PRE200* means the lowest version the custom function will
work on. Please note, that the SpellDollarVal is
NOT written by Ozgrid. It was written by Microsoft.
<P>Two Column Lookup
to Find N'th Occurrence:
<P>Sum Every Nth
<P>Sum The X Smallest/Largest Numbers In Row or Columm
<P>Sum by Color-Count by
Color
<P>Sum Excel Ranges Diagonally
<P>Sum Excel Range Meeting Up To 5 Conditions
<P>A Single Function That Will
SUM or COUNT Cells
By Their Fill Color
<P>Count Words
<P>
Count
or Sum Specified Number In Cell Housing Many Numbers
<P>Extract Numbers
from Text Strings
<P>
List/Return
Difference Between 2 Cells Containing Comma Separated Strings
<P>Sort by Color
<P>Workbook Name
in Cell
<P>VLOOKUP
Across Multiple Sheet
<P>Extract
Last Word
<P>Non Repeating
Random Numbers
<P>Get Cell
Comment Text Into Cell
<P>Interior
Cell Color by Index or Name
<P>Reverse Cell
Content
<P>Get Highest
Number Between Nominated Range
<P>
<BR>
Microsofts
Convert a Numeric Value into
English Words<BR>
<BR>
Microsofts
Convert a Currency or Value
into English Words
<P>
<BR>
Get Hyperlink Address
<P>
<BR>
Does Cell Have a Formula
<P>2 Functions To Determine Excel Calculation Status & Mode<BR>
<BR>
Extract File
Name from Full Path Name
<P>
<BR>
Does an Excel
Workbook Exists or Not?
<P>Extract
nth Word From Text in Excel
<P>How Many Specified
Days in a Month
<P>Determine nth Weekday of a Specified Date
<P>Calculate
Sliding Scale Tax
<P>
<BR>
Display AutoFilter
Criteria
<P>
<BR>
Return Date of Last
Chosen Day of Given Month<BR>
<BR>
Return Date of the First,
or nth Day of Month
<P>
<BR>
Count One Instance
of Each Entry
<P>
Lookup any
occurrence from any column and offset left or right
<P>
The Ultimate Excel Lookup Function This Custom Function will look in
any column, unless specified, for the nth occurrence of the specified
value and return the corresponding value x rows above or below the found
value to the left or right.
|
|
45.
Working With Worksheets In VBA - Business & Finance-Spreadsheets
16/Oct/2009
Reviewer:
dd Worksheets , Add Worksheets in Month Order , Add Sheets in Numeric Order , Sort Excel Sheets/Worksheets , How To Reference Sheets , Delete Sheet Event Code , Run VBA Macro Code On Protected Sheets , Unprotect Or Protect Sheets In One Go , Group/Sort Sheets By Tab Color , Hiding Sheets In Excel , Loop All Worksheets/Sheets in Workbook & Apply Code , Return Sheet Tab Name To Cell , Create an Index Of All Sheets , Email Sheets and more
|
|
46.
Multi Excel File Replace - Business & Finance-Spreadsheets
20/Oct/2009
Reviewer:
<P>Multi Excel File Replace. Find & Replace Across Multiple Excel Files (Workbooks) & Worksheets<P>Save countless hours by using Multi Excel File Replace. It can find and replace within multiple Excel files within seconds, saving you hours
|
|
47.
Excel Conditional Row Delete - Business & Finance-Spreadsheets
27/Oct/2009
Reviewer:
<P>Delete rows on an Excel worksheet by conditions in an instant. Specify up to 4 conditions across 4 columns (contiguous or noncontiguous).
<P>Comparison Types;
<P>Equals To
<P>Contains
<P>End In
<P>Starts With
<P>Greater Than
<P>Less Than
Instant download & Compatible With Excel 97 or above
|
|
48.
Time Sheet Advanced Upgrade to Open Source - Business & Finance-Spreadsheets
15/Oct/2004
Reviewer:
Time Sheet Advanced Upgrade to Open Source
|
|
49.
Time Sheet - Business & Finance-Spreadsheets
08/Jul/2003
Reviewer:
Keep track of employee times
|
|
50.
Time Sheet Advanced - Business & Finance-Spreadsheets
12/Sep/2003
Reviewer:
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.
|
|
51.
Formula Ref Changer and Sheet Index Creator - Business & Finance-Spreadsheets
21/Aug/2002
Reviewer:
Change formulae references in a flash. Create a index sheet with links.
|
|
52.
Number,Text & Formula Manager - Business & Finance-Spreadsheets
28/Apr/2003
Reviewer:
Easily Manage Number,Text & Formulas in Excel
|
|
53.
Half Price Complete Excel Course - Business & Finance-Spreadsheets
20/May/2005
Reviewer:
Complete Excel Course
|
|
54.
Upgrade to Advanced Excel Timesheet - Business & Finance-Spreadsheets
18/Aug/2004
Reviewer:
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.
|
|
|
