Tag: Excel
Calculating Hours Difference of Time in Excel Spreadsheets
When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers. Excel gives you...
Data Transformation – Excel Array Solution
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages. Well although...
How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts
The Problem
Recently a fan contacted me and asked how she change the horizontal axis could do the as follows:
"I am trying to bold 5...
Friday Challenge – Data Transformation Solution
In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data...
Friday Challenge – Data Transformation
This weekend starts the ModelOff competition.
"ModelOff is the world’s largest professional competition for Microsoft Excel, Financial Analysis, Investment Analysis and Financial Modelling." -Modeloff Site
If...
Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria
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...
Advanced Excel Summation Skills Using SUMIFS and SUMPRODUCT
In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data...
Advanced Excel Summation Techniques Using Pivot Table
There are many ways to Sum data in Excel. But when you have lots and lots of data, then you will want to learn...
Friday Challenge – Advanced Excel Summation Skills
This is a fun skills challenge to make sure you are well rounded. What is the SUM of your Excel Game? You will find...
Why Won’t My Excel SumIFs Formula Work?!
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...
