Welcome to Excel Jet Consult blog post. In this short video tutorial, I demonstrated how to add, retrieve and delete records in the Excel Visual Basic for Applications Automated Database System built using codes in the user-form.

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to discover and display all the Power BI Power Query Mash-up Functions and their definitions and usage Open a blank Power Bi Desktop In the External Data group of the Home tab, click on Get Data drop-down Select Blank Query In the formula bar, execute the […]

Welcome to Excel Jet Consult blog post. In this short video tutorial, I demonstrated how to perform concatenation (joining of text string) using CONCAT function and Addition Arithmetic Operator in SQL. In addition, I demonstrated how to add suffix to a query as well as how to use LOWER function. Enjoy

Welcome to Excel Jet Consult blog post. In this video tutorial, we will learn how to write a query in SQL to fetch specific data. Thereafter, we will format numeric value using Nigerian Naira Currency symbol.

Welcome to Excel Jet Consult blog post. In this short video tutorial, I want to show us how to create database in Structured Query Language (SQL). Thereafter, we will import an Excel worksheet into the created SQL Database. Finally, we will write a query to fetch the data. Enjoy

Welcome to Excel Jet Consult. In this tutorial, we will learn how to combine SUMIFS with DATE functions to return Qtr 1 Total Sales. Let’s get started In cell H1, execute the formula: =SUMIFS(Total,Order_Date,”>=”&DATE(2015,1,1),Order_Date,”<=”&DATE(2015,3,31)) We can see from the formula above that we wrapped the DATE formula inside SUMIFS To verify, we will filter the data set to show Order […]

Welcome to Excel Jet Consult Blog post. In this short video tutorial, I want to show us how to import data from Structured Query Language (SQL) Server to Excel. Furthermore, I demonstrated how to add supplementary records in the SQL Server and have the reports updated in Excel. Do enjoy the video

Yesterday witnessed the beginning of a new dawn in world of spreadsheet occasioned by the arrival of an elegant, sophisticated and user-friendly Excel function named XLOOKUP. The new XLOOKUP function provides a strong alternative to the VLOOKUP function which has been around since 1985 when Excel 1 for Macintosh was released. Traditionally, the Excel VLOOKUP, among other limitations, is unable […]

Welcome to Excel Jet Consult. In this tutorial, we will learn how to Text.Start and Text.PositionOf Power Query M Functions which are LEFT & FIND functions in Excel Text.Start returns the first count characters of text as a text value Text.Start Syntax                              =Text.Start(text as nullable text, count as number) Text.PositionOf returns the position of the specified occurrence of the text […]

Microsoft Excel Training workshop for Director of Human Resources Management and Senior Staffs at Federal Ministry of Petroleum Resources, Abuja, Nigeria (4th Session) Date: August 24th, 2019 Time: 1 am – 6:00 pm Topics Covered How to create Table and working with Table Understanding how to use named ranges Using List Data Validation How to use Text-to-column How to use […]