Excel Lambda Function
Have you ever used VBA in Excel to create your own functions? LAMBDA allows you to create your […]
Excel
Office Scripts in Excel
What are Office Scripts? Office Scripts in Excel let you automate tasks. You can create and edit scripts […]
Excel Sorting
Sorting a list or set of information can be straightforward or more complex. In Excel, you can sort […]
Excel’s VLOOKUP Function
Use VLOOKUP when you need to find things in a table or a range by row. For example, […]
Excel COUNTIF Function
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for […]
Number Transformations
Number transformations in Power Query are simple to do, but there is something you need to watch out […]
Remove Duplicates
In Power Query it is easy to remove duplicates. There is however something to be aware of. Power […]
Fill and Replace Values
There are times when you need to clean your dataset. Suppose you had a simple table of employees […]
Allocate Data into Buckets or Groups
Suppose we have a table of data that lists employees and their annual salaries. We want to create […]
Split Column by Delimiter
In Power Query transformations, the split column by delimiter has something that you need to be aware of. […]
Text Transformation in Power Query
This post covers a few common text transformations in Power Query. When you are working with a column, […]
Power Query Transformations
Power Query is part of Microsoft Excel. It’s a powerful tool that can help you with repetitive tasks. […]