Power query is awesome! Here are some tips and tricks to help you get the most out of this amazing data transformation tool.Read More
It’s often the case that workbooks get very large and end up with a lot of sheets. Excel...Read More
Data Validation is a very useful Excel tool. It often goes unnoticed as Excel users are eager to learn the highs of PivotTables, charts and formulas.
It controls what can be input into a cell, to ensure its accuracy and consistency. A very important job when working with data.Read More
You’ve probably come across data that looks something like this before. It’s usually...Read More