I need help to determine whether there is a better/more appropriate tool I should use rather than Excel for a data tracking/analysis project. My current process overwhelms and slows Excel to a crawl or prompts a (not responding message).
To be clear, I recognize that my current process could be streamlined and automated in Excel with macros/VBA code: however, my real question is should I be using something other than Excel or something in addition to Excel to perform the analysis I need?
Currently, I have cobbled together multiple Excel Workbooks (5), some containing multiple sheets that I use to analyze and track data that I import/compile from outside sources (reports generated in other apps/software then exported to excel). Most of the source data requires me to manually push a report to Excel including one source from which I use an RTD output to live stream data into excel.
My process has been to get the report data into Excel then use formulas to format, extract, sort, translate, and combine the information (including multiple instances of VLookup across multiple sheets and/or workbooks) in order to prep the data then run the analysis.
After the basic Analysis is run and directed to a single sheet, I then need to produce different output reports formatted based on different queries/criterion such as date, value, size, title, quantity, and in some instances relative value versus numbers from a streaming data source.
My current process seems to overwhelm Excel 2016, even with a reasonable processor speed and RAM on Windows 10 Pro.
Any suggestions are appreciated.
To be clear, I recognize that my current process could be streamlined and automated in Excel with macros/VBA code: however, my real question is should I be using something other than Excel or something in addition to Excel to perform the analysis I need?
Currently, I have cobbled together multiple Excel Workbooks (5), some containing multiple sheets that I use to analyze and track data that I import/compile from outside sources (reports generated in other apps/software then exported to excel). Most of the source data requires me to manually push a report to Excel including one source from which I use an RTD output to live stream data into excel.
My process has been to get the report data into Excel then use formulas to format, extract, sort, translate, and combine the information (including multiple instances of VLookup across multiple sheets and/or workbooks) in order to prep the data then run the analysis.
After the basic Analysis is run and directed to a single sheet, I then need to produce different output reports formatted based on different queries/criterion such as date, value, size, title, quantity, and in some instances relative value versus numbers from a streaming data source.
My current process seems to overwhelm Excel 2016, even with a reasonable processor speed and RAM on Windows 10 Pro.
Any suggestions are appreciated.
