Category: Formulas
Spotlight Excel Formula: Convert Text to Numbers
Numbers stored as text can present problems for lookup formulas and regular calculations. There are a few ways to convert Text to Numbers in Excel using a formula. We’ll look at three separate scenarios and see how we can use a formula to make things work the way they should.…
Read More
Accounting Magic – What You Need to Know About Accounting Excel Formulas
Accounting is more than just debits and credits. It is the calculation and analysis of those debits and credits that generate accounting information an organization can act upon. Let’s take a look at two types of reports a professional in the Accounting Department might be asked to generate. Then, we’ll…
Read More
Excel Finance Formulas
Given the number-crunching power of Excel, you might surmise that when it comes to calculating money matters, it really shines. And, so it does. In order to understand how the various financial functions, work, there are a few components to understand. Most of the 55 functions that are classified as…
Read More
List of Essential Excel Formulas
There are hundreds of functions in Excel that can be very helpful in crunching numbers and transforming data into information. Here are three categories of critical functions that every savvy Excel user should know how to read and use. See these formulas and functions in action by downloading: List of…
Read More
It’s About Time! Excel Timesheet Formulas
Date and time math is one of the strengths of Excel. However, it helps to know a few secrets and hidden gems to make your timesheet calculations work smoothly. In this practice, we’ll work with several different Excel functions. But first we need a basis from which to understand how…
Read More
Time-Saving Excel Formulas Cheat Sheet
Syntax, Operators and Functions…Oh My! Do you speak Excel? Are you just starting out and trying to remember the go-to lingo? Well, today’s blog post is a snapshot of helpful cheat sheet material to help you build your Excel skills. Advanced Filter Criteria Popular Excel Functions and Descriptions Next Steps…
Read More
Excel Sort Formulas – How to Sort Dynamic Data
Excel includes powerful sort functionality in the Sort & Filter group on the Data tab. But what if your data changes frequently, or if you're simply tired of clicking through the Ribbon each time you generate a similar table? The answer might be to create a formula that does your…
Read More
Finding Information with the Index Formula in Excel
About Excel's INDEX Function Sometimes useful functions like VLOOKUP just don't apply when the information you need is more about where in your table the information is than what the information is. The INDEX function returns the value of an element that is specified by position (row and column) in…
Read More
Excel Formula Not Calculating?
As committed Excel users, we often go on and on about it as a productivity solution and essential program powerhouse. But catch us on a bad day and we are cursing that little green arrow and #VALUE! error like nobody’s business! Have you ever poured time into a worksheet, only…
Read More
No Excel Multiplication Formula? 3 Ways to Multiply in Excel
While there is no “Excel multiply formula” there are multiple ways to multiply in Excel. For instance, do you use an asterisk (*) to multiply, but hit a brick wall when you apply other arithmetic operators? What about shortcuts for multiplying many numbers in one step? Read on for three…
Read More