Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn about 8 different methods to convert numbers stored as text to actual numbers in Excel. Let’s get started. Sample Data We have a size-able sample data in the caption below. In column B, there is Sales Amount stored as text. Essentially, we want to use […]
Continue readingSum of Digits Across Multiple Columns using LET Function
Welcome to Excel Jet Consult blog post, In this blog post, we learn how to use the LET Function in collaboration with other functions to sum digits across multiple columns. Enjoy and also watch the video Sample Data In the caption below, we have List of Fruits & Vegetables in column A. In columns B to E, we have the Quantity Sold […]
Continue readingRearrange Slides using Slide Sorter
Welcome to Excel Jet Consult blog post. In this short video PowerPoint tutorial, we learn how to easily rearrange slides in our presentation using Slide Sorter. If you enjoy the video, be kind to give some likes and subscribe to my YouTube channel. Cheers!
Continue readingSearch for Records in Excel VBA Userform
Welcome to Excel Jet Consult blog post. Building a robust and responsive database system in Excel VBA requires technical know-how is writing appropriates codes. In this video, I show us how to write VBA codes that enables searching of records in VBA userform.
Continue readingVLOOKUP & INDEX/MATCH Inside Conditional Formatting
Welcome to Excel Jet Consult. In this blog post, we will learn how to use VLOOKUP & INDEX/MATCH Inside Conditional Formatting. Let’s get started Video You can watch the video of this tutorial below. Do subscribe to my YouTube channel for more videos Sample Data In the caption below, we have Date, Items, States and Actual from columns A to […]
Continue readingGenerate 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 readingSheet View in Excel for Microsoft 365
Welcome to Excel Jet Consult blog post. In this video tutorial, I show us how to use the new Sheet View for interrupted collaboration in Excel for Microsoft 365. Enjoy the video and remember to subscribe to my YouTube channel: www.youtube.com/born2begrait
Continue readingEnabling 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 readingSplit 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 readingMultiple 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