Weather Forecast: How to Apply Degree Symbol using AltGr Key

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to apply degree symbol to weather forecast figure using a modifier key called AltGr. Let’s get started In the caption below, we have a list of City/States in Nigeria with their respective weather forecast. What we want to do is basically to display the numbers in […]

Advanced Group By in Power BI Power Query For Calculation

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the Advanced Group in Power BI Power Query to calculate the Total by Region and Item Type. Let’s get started The caption below shows the data already loaded to the Power BI Power Query In the Table group of the Transform tab, click on […]

SUMIF in Power Query

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to perform SUMIF in Power Query. First and foremost, we will calculate Total for each Region using the traditional SUMIF function in Excel. Thereafter, we will do the same using Power Query approach. Let’s get started.   SUMIF Function adds all numeric values in a range […]

Nesting MATCH Function Inside OFFSET Function For Dynamic Calculation

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to combine MATCH function with OFFSET Function OFFSET Function returns a reference to a range that is a given number of rows and columns from a given reference OFFSET Syntax                                  =OFFSET(reference, rows, cols, [height], [width]) MATCH Function returns the relative position of an item in […]

How To Hide ALL Sheet tabs In Excel

Welcome to Excel Jet Consult. In this tutorial, we will learn how to hide all sheets from the Excel options dialogue box. Let’s get started In the caption below, we have seven sheet tabs we want to hide. To hide all the sheet tabs: execute Alt + FTA Scroll down and uncheck Show sheet tabs Click OK In the caption […]

Learn how to use the volatile OFFSET function combined with SUMIFS

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use of the most rarely known and volatile Lookup functions called OFFSET combined with SUMIFS function. Let’s get started OFFSET Function returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference […]

How To Automate Repetitive Tasks Using Macro

Welcome to Excel Jet Consult blog post. In this video tutorial, we will learn how to automate repetitive tasks using Macro. Let’s get started

User Interface for Sales Transaction in Excel VBA

Welcome to Excel Jet Consult blog post. In this video tutorial, we will learn how to create User Interface for Sales Transaction in Excel VBA. In the next video tutorial, we will bring life to the UI by writing codes. Enjoy