Women in Excel You Need to be following
Awesome Women in Excel you need to be following
Awesome Women in Excel you need to be following
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
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 […]
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 […]
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
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 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 […]
Learn the difference of using Measure and calculated columns in DAX for Power Pivot or Power BI
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 […]