You are here: Home / Archives for Excel

The Need for Now

August 5, 2010 By

Forget a leisurely Sunday drive or going to a restaurant without a reservation. Today, everyone wants everything to be convenient and fast. We have drive-through everything – photos, pharmacies, weddings, and anything else you can dream of.

There’s no need to wait in line at the local Blockbuster; you can watch Netflix on demand. You can order your groceries online and have them delivered, print a boarding pass at the airport kiosk (no humans necessary!), and have your dry-cleaning delivered with just a click. Even GPS systems, which were once a luxury in cars, are becoming a standard. Have we lost our sense of direction? No, we like having a faster, more convenient way of getting there. [Read more...]

Filed Under: Excel, ROI, Worker Productivity Tagged With: , , , ,

Management Tool Best Practices: 3 Excel Tips that Promise Charting Greatness

August 4, 2010 By

If you are managing the IT infrastructure, senior-level projects or are the IT leader in charge of maintaining and analyzing the majority of IT’s data points, you’re likely using Microsoft Excel every day. [Read more...]

Filed Under: Excel, How To Tagged With: , ,

Flawless Formulas in Excel: 4 Essential Tips

November 11, 2009 By

The beauty of Excel is its simplicity: If you enter your data correctly, it works. However, it can be ugly, especially when it returns a mess of formula errors, which sometimes are as understandable as Sanskrit.

We have gathered some tips that will help you root out the potential problems in formulas. If you can identify the issue quickly, then we’ve done our job. As for helping you fix it, that’s for another post.

A circular reference sends Excel into an endless loop where it will never stop calculating the cell. Excel goes around and around, never stopping to give us a final number…

1. Formula Evaluation Tool (Excel 2000, 2002, 2003, 2007)

by David McQueary

If you’ve ever created a formula, you no doubt have come across a dreaded #N/A, #DIV/0 or other type of error. This can be frustrating, especially if the formula you entered is long and complex. Sometimes it is not easy to see what is causing the malfunction, and trying to read through the formula to spot the offender is not always a fruitful effort. Excel offers a Formula Evaluation tool, which assesses a formula step by step, showing each calculation and enabling you to view exactly where the error occurs. Here’s how:

Excel 2000, 2002, 2003:

1. Click Tools and move your mouse over Formula Auditing. [Read more...]

Filed Under: Excel, How To Tagged With: , , ,

An Open Letter to a CIO

June 3, 2009 By

Dear Mr. CIO:

I understand we’re in a recession, and the pressure for you to prune your budget is great, but how on Earth do you expect to get the same quality IT outsourcing for less money? I didn’t major in business, but I do know that in a capitalist society, nothing is free. Didn’t they teach you that in economics 101? [Read more...]

Filed Under: Access, Excel, Outsourcing, ROI Tagged With: , , , ,
« Older Posts
Newer Posts »