IGIS Tech Notes describe workflows and techniques for using geospatial science and technologies in research and extension. They are works in progress, and we welcome feedback and comments below.

Now that the data from the workbooks has been combined and transformed, it's time to see how it looks in a regular Excel worksheet. In the Home tab on the Power Query Editor window, click the top half ...

I was expecting to offer a bridging solution in excel using VT but they are not offering this so I will have to completely rethink my MTD offering to ...

Documenting 3D printing data reveals trends, helps with budgeting, and boosts confidence in the printing process. Analyzing printing data saves time and money, aids in spotting patterns for supply ...

Learn which Excel formulas perform best for large datasets and how to optimize them for faster calculations and better performance.

If you want to understand the difference between Excel Workbooks and Worksheets, then read the following information as it contains everything you need to know.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

In case you work in one Excel workbook that you'd like to move to another one, there is a simple solution that doesn't require knowing macros or VBA codes – it can be done in a few simple clicks. Read ...

Is your Excel file corrupt? Do you need to recover data from the spreadsheet? Follow these steps to repair a corrupted Excel workbook.

New to Google Sheets? This guide walks you through the basics of how to use Google Sheets, from creating a new sheet to entering and formatting data.

Microsoft makes sharing Excel workbooks in Teams happen in real-time with 'Excel Live' Microsoft continues improving real-time collaboration capabilities in its Office apps within Teams.