| 1.Excel Level 3 & Excel VBA & Excel UserForm Courses |
|
24/Jan/2003 |
|
|
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.
|
|
|
|
|
| 3.Text Manager |
|
|
21/Apr/2003 |
|
|
Easily manage text in your Excel spreadsheets.
|
|
|
| 4.OzGrid excel Addins Collection |
|
26/Aug/2002 |
|
|
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 |
|
|
24/Jan/2003 |
|
|
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.
|
|
|
|
|
| 7.Time Sheet Advanced Open Source |
|
|
05/Oct/2004 |
|
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 15.TimeAndWageBook |
|
|
23/Sep/2002 |
|
|
Calculate employee time and wages in an Excel Workbook
|
|
|
|
|
|
|
|
|
|
|
| 20.Excel Level 3 Lessons |
|
|
23/Sep/2002 |
|
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 29.Ad Free Forums |
|
19/Aug/2008 |
|
|
Ad Free Ozgrid Question & Answer Forums
www.ozgrid.com/forum
|
|
|
| 30.Excel 2007 Level 1 Training |
|
|
01/May/2009 |
|
|
<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 |
|
|
01/May/2009 |
|
|
<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 |
|
|
15/Sep/2009 |
|
|
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 |
|
|
30/Sep/2009 |
|
|
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 |
|
|
30/Sep/2009 |
|
|
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 |
|
|
30/Sep/2009 |
|
|
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 |
|
|
30/Sep/2009 |
|
|
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 |
|
|
12/Oct/2009 |
|
|
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 |
|
|
12/Oct/2009 |
|
|
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 |
|
|
12/Oct/2009 |
|
|
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 |
|
|
12/Oct/2009 |
|
|
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 |
|
|
12/Oct/2009 |
|
|
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 |
|
|
12/Oct/2009 |
|
|
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.
|
|
|
|
|
| 44.Custom Excel Functions Add-In |
|
|
12/Oct/2009 |
|
|
<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 |
|
|
16/Oct/2009 |
|
|
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 |
|
|
20/Oct/2009 |
|
|
<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 |
|
|
27/Oct/2009 |
|
|
<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
|
|
|
|
|
| 49.Time Sheet |
|
|
08/Jul/2003 |
|
|
Keep track of employee times
|
|
|
| 50.Time Sheet Advanced |
|
|
12/Sep/2003 |
|
|
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.
|
|
|
|
|
|
|
|
|
| 54.Upgrade to Advanced Excel Timesheet |
|
|
18/Aug/2004 |
|
|
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.
|
|
|
