Welcome to Excel Jet Consult blog page. In this video, I demonstrated how to use the UNIQUE Dynamic Array function. Enjoy the video
Continue readingPrinter Setup using Excel VBA
Welcome to Excel Jet Consult blog post. In this short video tutorial, I demonstrated how to setup printer using Excel VBA. Enjoy the video
Continue readingPlay Axis Dynamic Slicer
Welcome to Excel Jet Consult blog post. In this video tutorial, I demonstrated how to use the Power BI Play Axis Dynamic Slicer custom video.
Continue readingCalculating Fiscal Quarter in Power BI
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to calculate Fiscal Quarter. Let’s get started. To learn how to create Standard Quarter using different methods, click here Fiscal Quarter In this example, the Fiscal Quarter starts from July of the current year and ends in June of the next year. This invariably implies […]
Continue readingPower Query: Calculate Age in Years and Months
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to calculate Age in years and month in Power Query. Let’s get started In the caption below, we have our data loaded into the Power Query editor In From Date & Time group of the Add Column tab, click on Date drop-down and select Age In […]
Continue readingPower Query: Split Date and Time into Separate Columns
Welcome to Excel Jet Consult blog. In this tutorial, we want to learn how to split Date and Time using Power Query. Let’s get started. In the caption below, we have a Date & Time data in column A with Date Format: mm/dd/yyyy Format Data as Excel Table Since we want to work with Power Query, the first thing we […]
Continue readingCopy Sheet Between Workbooks in Excel Way
Welcome to Excel Jet Consult blog post. In this tutorial, we will see how to copy sheet from one workbook to another. Let’s get started. Usually, many users select all the cells in a sheet using CTRL + A or the Rows and Columns intersect below Name Box and execute CTRL + C. Then, in the other workbook, they execute […]
Continue readingUSERELATIONSHIP DAX Function
Welcome to Excel Jet Consult blog post. In this tutorial we want to learn how to use the USERELATIONSHIP Dax Function. Let’s get started USERELATIONSHIP Function specifies the relationship to be used in a specific calculation as the one that exists between columnName1 and column Name2. Note, the relationship can be deployed with functions that take filter as an argument. […]
Continue readingImport SQL Server Table Directly
Welcome to Excel Jet Consult. In this video tutorial, I demonstrated how to import table from SQL Server directly into Power Query. Enjoy the short video.Import SQL Server Table Directly from Power Query
Continue readingMicrosoft MVP from Africa Dashboard (as at Jan, 2020)
Welcome to Excel Jet Consult blog post. Happy New Year. In this video tutorial, I shown how to use Power Query, Power Pivot and PivotTable to prepare dashbaord of all active Microsoft MVP from Africa as at Jan, 2020. Do enjoy the video and subscribe to my Youtube channel for more insightful videos in 2020.
Continue reading