Quantcast
Home Tags Excel

Tag: Excel

Calculating Hours Difference of Time in Excel Spreadsheets

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...
Excel Array Solution

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

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...
Data Transformation Butterfly Image

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...
Data Transformation Formulas in Excel

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...
Excel Array Formulas SumIF

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...
Learn SumProduct and SumIF Excel Functions

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...
Grouping Pivot Table Data in Excel

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...
Excel greek summation symbol

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...
What Is My Problem with this Excel SUMIFS Formula

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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link