If you have data that are not in an Excel format, but need to be imported into an Excel spreadsheet, consider using Power Queries (also known as Get & Transform Data). Power Queries allow you to import data into Excel from external sources — like websites, databases, and even photos — alleviating potential formatting issues and the need for manual input.

Watch our latest TipUp to learn some basic Power Queries, and...