The XLOOKUP function in Excel does not perform a case sensitive match by default. So, the values “London”, “LONDON”, and “london” would all result in a match with the XLOOKUP function. So, how do you perform a case sensitive XLOOKUP formula? Let’s find out. Read on or watch the video tutorial. XLOOKUP does not Perform […] The post Case Sensitive Lookup with XLOOKUP in Excel appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more

There are two main reasons you should consider aggregating rows in Power Query: creating a pivot-style report or reducing the number of rows and the granularity of your data without writing complex formulas. This tutorial will teach you how to aggregate rows in Power Query, exploring how to aggregate both numeric and text values. Download […] The post Aggregate Rows in Power Query appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more

When using formulas in tabular data in Excel, you will need to copy a formula down the entire column, so that each row has that same formula. There are a few techniques to copying formulas in Excel, and this article will detail what you should be aware of, and why you would apply each specific […] The post How to Copy a Formula Down in Excel appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more

A frustration with PivotTables in Excel is the automatic resizing of column widths that occurs when a PivotTable updates. This often happens when a PivotTable is refreshed or filtered. Let’s look at how to stop PivotTable columns resizing for specific PivotTables, and how to change the default behaviour and stop the PivotTable column widths changing […] The post Stop PivotTable Columns Resizing appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more

The rich data types make it easy to get a live currency exchange rate in Excel. You can then convert currencies with an Excel formula that updates when the exchange rate changes. Define the Currency Exchanges Firstly, you need to enter the currency codes for the currencies that you want to convert separated by either […] The post LIVE Currency Exchange Rate in Excel appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more

This tutorial will return non-adjacent columns with the FILTER function. Dynamic array functions such as FILTER and SORT can only return consecutive columns natively. However, there are various methods to specify the columns to return from the array. Functions such as CHOOSECOLS, CHOOSE and INDEX are wonderful for this task. You can download the Excel […] The post Non-Adjacent Columns with FILTER Function appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more

This tutorial will look at how to calculate moving average in Excel. The moving average is sometimes referred to as the rolling average as it averages the values from a rolling, or moving, date range. In this post, our focus is on a seven-day moving average. You can download the Excel workbook used in this […] The post Moving Average in Excel appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more

The IMAGE function in Excel enables us to return an image to a cell using an Excel formula. This function makes it easy to lookup images based on a cell value, and because the image is stored in the cell, it is returned when sorting and filtering, and when using other functions such as XLOOKUP, […] The post Excel IMAGE Function – Insert Images from a Cell Value appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more

In this tutorial, we will introduce you to the fabulous SEQUENCE function in Excel along with two ‘real world’ examples of its use. The SEQUENCE function is a dynamic array function and is only available in Excel 365, Excel 2021 and in Excel Online. When you first see the SEQUENCE function, it is maybe not […] The post SEQUENCE Function in Excel appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more

In this tutorial, we see how to sort by drop down list in Excel. We have a table containing details about pizza and their performance such as the feedback rating, how many have been sold and the % change from the previous pizza data. We want to be able to select the column to sort […] The post Sort by Drop Down List in Excel appeared first on Microsoft Excel Tips and Tricks - Computergaga ..read more