Learn to use VLOOKUP in Excel

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 […]

Simple Explanation of Machine Learning shown with Excel – Part 1

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 […]

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

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 […]

TEXTJOIN and Array IF Statements

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 […]

No More Complex Nested IF Statement with the use of IFS

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 […]

Easy Excel Lessons – Transposing Data and Converting Text to Columns

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 […]

Learn how to Group Data in Excel and use Subtotals

Grouping Data Last week we looked at the Outline feature in Excel. While the automatic outlining capabilities in Excel 2013 work very well with numerical data, it is not so effective when working with non-numerical values or data that has no distinctive totals. Luckily, you have the option to manually group data in Excel. In […]

Its rather simple to use the Outline feature in Excel

The Outline Feature in Excel Excel’s automatic outlining feature makes outlining a worksheet easy. Automatic outlining works best with numerical data organized into groups and sub groups by formulas or functions. For example, the sample image below contains monthly sales data, organized into quarterly and yearly totals using formulas: As you can see, it can […]