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 […]

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 […]

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, […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to replace empty cells in our data set with zero (0) in VBA. Let’s get started In the caption below, we notice that there quite a few of empty cells in columns C:F. Essentially, we are going to write a VBA code that will automatically […]