Use power query to transform a single column into a table.
Transform a Column to a Table with Power Query
read more
All Posts
How To Automate Sorting, Hiding, Unhiding and Listing Your Sheets
It's often the case that workbooks get very large and end up with a lot of...
How To Get All Sheet Names From All Workbooks In A Folder
It's a task I've had to do before. Get a list of all the sheet names in a...
Everything You Need to Know About Excel Tables
Learn everything there is to know about Excel Tables. This post will tell you about all the awesome features Excel Tables have and why you should start using them.
11 Awesome Examples of Data Validation
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.
How To Combine And Unpivot With The Pivot Table Wizard
You've probably come across data that looks something like this before. It's...
Get the Latest Microsoft Excel Tips
Follow Us
Follow us to stay up to date with the latest in Microsoft Excel!
Subscribe for awesome Microsoft Excel videos 😃
