Blog Feed
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
Calculate Range in Excel: 3 Easy Formulas
An essential skill any Excel user should know is how to determine the range of values in Excel. Most businesses don't have time to waste sorting through rows and rows in Excel in order to find the highest and lowest values of revenue, sales, or other information. The difference between…
Read More
Compound Annual Growth Rate: Comparing Investments with the Excel CAGR Formula
Does your company offer several types of IRA accounts? Are you unsure of your current IRA strategy? How do you know if the choices you make for your future are the best available to you? Say you review your IRA returns and consider changing your mix of investments. Five years…
Read More