1. Excel Level 3 & Excel VBA & Excel UserForm Courses - Business & Finance-Spreadsheets
24/Jan/2003
Reviewer:
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.
2. Excel Duplication Manager Add-in - Business & Finance-Spreadsheets
21/Aug/2002
Reviewer:
Manage duplicate data in your Workbook with ease.
21/Aug/2002
Reviewer:
Manage duplicate data in your Workbook with ease.
3. Text Manager - Business & Finance-Spreadsheets
21/Apr/2003
Reviewer:
Easily manage text in your Excel spreadsheets.
21/Apr/2003
Reviewer:
Easily manage text in your Excel spreadsheets.
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
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:
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
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:
05/Oct/2004
Reviewer:
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.
8. Number Manager - Business & Finance-Spreadsheets
28/Apr/2003
Reviewer:
Easily work with numbers in Excel
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
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
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
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
16/Apr/2003
Reviewer:
Easily manage formulas in Excel
13. OzGrid Excel Plus Add-in - Business & Finance-Spreadsheets
21/Aug/2002
Reviewer:
Eight Excel addins in one.
21/Aug/2002
Reviewer:
Eight Excel addins in one.
15. TimeAndWageBook - Business & Finance-Spreadsheets
23/Sep/2002
Reviewer:
Calculate employee time and wages in an Excel Workbook
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
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
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
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
24/Jan/2003
Reviewer:
Excel Levels 3 and Excel VBA Course
20. Excel Level 3 Lessons - Business & Finance-Spreadsheets
23/Sep/2002
Reviewer:
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
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
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.
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
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
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
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
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
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
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>
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!
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
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
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
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.
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
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.
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
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.
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.
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.
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.
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.
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.
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
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
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
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
15/Oct/2004
Reviewer:
Time Sheet Advanced Upgrade to Open Source
50. Time Sheet Advanced - Business & Finance-Spreadsheets
12/Sep/2003
Reviewer:
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.
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
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
20/May/2005
Reviewer:
Complete Excel Course
54. Upgrade to Advanced Excel Timesheet - Business & Finance-Spreadsheets
18/Aug/2004
Reviewer:
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.