Recent Posts


Circular Reference? Excel’s most popular (!#?%) error message explained

Millions of people using Excel don’t get why they see the “circular reference” error message right after they’ve entered a formula. The message means that your formula is trying to calculate its own cell–kind of like when a dog chases its own tail. Because so many of you (millions) searched on “circular reference” on, we thought we should very clearly explain how to remove or fix your formula.


Q&A with Access developer Juan Soto

Working in an ice cream factory in Chicago led Juan Soto to found IT Impact, Inc.,  an Access development consulting firm. The ice cream factory’s large Enterprise Resource Planning system required that he spend hours manually calculating whether a final batch of ice cream really made the company money. He had to factor the waste for every step of the manufacturing process and soon realized that he could automate the…


Tip: How to cut and paste without messing up formatting

Why does formatting sometimes get messed up when you cut and paste text? And what is that thing that appears at the end of the last sentence every time you paste-like a fly returning to honey. That thing–the Paste Options button–is your friend, a worker bee and not a fly whose only job is to follow your formatting instructions. Learning how it works keeps you from wasting time manually formatting…


Excel: The Basics (Video)

For those of us who crunch words instead of numbers, Excel can be intimidating. We don’t know the difference between a workbook and a worksheet, and for sure don’t know to ask about conditional formatting (a cool way to visually display data). Then one day your boss asks you to create a report–with numbers. Gulp. In this video, the Office 911 emergency responders show a beginning Excel user how to…


How to save your Access SharePoint password

Recently, someone posted a comment on IT Impact Inc.’s blog asking how to get SharePoint to remember his password when he logged in via Access.  He wanted to avoid having to log in every time. Ben Clothier, a Senior Access Developer at IT Impact, knew the answer. He wrote a detailed blog post (with plenty of screenshots) that we’d like to share with you.  ITImpact has been building custom databases with…


Guy Kawasaki’s guide to creating a financial forecast

You’ve finished your business plan and polished the pitch for investors. As an entrepreneur you know what comes next: number-crunching. To clinch funding, you need a financial projection that shows investors the path to profitability. We worked with @Guy Kawasaki to guide you through creating a financial forecast that will wow funders.


Organize your recipes with a OneNote cookbook

Do you like to test out new recipes? When you find a good one, I bet you hang on to it. When one falls flat, you scratch it from your collection fast. And then there’s that outrageous dessert you brought to the holiday party-everyone wants a copy of that recipe! How do you keep track? A really cool OneNote recipe book can help you out. Take a peek by clicking…