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

Second Article on a two part series – Learn how Machine Learning Works with this Simple Explanation of Machine Learning shown with Excel

Skip to content
## Simple Explanation of Machine Learning shown with Excel – Part 2

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

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

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

## Simplifying Joining of Text in Excel

## No More Complex Nested IF Statement with the use of IFS

## Power BI – Connecting to tables on a website and transforming that data

## Analyzing a Blockchain Database with Power BI – Introducing SteemitSQL

## Easy Excel Lessons – Transposing Data and Converting Text to Columns

## DAX – FILTER inside CALCULATE

Second Article on a two part series – Learn how Machine Learning Works with this Simple Explanation of Machine Learning shown with Excel

Every wondered how Machine learning works? In this 2 part article we are going to explain machine learning with Excel Introduction The world is full with a lot of data, pictures, music, text, video, spreadsheets. Machine learning brings the promise of delivering meaning from that data. Human’s learn from experience. if we touch something […]

Like z-tests, t-tests 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 means of two groups is unlikely to […]

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 how to use Excels Ampersand, concatenate, concat and textjoin functions

Nested IF statements are the thorn is the side of many Excel users. They can become long complex formula that are difficult to both read and write. However, if you have been using Excel 365 one of the new functions available is IFS. Now this function is also available in Excel 2019 Standalone as a […]

CLICK HERE TO LEARN HOW TO DO THIS IN EXCEL WITH POWER QUERY Connecting to data sources and transforming data into a useable format can be complex, even when you are using a powerful tool like Power BI. I know many people that have started a transformation only to give up because they are not too sure […]

Sometimes it can be difficult to find a good data set to analyse. Kaggle offer data sets and run competitions on analysis and Microsoft also offer sample data sets such as World Wide importers. But sometimes a completely different data set is really cool to explore. Over the last few weeks I have been using […]

Transposing Data This worksheet shows sales for each salesperson by month: Let’s say that you want to have the months appear as columns, while the sales associates appear as rows. Making this change manually would be a very time consuming process, but luckily Excel 2013 has a way to swap this data for you. To […]

CALCULATE in DAX is such a powerful and complex function to fully understand. In essence what CALCULATE will do is modify the current filter context. And it does this by evaluating both the current filter context and the filters applied by CALCULATE. The syntax for CALCULATE is: =CALCULATE ([Expression], filter1, filter2…..) So if CALCULATE contains […]