Does your company do business in more than one state or country? If so, here's an Excel tip that makes it easy to display important data organized by location.

Use Excel’s “Get Data from Folder” feature to import and combine multiple trial balance files into a single query. Clean and transform data using Power Query to prepare it for analysis.