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

How to Transpose Across Sheet In Excel

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

Continue reading

Reporting Filter Pages in Pivot Tables

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use of the rarely known Pivot Tables button called Show Report Filter Pages. Show Report Filter Pages allows us to create separate reports in new sheets based on the selection in the Pivot Tables Filters. This is one of the features in Pivot Tables that […]

Continue reading