Welcome to this Microsoft SQL Server video tutorial, we will learn how to calculate Total Revenue by Brand. If you enjoy the video, like, comment, share and subscribe to the channel Video Dataset In the caption below, we wrote a simple select all statement that returned all the columns from the specified table Query to Retrieve Total Revenue by Brand […]

Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we learn how to track Forbes Most Powerful Person Birthday Status for 2021 using the new IFS Function. Remember to hit the subscribe and bell icon buttons because there is a lot to come. Video Sample File In the caption below, we have list of Forbes Most Power […]

Welcome to Excel Jet Consult blog post. In this Excel tutorial, we learn how to use MID & SEARCH Text Functions inside SUMIFS plus Data Validation to create a dynamic report. If you enjoy the video and tutorial, like, share, comment and subscribe to the YouTube channel. Video Sample Data In the caption below, we have Sales Data formatted as […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to retrieve single and non-contiguous multiple columns in MS SQL Server Database Table. Enjoy the video      

Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to connect and import data from Excel to SQL Server. Enjoy the video  

Welcome to Excel Jet Consult blog post. In this video, I demonstrate how to create combo chart in PowerPoint using a specially prepared data in Excel. Enjoy and subscribe to the YouTube channel Watch the video in the link below: #Excel #ComboChart #PowerPoint

Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to write Recursive LAMBDA with Structured Reference. Enjoy the video.  

Welcome to Excel Jet Consult blog post. In this video tutorial, we looked at using Excel and Tableau BI technologies to calculate Total Sales. If you enjoy this video, hit the subscribe button and the bell icon for more videos.  

Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to use array constants with VLOOKUP in Excel and Google Sheets. Enjoy the video.  

Welcome to Excel Jet Consult blog post. In Part 2 of creating Calculator in Excel VBA, I walked us through the journey of how to write lines of codes that enables the calculator to be fully functional. Enjoy the video, subscribe, share and like