Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Wednesday, February 25, 2009 – Permalink –

Hide Digits

Simple obfuscation


The kid said,
"Daddy, I know the secret password!
It's star, star, star, star!"
****
You can use functions to hide parts of sensitive data.

Social Security Number 555-55-5555

=CONCATENATE("***-**-", RIGHT(B2,4))

Combines the last four digits of the SSN with the "***-**-" text string

(***-**-5555)



Credit Card Number 5555-5555-5555-5555

=CONCATENATE(REPT("****-",3), RIGHT(B3,4))

Repeats the "****-" text string three times and combines the result with the last four digits of the credit card number

(****-****-****-5555)

Microsoft Office Online:
Display only the last four digits of identification numbers




See all Topics

Labels: , ,


<Doug Klippert@ 3:14 AM

Comments: Post a Comment

  Wednesday, February 18, 2009 – Permalink –

SCORE Templates

Free business advice


SCORE is a nonprofit organization providing small business advice and training.

SCORE's 10,500 volunteers have more than 600 business skills. Volunteers share their wisdom and lessons learned in business. Our volunteers are working/retired business owners, executives and corporate leaders.
  • SCORE offers Ask SCORE email advice online.
  • Face-to-face small business counseling at 389 chapter offices.
  • Low-cost workshops at 389 chapter offices nationwide.
  • "How to" articles and business templates
Here are some of the available templates:
A Business Plan for a Start-up Business
Microsoft Word
A Business Plan for an Established Business
Microsoft Word
Bank Loan Request for Small Business
Microsoft Word
Break-Even Analysis
Excel
Competitive Analysis
Microsoft Word
Financial History & Ratios
Excel
Loan Amortization Schedule
Excel
Opening Day Balance Sheet
Excel
Personal Financial Statement
Excel

Projected Balance Sheet
Excel
Start-up Expenses
Excel
4-Year Profit Projection
Excel
12-Month Cash Flow Statement
Excel
12-Month Profit and Loss Projection
Excel
12-Month Sales Forecast
Excel

SCORE Template Gallery




See all Topics

Labels:


<Doug Klippert@ 3:09 AM

Comments: Post a Comment

  Tuesday, February 10, 2009 – Permalink –

Dynamic AutoShape Link

Show the star

Here's a hint that I had forgotten about.

You can tie the result of a cell to an AutoShape.

This displays the value in a more dramatic manner.
  1. Create an AutoShape on the Worksheet
  2. With the shape selected, type an equal sign in the formula bar.
  3. Enter the address of the linking cell (or click the cell)
  4. Hit Enter
Thanks to AutomateExcel.com for the reminder.




See all Topics

Labels: , ,


<Doug Klippert@ 3:21 AM

Comments: Post a Comment