Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to hide all data across multiple sheet tabs using semicolon. Let’s get started We want to delete all the data at once in the three sheet tabs of the caption below In Data sheet tab, hold down the SHIFT key and click on the Unpivot sheet […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn about Advanced Custom Text Formatting: Adding Suffix & Prefix. Let’s get started In the caption below, we want to generate email address for the Account Managers by adding the following suffix @exceljetconsult.com.ng. Note, we are going to extract the first names (i.e Stevenson, Sweed etc.) into column […]

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

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

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

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

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

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

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  

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