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

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

In this blog post, we want to learn how to use one of the most powerful but rarely-known technique in Microsoft Excel called Group Sheet. We will use the technique with SUMIFS function to pull across the Total sales for Account Managers based on Quarter 1, Quarter 2, Quarter 3 and Quarter 4 for years 2013 to 2016. We will […]

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use Power Query (Get & Transform) to concatenate and add suffix. The data below will be used for this tutorial The first thing we wants to do is to load the data into the Power Query Editor To do that: Click anywhere inside the data […]

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates, undergraduates, small business owners at Federal University of Technology, Owerri, Nigeria (4th Session) Date: June 28th, 2019 Time: 1pm – 5pm Topics covered Understanding how to use named ranges How to use Data Validation How to use Text-to-column How to use SUMIFS, AVERAGEIFS, MAXIFS & MINIFS Functions Data […]

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates, undergraduates, small business owners at Federal University of Technology, Owerri, Nigeria (3rd Session) Date: June 28th, 2019 Time: 9am – 12pm Topics covered 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 […]

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates, undergraduates, small business owners at Federal University of Technology, Owerri, Nigeria (1st Session) Date: June 27th, 2019 Time: 9am – 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 […]

Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates, undergraduates, small business owners at Federal University of Technology, Owerri, Nigeria (1st Session) Date: June 27th, 2019 Time: 1pm – 5pm 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, […]

The Excel Get & Transform enables users to perform  SnowFlake merging otherwise known as VLOOKUP in Power Query. SnowFlake merging entails using foreign keys in Fact Table to connect to corresponding unique foreign keys in Dimension Tables to ultimately retrieve sets of values required for further analysis In the pictures below, we wants to load the Fact Table and Dimension […]

Welcome to Excel Jet Consult blog post. In this post we want to learn how to change the order of data using the TRANSPOSE array function. TRANSPOSE Function converts a vertical range of cells to a horizontal range or vice versa. TRANSPOSE Syntax                         =TRANSPOSE(array) We want to transpose the data in the caption below To transpose, we will select corresponding […]