Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Im working with an large Excel Database and generate reports with it. I need a better tool - faster - nicer?
I work with a large database 200.000 entries and need to update it and generate graphic reports every week. Which tools would work faster and more reliable to generate those graphic reports?
2 Answers
- linnea13Lv 51 decade agoFavorite Answer
With that many entries you may want to look into setting it up in access. If you want to stick with excel it depends on how you want to manipulate the data and what you want to show. I love pivot tables and pivot charts which allows you to filter and group more easily. I also use a lot of lookup formulas statements to pull specific data into a seperate table. For a very visual view of a straight up report conditional formating and/or if statements are great.