Welcome To I Get It! Development
Journal of Accountancy Articles
Tweaking The Numbers - June 2001
Real Time Graphical What-If Analysis
This article has step-by-step instructions showing how to use ActiveX controls like
slider bars and spin buttons in an Excel spreadsheet. You can download the sample
worksheet if you don't want to create it yourself!
Block That Spreadsheet Error - August 2002
Data Validation For User-Friendliness
Use Data Validation to help users enter the correct types of data as well as restrict the range of values. You can require date types, but
also require a date from the current year. You can require the contents of a cell to be within a fixed range, or a range based on the
contents of another cell. Download the sample spreadsheet.
Keeping Secrets - July 2007
Excel Security Issues
Excel is not a secure environment. Before you send out your Excel files via email or post them to your web site,
do a Google search on "Excel password cracker" just for a reality check. If your workbook contains sensitive data,
print it out to PDF, copy and paste it as "text only" into Word or Powerpoint, or just send a paper copy via
snail mail! Say what you want about paper, it can't be hacked!
|
|