Technology
How to capture small data sets in Excel – INTHEBLACK
Discover how, for small data sets, you can capture, store and use data in Excel, using an input sheet and a separate data sheet. Read now.
Excel is not a database, but with recent changes, it can pretend to be a basic one. For small data sets, the solution detailed below can work well.
Let’s say you need to keep track of a few key metrics that come from different systems. These may be required as part of a reporting or dashboarding system. The metrics may be important, but are too hard or too expensive to automate. As a last resort, you decide to capture them manually.
This solution will cover creating a database that has an input…
-
Business23 hours ago1 ASX dividend stock down 43% I’d buy right now
-
Noosa News23 hours agoBanana farmers still salvaging fruit four weeks after ex-Tropical Cyclone Alfred
-
Noosa News23 hours agoMeasles alert: Australia Zoo, Hospital ED, Sushi Hub, Holey Moley Mini Golf and train stations among QLD infection sites
-
General14 hours agoThe right-wing stupidity repeating Liberal Party history