Excel is an amazing tool that can do so much, from keeping basic lists to more complex data analysis and visualizations. In this article today you are going to learn 4 Excel tips that will make your life easier and you more efficient in Excel. In this article we are going to look at Simple […]
In a previous article we covered The Basics of VLOOKUP. VLOOKUP is a very versatile function that can be combined with other functions. When you learn to combine VLOOKUP with with other functions it makes it super powerful. In this article we will look at combining VLOOKUP with TEXT functions. Lets quickly refresh some basics […]
To Parse Custom JSON data is to split out its name/value pairs into a more readable useable format. Excel is a powerful tool that allows you to connect to JSON data and read it. However sometimes this data might require a little manipulation to be fully understood and analysed in Excel. In this article you […]
The VLOOKUP and HLOOKUP formula in Excel allow you look up a value in one column or row and return a corresponding value from a different column or row. VLOOKUP is a vertical lookup and HLOOKUP is a horizontal lookup The table of data below contains 4 columns. A Product Number, the Supplier, the quantity […]
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 […]