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

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

Welcome to Excel Jet Consult blog post. In this video tutorial, we learn how to use the newly released STOCKHISTORY Function to fetch historical stock records. Enjoy and remember to subscribe to my YouTube channel  

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

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn one of the most unique way of extracting numbers from alphanumeric values using multiple functions. Let’s get started For more explanation, kindly watch the video below   Sample Data In the caption below, we have alphanumeric values in column A formatted in an Excel Table. […]