Data Analysis and Visualization Hacks in Excel Let’s explore 2 amazing data analysis and visualization hacks in Excel. Quick Analysis and Ideas. Very often when working with data, you will receive an Excel workbook and have no idea what the data is about. Or, what stories are hidden within it. To perform a detailed analysis, […]
The Z-Score is used to compare items with different units of measurements. In Excel Z-scores can be quickly calculated using Standardize
The CHOOSE function in Excel is very versatile. It can be used as a lookup and it can be combined with many other functions that make it extremely useful. “Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the index […]
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 […]
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