Latest Blog Posts for Datasafexl - Microsoft Excel Consultants

• Customise the Ribbon in Excel 2007-2010
  on Aug 6, 2010 in Excel Articles Customise the Ribbon in Excel XML file schema XML Microsoft Excel
  In this article we will show you how you can amend the ribbon of your Microsoft Excel 2007-2010 files. Note that you must be familiar with a Microsoft Excel XML file schema to use this information.  Can I customise the ribbon? The Ribbon, which is...
• Excel Hell: How Simple Checksums Can Ease The Pain of Financial Modelling
  on Aug 3, 2010 in Excel Articles excel checksums excel financial modelling
  Cell-based modelling is a root cause of Excel Hell. Some of the unavoidable issues include:- 1. Simple errors in formula construction, returning error values such as: #VALUE! ; #REF! ; #NAME? ; #N/A; etc. 2. Errors in formulas dependent on other feed...
• Excel Hell: How Simple Checksums Can Ease The Pain of Financial Modeling
  on Aug 3, 2010 in Excel Articles
  Cell-based modeling is a root cause of Excel Hell. Some of the unavoidable issues include:- 1. Simple errors in formula construction, returning error values such as: #VALUE! ; #REF! ; #NAME? ; #N/A; etc. 2. Errors in formulas dependent on other feede...
• XLSafe PRO Change Log
  on Aug 2, 2010 in Excel Utilities xlsafe pro latest version xlsafe pro update
  XLSafe PRO has been updated to version 2.60. Major Improvements & Bug Fixes - Fixed crashing issue with XLSafe admin when attempting to save a newly created file on some machines - Activation process does no longer depend on Microsoft Outlook to...
• XLSafe PRO v2.60 Update
  on Aug 2, 2010 in Excel Utilities xlsafe pro latest version xlsafe pro update
  XLSafe PRO has been updated to version 2.60. Major Improvements & Bug Fixes - Fixed crashing issue with XLSafe admin when attempting to save a newly created file on some machines - Activation process does no longer depend on Microsoft Outlook to...
• New Guest Author: James Power (FD4Cast)
  on Jul 6, 2010 in Authors
  We would like to give a warm welcome to our new guest author, James Power! James Power is Development Director of FD4Cast Ltd, a company based in Bristol, UK, which specialises in the production of integrated forecasting and budgeting solutions. With...
• Heat Maps in Excel
  on Jul 6, 2010 in Excel Graphs Create Heat Maps in Excel
  A heat map is a graphical representation of data where the values taken by a variable in a two-dimensional map are represented as colors. A neat example of a heat map constructed in Microsoft Excel can be seen below: The above diagram represents dif...
• Complete List of Excel Functions
  on Jul 1, 2010 in Excel Tips Microsoft Excel functions
  If you are looking for a website that has a complete list of all Microsoft Excel functions including the new Microsoft Excel 2007-2010 functions with illustrative examples then you should definitely visit: http://www.excelfunctions.net The following...
• Prevent Duplicate Copies Of Spreadsheets
  on Jun 30, 2010 in Excel Utilities prevent copies spreadsheet duplication
  In this article we will show you how you can use XLSafe PRO to prevent users from making duplicate copies of your spreadsheets. Simply open the XLSafe Protection Panel and navigate to the “Advanced Options” tab. Then click on the option...
• Scramble VBA Code in Spreadsheets
  on Jun 28, 2010 in Excel Utilities protect vba code scramble vba code
  Numerous third party tools are available on the internet which can be easily used to break the password security of VBA code. With VBASafe your VBA code is converted to a format which is unreadable to the human eye but still interpreted as normal cod...

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment