|
||||
|
Born & brought up in Delhi, India, completed schooling from KV JNU campus. After matric (10th), I opted Commerce With Maths (E-section) and secured good command over mathematics. Done B.Com.(Hons.) from R.L.A College – Delhi University & BCA from IGNOU. Now I am a distinction holder MBA postgraduate, with Specialization in HRIS. I am . . . → Read More: New Guest Author: Dilip Pandey DataSafeXL proudly welcomes Dr. Elliot Bendoly as a guest author in our blog. Professor Bendoly is the Caldwell Research Fellow at Emory Univeristy’s Guizueta Business School. He joined Goizueta in 2001 after receiving a PhD in the fields of Operations Management and Decision Sciences from Indiana University. Along with these specializations, his academic background . . . → Read More: New Guest Author: Dr. Elliot Bendoly 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 part of the Microsoft Office 2007-2010 user interface, is designed to . . . → Read More: Customise the Ribbon in Excel 2007-2010 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 feeder cells that only become apparent later on, usually in different tabs to . . . → Read More: Excel Hell: How Simple Checksums Can Ease The Pain of Financial Modelling 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 operate - Fixed issue with removing XLSafe menus from some machines after un-installing . . . → Read More: XLSafe PRO Change Log 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 almost 10 years’ professional experience in financial control and business planning, James has . . . → Read More: New Guest Author: James Power (FD4Cast) 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 different categories on the Y-axis with the total revenue for each device . . . → Read More: Heat Maps in Excel 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 extract is taken from the authors of the above mentioned website: ExcelFunctions.net aims to solve all the problems that . . . → Read More: Complete List of Excel Functions 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 “Lock file to its current location”. In this way, your spreadsheet can only . . . → Read More: Prevent Duplicate Copies Of Spreadsheets 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 code by Microsoft Excel. By having your code scrambled with . . . → Read More: Scramble VBA Code in Spreadsheets |
 |
|||
|
Copyright © 2012 DataSafeXL.com - All Rights Reserved |
||||
