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

Microsoft Excel Training @ Federal University of Technology, Owerri, Nigeria (4th Session)

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

Continue reading

Microsoft Excel Training @ Federal University of Technology, Owerri, Nigeria (3rd Session)

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

Continue reading

Microsoft Excel Training @ Federal University of Technology, Owerri, Nigeria (1st Session)

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

Continue reading

Microsoft Excel Training @ Federal University of Technology, Owerri, Nigeria (2nd Session)

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

Continue reading

How to Perform SnowFlake Merging in Power Query

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

Continue reading