Solving Complex Lookup using Power Query
Mastering Power BI Pro (Basic to Advance) Demo conducted on 04-Oct-2023 by Rakes...
Find all Invoices matching Total Amount
Dependent Data Validation with VLookup
EXCEL Sumproduct Practical Example
Convert Date (with New Line/Enter Key) Correctly
Avoid Duplicates using VBA while Form Entry
Travel Time Calculator in Excel
Text Sub Numbering using Power Query & Excel Formulas
Distribute Fees Installments in Months
071 Min and Max by Criteria
Split Text with and without using Excel Lambda Formulas
Identifying Maximum within Group (Using Power Query)
062 Finding First greatest amounts date using Index, Match & Array Concept...
GetWeek Noof a given Month
Disable Sheet Addition button
Show all matching items together by finding inside Text using Power Query
Performing Calculations using VBA UDF
Transformation solution using Power Pivot
Transforming Data using Power Query (Small but useful practical example)
Mission Impossible solved using Power Query
Dealing with New Columns for File Consolidation in Power Query
Power Query Complex & Advanced Example
053 All Corresponding Values should be same
Solving Electric Current Puzzle using Excel VBA
Split by Invisible Character Line Feed using PowerQuery
Text to Column (Split Invisible Characters)
049 Effecient Working, Scrapping Old Lenghty formulas with sime ones
048 Average of Time from Mix text using Array Formula
Creating Bins from Data & Time data every 6 Hours
Filter Data for Multiple Column Criteria using VBA (By Mohammad Shabbir)
Get Sheets from Files in Single File using Excel VBA
Compare Current with Previous (Non Consecutive) days Payment
Understanding Calculate DAX Function in Power BI
Show only Forecast using VBA and PowerQuery
Getting Last Code in Sequence
Power Query First and Last Row
Show Chart from Date Range Selected by User (Simplest Way)
Microsoft Access मैं टेबल और फॉर्म बनाएं
Financial Year (Excel Formula)
Convert unorganized data to tabular data using Power Query
Get Unique City in case of Same City Repeatation
Last Lookup in case of Duplicate Data in Excel
Solving Problem using Power Query
Conditional Concat using Power Query
Conditional Concate using UDF
AFCKS Technologies