|
| |
|
|
|
|
Rating :
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.
|
|
|
Rating :
Manage duplicate data in your Workbook with ease.
|
|
|
Rating :
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.
|
|
|
Rating :
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
|
|
|
Rating :
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.
|
|
|
Rating :
Excel VBA Training Level 1 and Excel UserForms and Controls
|
|
|
Rating :
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.
|
|
|
Rating :
Easily work with numbers in Excel
|
|
|
Rating :
Excel levels Basic to Advanced Training
|
|
|
Rating :
Forms ComboBox Wizard Add-in
|
|
|
Rating :
Over 33 Excel & VBA Workbook Examples
|
|
|
Rating :
Easily manage formulas in Excel
|
|
|
Rating :
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.
|
|
|
Rating :
Manage Excel Named Ranges
|
|
|
Rating :
Calculate employee time and wages in an Excel Workbook
|
|
|
Rating :
Learn about Excel VBA in 10 HTML lessons with 5 Workbook examples
|
|
|
Rating :
10 Lessons and 5 Workbook examples on Excel VBA UserForms
|
|
|
Rating :
Easily manage text and formulas in Excel
|
|
|
Rating :
Excel Levels 3 and Excel VBA Course
|
|
|
Rating :
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.
|
|
|
Rating :
Excel Levels 1 and 2 Courses
|
|
|
Rating :
Duplication, Formula, Text & Number Managers Excel Add-ins
|
|
|
Rating :
The OzGrid plus and Duplication Manager bundled.
|
|
|
Rating :
MS Excel Training for newsletter members only
|
|
|
Rating :
Excel Level 2 and 3 Training
|
|
|
Rating :
10 Lessons and 5 Workbook examples on Excel level 2
|
|
|
Rating :
Tips and Tricks for Excel Workbook, plus free add-in demos
|
|
|
Rating :
10 Lessons and 5 Workbook examples on Excel level 1
|
|
|
Rating :
Ad Free Ozgrid Question & Answer Forums
www.ozgrid.com/forum
|
|
|
Rating :
<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>
|
|
|
Rating :
<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!
|
|
|
Rating :
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
|
|
|
Rating :
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
|
|
|
Rating :
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
|
|
|
Rating :
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.
|
|
|
Rating :
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
|
|
|
Rating :
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.
|
|
|
Rating :
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
|
|
|
Rating :
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.
|
|
|
Rating :
This advanced chart lesson from Ozgrid gives step-by-step details and screen shots on how to create a clustered-stacked column chart.
|
|
|
Rating :
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.
|
|
|
Rating :
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.
|
|
|
Rating :
This beginner chart lesson from Ozgrid gives step-by-step details and screen shots on how to build a combination Column and Line chart.
|
|
|
Rating :
<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.
|
|
|
Rating :
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
|
|
|
Rating :
<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
|
|
|
Rating :
<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
|
|
|
Rating :
Time Sheet Advanced Upgrade to Open Source
|
|
|
Rating :
Keep track of employee times
|
|
|
Rating :
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.
|
|
|
Rating :
Change formulae references in a flash. Create a index sheet with links.
|
|
|
Rating :
Easily Manage Number,Text & Formulas in Excel
|
|
|
Rating :
Complete Excel Course
|
|
|
Rating :
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.
|
|
|
|
|
|
|
Copyright (c) 2007-2010 SharewareOrder.com Inc. All rights reserved. |
|
|