XLOOKUP 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 reading

Power 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 reading

Microsoft 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

Microsoft Excel Training @ Federal Ministry of Petroleum Resources, Abuja, Nigeria (3rd Session)

Microsoft Excel Training workshop for Director of Human Resources Management and Senior Staffs at Federal Ministry of Petroleum Resources, Abuja, Nigeria (3rd Session) Date: August 24th, 2019 Time: 10 am – 12:00 pm Topics Covered How to Calculate Retirement Date By Years in Service & Date of Employment Create Pivot Table Working with Pivot Tables Field List Tabular Pivot Table […]

Continue reading

Microsoft Excel Training @ Federal Ministry of Petroleum Resources, Abuja, Nigeria (1st Session)

Microsoft Excel Training workshop for Director of Human Resources Management and Senior Staffs at Federal Ministry of Petroleum Resources, Abuja, Nigeria (1st Session) Date: August 23rd, 2019 Time: 10 am – 12:30 pm Topics Covered Introduction to Excel General Excel Formatting Freezing Panes and Splitting windows Using Arithmetic Operators in formulas Using SUM, AUTOSUM, AVERAGE, MAX, MIN Functions How to […]

Continue reading

Microsoft Excel Training @ Federal Ministry of Petroleum Resources, Abuja, Nigeria (2nd Session)

Microsoft Excel Training workshop for Director of Human Resources Management and Senior Staffs at Federal Ministry of Petroleum Resources, Abuja, Nigeria (2nd Session) Date: August 23rd, 2019 Time: 1:30 pm – 4:30 pm Topics Covered Working with multiple sheets How to use Group Sheet Technique to perform various operations Performing calculation using convention method and 3D Reference Using CONCATENATE, LEFT, […]

Continue reading

Microsoft Excel Training @ Rose of Sharon Foundation, Lagos, Nigeria (2nd Session)

Microsoft Excel Training workshop at Rose of Sharon Foundation, Lagos, Nigeria (1st Session) Date: May 18th, 2019 Time: 1 pm – 5pm Create Pivot Table Working with Pivot Tables Field List Tabular Pivot Table Report How to Report Pivot Table Filter Pages Pivot Charts Working with Pivot Charts VLOOKUP, INDEX/MATCH Functions How to create Table and working with Table Understanding […]

Continue reading

Power Query M Functions: Extract Data Using Combination Of Text.Middle & Text.PositionOf

Welcome to Excel Jet Consult blog. In this short tutorial, we will learn how to extract values using Power Query M Functions. Power Query is a data connection technology that enables users to discover, connect, combine and transform data sources to meet specific needs. We will use Power Query. We want to extract the Regions such as WestEast from List […]

Continue reading

Microsoft Excel Training @ Rose of Sharon Foundation, Lagos, Nigeria (1st Session)

Microsoft Excel Training workshop at Rose of Sharon Foundation, Lagos, Nigeria (1st Session) Date: May 18th, 2019 Time: 10am – 12pm Topics covered Introduction to Excel General Excel Formatting Freezing Panes and Splitting windows Using Arithmetic Operators in formulas Using SUM, AUTOSUM, AVERAGE, MAX, MIN Functions How to Center Across Selection Performing Across Sheet Reference Enabling Nigeria Naira Currency Symbol […]

Continue reading

How to Create Indentation In DAX Formula

Indentation is a convention governing the indenting of blocks of code or syntax to convey specific program structure. As it is peculiar to other programs such as Python, R, SQL among others, Power BI enables user to indent DAX formulas. In the picture below, we want to learn how to indent the Date Table that contains CALCULATE, DATE, YEAR, MIN […]

Continue reading