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

Continue reading

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

Continue reading

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

Continue reading

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

Continue reading

Rule Governing Data Import from Excel 365 & 2019 Versions To SQL Server Native Client 11.0

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to successfully import Table from Excel workbook to SQL Server Client 11.0 In the caption below, we want to import the Data from the Sample – Superstore Excel workbook. Having created a database in our SQL Server named Excel_Sample Right-click on Excel_Sample database Select Tasks and […]

Continue reading