Microsoft Excel Tips & Tricks

How often are you sorting or filtering data to manually locate Excel entries that might require additional data entry or auditing? With the IF function, you can automatically evaluate your data based on the condition or conditions that you create.…

How can you calculate the difference between two dates in Excel? And what if you also want to create calculations with dates, excluding weekends and possibly holidays? Let’s look at two Excel functions, WORKDAY and NETWORKDAYS, that help you perform…

The Problem with Excel Formatting I occasionally receive email messages from clients and contacts about a Microsoft Excel “problem”, that is, each one asked a similar question, “Is there a bug in Excel? It looks like some of my formulas…