January 9, 2024
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 visit Microsoft's official support page for more information on how to use this feature. Check out our TipUp site to view our past episodes!