Blog Feed

Don’t Make Goals, Make Resolutions

Every New Year’s Day, nearly half of Americans participate in the tradition of promising to better themselves in the upcoming year. Most of these improvements will be personal: lose weight, spend less and get organized were the top three resolutions of 2014.[1] Career-related ambitions follow a similar pattern with popular…
Read More

How Did I Get Here?

Once in a Lifetime – Talking Heads [1] “And you may find yourself living in a shotgun shack And you may find yourself in another part of the world And you may find yourself behind the wheel of a large automobile And you may find yourself in a beautiful house,…
Read More

Present Value of Annuity Formulas in Excel

For anyone working in finance or banking, the time value of money is one topic that you should be fluent in. Knowing exactly what it means to discount something or to get the future value of a particular investment vehicle is necessary to do the job. Excel can be an…
Read More

How to Link with Excel Hyperlink Formula

When using Excel, do you ever need to quickly access information stored elsewhere-- the internet or your company's intranet, for example? Taking the time to find these files outside of Excel can waste valuable time, especially if you get lost navigating away from your spreadsheet and forget the information’s context…
Read More

Want to Boost Productivity? Have Employees Read a Book!

Would you like to boost employee confidence? Improve empathy? How about encouraging curiosity and critical thinking across all levels of your organization? What if, in doing so, you could also foster a new sense of community and engagement? Now, imagine if I told you all you needed to do was…
Read More

Six Word Selfie

Selfies. Even the word can come off as self-centered. Barely discernable landmarks, oblivious celebrities and current events blur behind odd faces, cocked heads and flashy grins. The word was, for better or worse, added to our lexicon this year, though it’s not always well understood (John Oliver’s Last Week Tonight…
Read More

Seven Lessons from Fiction

You can read my mind. It’s true. Watch: Imagine a desk, cluttered, lit by the hazy glow of a computer monitor and an overhead fluorescent fixture. A slate gray phone barely peeks out from beneath a cascade of file folders and papers. On top of the precarious stack sits a…
Read More

Calculating Time with Excel Formulas

How often have you looked at your watch and typed the current time into your worksheet? Or tried to convert from one time zone to another and produced an error? Or wondered why a time shows up looking like “0.9285”? Fortunately, these questions are easy to answer once you understand…
Read More

How to Use the Excel Match Function to Find Data

In Excel, some functions exist to be used to increase functionality when paired with other functions. MATCH is a good example. MATCH helps you search a range of references to find a “match” to your query. It then returns the position of that match. In short, you can use MATCH…
Read More

Unleashing the Flexibility of Excel Text Formulas

Data collection is an important part of business. It is customer satisfaction survey results, employee performance assessments, market and industry research, lead generation analysis, or anything that depends on collecting, comparing and seeking relevant information. Unfortunately, depending on the setup and your tools, raw data can be confusing and impossible…
Read More
< >