Generate Random List using RANDBETWEEN & FILTER Functions in Excel

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we learn about how to generate random number using the RANDBETWEEN & FILTER Functions in Excel. Let’s get started Tutorial Video You can watch the video below for more in-depth explanation. Remeber to subscribe to my YouTube channel for more videos Sample Data In the caption below, we have […]

Continue reading

Enabling All Object such as Charts, Pictures, Shapes, Icons, Slicer & Timeline in Excel

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to look at how to enable all what is considered as objects in Microsoft Excel such as Charts, Text Box, Pictures, Icons, Slicers, Timeline, etc. Let’s get started You can watch the short video below In the caption below, we have a sample data we’d like to […]

Continue reading

Split Text using Multiple Functions

Welcome to Excel Jet Consult blog. In this tutorial, we will see how to split text using multiple functions. In part one, we saw how to split text using the rarely known FILTERXML Function. We will use the same data-set and achieve the same outcome in this blog post. Let’s get started Video Kindly watch the video for in-depth explanation […]

Continue reading

Multiple SUBSTITUTE Function To Replace Square Bracket with Single Pipe

Welcome to Excel Jet Consult blog post. In this tutorial, we going to see how to substitute square brackets with single pipe. Let’s get started   SUBSTITUTE Function The SUBSTITUTE Function replaces existing text with new text in a text string Syntax:         =SUBSTITUTE(text, old_text, new_text, [instance_num])   Sample Data In the caption below, we have Account Manager’s […]

Continue reading

Total Working Days Excluding Weekends & Holidays using Power Query

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to calculate total working days excluding weekends and holidays using Power Query. Let’s get started Tutorial Video I recommend you watch the video for more in-depth explanation Sample Data In the caption below, we have list of dates from 01/01/2020 to 31/12/2020 in column A. In […]

Continue reading

Conditional Formatting: Highlight Rows using ISEVEN & ISODD Functions

Welcome to Excel Jet Consult blog post. In this tutorial, we will see how to conditionally format entire row using the ISEVEN & ISODD Function   ISEVEN and ISODD Functions ISEVEN Functions returns TRUE if the number evaluated is even Syntax:                       =ISEVEN(number) ISODD Functions returns TRUE if the number evaluated […]

Continue reading

Extract Numbers From Alphanumeric Values using Dynamic Array Functions

Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to extract numbers from alphanumeric values using FILTER and SEQUENCE Dynamic Array and other functions. We also see how to use use another set of functions to achieve the same functions. To watch the previous post, click on the link For more explanation, kindly watch the video […]

Continue reading