Summing Every Third Rows Across Multiple Columns

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to sum every third rows across multiple columns. Let’s get started Sample Data In the caption below, we have our sample data we will use to achieve the technical calculation. Note, our data is formatted in Excel Table and we provided Sales_Data as the Table Name Calculation […]

Continue reading

Modelling Using New LET Function

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn about how to use the newly released LET Function for modelling. Let’s get started Definition of Function & Syntax The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET […]

Continue reading

How To Embed YouTube Video in Excel Workbook

Welcome to Excel Jet Consult blog post. In this tutorial, I will show us how to Embed YouTube Video in Excel Workbook. Let’s get started Steps Open the workbook to embed the video In the Add-ins group of the Insert tab, click on Get Add-ins In the Office Add-ins dialogue box, locate Web Video Player and click on Add and Continue In the caption below, we have the Web Video Player […]

Continue reading

How To Refresh PivotTable using VBA

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to refresh PivotTable using VBA. Let’s get started In the caption below, we have a sample data to the left and the supplementary data to the right. Note, the data is formatted in Excel Table. So, when we add the supplementary data to the main data, […]

Continue reading

Office 365 Insider: In-cells Data Types

In this video tutorial, I talked about the new feature recently discovered in Officer 365 Insider. I called the new feature as In-cells Data Types. The new features enables users subscribed to Insider to easily type in at least 3 recognizable Stock Tickers in three contiguous cells to be able to generate more information. This same rule applies to Geography

Continue reading

Office 365: Enabling Office Scripts

Welcome to Excel Jet Consult blog post. In this tutorial, we want to see how to enable Office Scripts in the Microsoft 365 Admin Center. Office Scripts allows users to automate repetitive tasks and it is currently in preview for Excel on the Web. If you’re working in an organization, you may have to contact the IT department to perform […]

Continue reading

Advanced: SUMPRODUCT with MID, LEFT & FIND Text Functions

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use advanced method to sum values using combination of MID, LEFT & FIND Text Functions. Let’s get started Sample Data In the caption below, we have sample data We want calculate the Total for Account Manager whose First Name is David and Country of operation is Nigeria. Based […]

Continue reading

Activate Developer Tab

Welcome to Excel Jet Consul. In this tutorial, we want to see how to activate the Developer tab. Let’s get started To activate the developer tab, right-click on any of the tabs such as Home, Insert or any other Select Customize the Ribbon In the Excel Options dialogue box, check Developer Click OK. We should be able to see the […]

Continue reading