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

How To Apply Icon Sets New Rule Conditional Formatting In Power BI

Conditional Formatting allows users to highlight values using colours, bar, icons and scales. Using Conditional Formatting adds the touch of professionalism to reports. Over in Excel, Conditional Formatting is located in the Styles group of the Home tab. However, in Power BI, it is located Format. In this exercise, we have a report that we wants to add Icon Sets […]

Continue reading

How To Magnify Values in Power BI

By default, when user drag any field into the white canvas of the Power BI Report view, the field automatically display the values using 8 pt Text Size which, more often than not, is not readable. See below Therefore, to increase the Text size to something more readable: Select the visualization Under Format, locate Values Scroll down and locate Text Size Increase […]

Continue reading

How To Use REPLACE, SEARCH, LEFT & CONCAT Functions To Transpose Values in Structured Referencing

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to user REPLACE, SEARCH, LEFT & CONCAT functions to transpose values located from middle to the left, right to the middle and left to the right (i.e. Larry, Gill Taylor to Gill Taylor Larry) . This operation can be performed easily by using the Flash […]

Continue reading

How To Create Custom List In Excel 2019 Version – US States As An Example

Microsoft Excel enables users to create desired custom list that can be auto filtered. In this blog tutorial, we have 50 States in the United States that we want to use as the criteria to create custom list. After creating the custom list, we will test whether its working or not. Let’s get started! In the caption below, we have […]

Continue reading