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.
Continue readingDiscover & Display All The 919 Power BI Power Query Mash-up Functions
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 […]
Continue readingConcatenation using CONCAT Function & Addition Arithmetic Operator in SQL
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
Continue readingHow to Format Numeric Values in Nigerian Naira Currency Symbol in SQL
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.
Continue readingHow to Create SQL Database & Import Data from Excel to SQL
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
Continue readingSUMIFS Combined with DATE Functions
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 […]
Continue readingHow to Export Table from SQL Server To Excel
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
Continue readingXLOOKUP Function – New Elegant Lookup Function
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 […]
Continue readingPower Query M Functions: Extracting using Text.Start & Text.PositionOf
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 […]
Continue readingMicrosoft Excel Training @ Federal Ministry of Petroleum Resources, Abuja, Nigeria (4th Session)
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 […]
Continue reading