08 6210 8500
Pay my invoice
 Joining Text Together Easily
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
 Data Entry Via Data Form
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
 Find Data Validation Errors
Find Data Validation Errors Built-in feature By Neale Blackwood When using an in cell drop down via Data Validation it is possible to Paste Special an invalid value into the cell. Excel has a feature to track that type of validation error. Invalid entries can also occur if the list used for the in [...]
 Find The Limits Of A Selected Range
Find the limits of a selected range Keyboard shorcuts Ctrl + . and Ctrl + * By Neale Blackwood You can use Ctrl + * as a shortcut to selecting what's called, the current region. This includes all the cells with content around your active cell. If there are blank rows or columns around [...]
 Find Unique Entries
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
 Easy Group/Outline Of Rows And Columns
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
 Changing Signs Quickly
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
 Grouping Columns And Rows
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
 Fixing Trailing Minus Signs
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
 Working With Working Days
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
 Filling Blank Cells
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more
 CSV Files And Leading Zeroes
Access Analytic Knowledgebase Articles, Case Studies, White Papers, Success Stories and more