Welcome to Excel Jet Consult blog post. In this Excel video, I demo how to Simultaneously Insert Blank Line after each rows and Sort Descending. If you enjoy this blog post and video, like, share, comment and subscribe to this channel Video Do watch the video below Sample Data The screenshot below shows the sample data of a sales report […]
Continue readingAuthor Archives: Abiola David
Improved Recommended PivotTables in Excel
Welcome to Excel Jet Consult blog post. This video demonstrates the newly improved PivotTables Recommendation. Like, Share, Comment and Subscribe Video
Continue readingFind and Replace Values in a Specific Column in Excel
Welcome to Excel Jet Consult blog post. In this video, I demo how to “Find and Replace Values in a Specific Column in Excel” If you enjoy this video, like, share, comment and subscribe to this channel Video
Continue readingWhy You Should Use Named Ranges in Your Excel Formulas
Welcome to Excel Jet Consult blog post. In this tutorial, I demo, “Why You Should Use Named Ranges in Your Excel Formulas.” If you enjoy this video, like share, comment and subscribe Video
Continue readingInteractively Filter Multiple PivotTable Reports and PivotCharts using Timeline
Welcome to Excel Jet Consult blog post. IN this video, I demo how to Interactively Filter Multiple PivotTable Reports and PivotCharts using Timeline. If you enjoy this video, like, share, comment and subscribe to this channel Video
Continue readingExtract All Dates Between Two Dates in a List in Microsoft Excel
Welcome to Excel Jet Consult blog post. In this video, I demo how to extract all dates between two dates from a list in #excel Video
Continue readingCalculate Hours Worked and Gross Pay using MOD Function and Formula in Excel
Welcome to Excel Jet Consult blog post. In this video, I demo how to Calculate Hours Worked and Gross Pay using MOD Function and Formula in Excel. If you like the video, give it a thump up and share with your friends Video
Continue readingGenerate Sales Summary in Pivot table using Brand New Built-in Office Script in Desktop Excel
Welcome to Excel Jet Consult blog post. In this video tutorial, I demo how to Generate Sales Summary Report in PivotTable without dataset using the built-in Office Script in the brand new Automate tab. Enjoy
Continue readingLoad Excel Data To Oracle SQL Developer Database
Welcome to Excel Jet Consult blog post. In this tutorial, I demo how to Load Excel Data to Oracle SQL Developer Database. Enjoy
Continue readingExtract and List All Sundays from 2015 to 2022 at Once
Welcome to Excel Jet Consult blog post. In this video tutorial, I demo how to extract and list all the first Sundays in 2015 to 2022 at once. Enjoy
Continue reading