Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to convert DateTime to Date in SQL Server. Let’s get started Often time, when we import data from Excel to SQL Server that has Date, the Date Excel column will automatically be displayed as DateTime column in SQL. In the first caption below, we discovered that […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to successfully import Table from Excel workbook to SQL Server Client 11.0 In the caption below, we want to import the Data from the Sample – Superstore Excel workbook. Having created a database in our SQL Server named Excel_Sample Right-click on Excel_Sample database Select Tasks and […]

Welcome to Excel Jet Consult blog post. In this post, we will learn how to calculate Cumulative Sum (Running Total) in Excel, Power BI and Structured Query Language Server. Enjoy the video and comment below

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn what is circular reference in Excel, how to trap cells that has Circular References, how to identify cell with Circular References and fix approximately A Circular References is a formula that refers to its own cell directly or indirectly which result to an infinite loop. A workbook […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to enhance disk space by managing data catch in Power Query. Each time we load data into the Power Query, Excel automatically copies and stored the query preview results on our local disk space which is handy for a quick view later. However, user can clear […]

Welcome to Excel Jet Consult blog post. In this blog post, we want to learn how to calculate the difference between two dates using INT DAX Function. Let’s get started INT DAX Function rounds a number to the nearest integer Syntax                                  =INT(<number>) In the caption below, we want to create a DAX Calculated Measure that will handle the difference […]

Welcome to Excel Jet Consult blog post. In this tutorial we will learn how write numbers in Roman Numerals. Let’s get started. ROMAN Function converts an Arabic numeral to Roman as text ROMAN Syntax                 =ROMAN(number, [form])   In the caption below, we want to display all the numbers in column A in Roman Numerals In cell B2, execute the formula: […]

Welcome to Excel Jet Consult. In this blog post, we want to learn how to fetch all the information for African countries using the Geography Data Type. Let’s get started Note that this feature is only available to Office 365 users and there must be internet to use the new features. Geography data type is in the Data Type group […]

Welcome to Excel Jet blog post. In this post, we want to learn how to extract data from Text File to Power BI. Let’s get started. We want to extract the African Countries and their population as at 2019 from the text file as seen in the caption below In the Power BI Desktop, click on Text/CSV from the Get […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the DSUM, SUM, SUMIF & SUMIFS Function in Excel VBA. Enjoy the video