If you work in science, chances are you spend upwards of 50% of your time analyzing data in one form or another. Data analysis is such a large and complex field however, that it's easy to get lost ...
You have a table on paper but need the data listed in Excel? Fortunately, there’s a simple trick for importing data on physical papers (or any other images) into Excel spreadsheets. Take your ...
Power Query is a game-changer in terms of the amount of time I save, ensuring imported data is ready for analysis in Excel. If you're new to this tool, it's helpful to know a few commands that can ...