## Women in Excel You Need to be following

Awesome Women in Excel you need to be following

## Excel Knowledge Sharing week ending Fri. 20 Dec

Have you an awesome Excel resource to share? Something you published, a video or blog. Or, maybe a resource you found online. Excel knowledge sharing time is here

## Finding Your Way around Power Pivot – An Orientation

When you see Power Pivot for the first time it can be confusing.  It’s a new interface, with new ribbons and views.  Before you start working with tables of data and complex models, you need to get comfortable with the user interface.  In this article, we will take a look around Power Pivots user interface […]

## DAX SUM and SUMX Functions

The role of both DAX SUM and SUMX functions is to add numerical data together. Yet both these functions are rather different. Let’s talk about the SUM function first. The SUM function is simple. It takes a column of data and adds the values to give a total. It works like the sum function in […]

## Simple Explanation of Machine Learning shown with Excel – Part 1

In this article we are going to explain the concept of machine learning with Excel. we will look at an example of Entropy and Information Gain

## How Use Excel T.TEST – Was a Marketing Campaign Successful?

Like z-tests, t-tests ( and Excel T.test function) are calculations used to test a hypothesis, but they are most useful when we need to determine if there is a statistically significant difference between two independent sample groups.  In this article we will look at T.TEST in Excel. A t-test asks whether a difference between the […]

## Looking up and Combining text using TEXTJOIN and Array IF Statements.

Looking at the table of data below, how would you go about looking up the order number and pulling the name of all products sold on that order into the one cell as shown in cell B19 in the image below? Looks complex right?  But not really with the use of TEXTJOIN and Array IF […]

## DAX COUNT and COUNTX – Impact of Using Measures V’s Calculated Columns

Learn the difference of using Measure and calculated columns in DAX for Power Pivot or Power BI

## Easy Excel Solutions: Power Pivot Many to Many Relationships

Learn How to Manage Many to Many Relationships in Power Pivot Power Pivot has been around since 2010, and many people still struggle with managing relationships.  Even more so most struggle with more complex relationships such as Many to Many relationships.  In fact, I have seen many people begin to set up data models in […]