When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers. Excel gives you an error, but it doesn’t look like an error. Excel
Learn how to combine the most recent Friday Challenge solutions into an Excel Array formula to solve the Data Transformation needs.
Learn how to highlight horizontal axis category labels in an Excel Line Chart. Click here to see how simple this technique can work for your graphs.
In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data Transformation Data Transformation Now it
This weekend starts the ModelOff competition. “ModelOff is the world’s largest professional competition for Microsoft Excel, Financial Analysis, Investment Analysis and Financial Modelling.”
In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that criteria. Three posts ago, you received a challenge
In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data based on that criteria in Excel. Two posts ago, we showed presented with
Facebook Twitter Pinterest WhatsApp Linkedin There are many ways to Sum data in Excel. But when you have lots and lots of data, then you will want to learn a few different techniques. In o
Facebook Twitter Pinterest WhatsApp Linkedin Excel greek summation symbol This is a fun skills challenge to make sure you are well rounded. What is the SUM of your Excel Game? You will fin
Part of my time this week was spent working on a project for a client and I was sooo frustrated. I just couldn’t get my SUMIFS formula to work. Have you ever had that issue with an Excel fu