Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. Here are some tips and tricks to help you get the most out Power Query.Read More
Category: Tips & Tricks
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
Excel has a cool feature called the Quick Access Toolbar (QAT) that allows you to add your own...Read More
Get The Completed Workbook Excel allows a variety of date formats and depending where you’re...Read More
These are keyboard shortcuts for moving the active cell around a selected range of cells....Read More