Excel Duplication Manager Add in This very handy add-in will make your management of lists a breeze. It is designed to assist you when you have duplicates in 1 or more lists. You can create a list of uniques hide all duplicates create a summary report color code all duplicates (up to 3 levels) and even *prevent* users from adding duplicates to a list or table! There is also the option to compare 2 lists for matching entries.
Have a list where entries are repeated over and over? There is now an option to remove all but ....MORE
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.
Lesson 10 has Time Saving Microsoft Excel Solutions. It is a downloadable book in Windows help file format that contains hundreds ....MORE
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 ....MORE
Fill Blanks 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
OzGrid Excel Plus Add in Formula Report Generator. Allows you to very easily create a report showing formulas within your Workbook that are either external references internal references or both. You can also nominate which Worksheet(s) to use to base your report on.
Dynamic Range Namer. This will allow you to very quickly and easily create any one of eight different types of dynamic ranges that will expand down rows or across columns. You can even nominate the column or row to use as the criteria. It can also ex ....MORE
Download contains 2 Workbooks. One for 97-2003 users and one for 2007 users.
You will learn how to Add 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 ....MORE
Complete Excel VBA Course COMPLETE EXCEL & VBA COURSE 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 50 lessons each between 5 and 10 Word Document pages long and 25 Workbook examples. There is also an online Microsoft Pivot Table tutorial.
EXCEL LEVELS 1 2 AND 3 OUTLINE
The Fundamentals of Excel Cut Copy Insert Delete Paste Spec ....MORE