Home > Forum Home > Automating Data Analysis Tasks Share

Automating Data Analysis Tasks

Excel Help Forum for Automating Data Analysis Tasks

Forum CategoryNew Post Login

Automating Data Analysis Tasks

The Excel help forum for automating data analysis tasks focuses on problems and solutions for saving time when analyzing data or building analytical models by applying appropriate formulas and utilizing visual basic for applications (VBA) code.
Excel Help TopicsDateAuthorViewsReplies
View TopicBasic Excel data categorization29 Mar 2011anu_175,5041
View TopicConditional formatting of the last entry in the column only04 Feb 2011environdata5,1763
View TopicAuto copy from drop down list to three new sheets26 Jan 2011allyc08205,5354
View TopicUsing Excel to connect to AS400 database to retrieve data26 Dec 2010davidong3288,0721
View TopicAbout 64 bit ODBC Connect Excel 2007 download18 Dec 2010satimis6,2451
View TopicRun Macro IF Specific URL Changes30 Oct 2010indi visual4,7473
View TopicConcatenate string and lookup in array?11 Oct 2010Lhadrepsak5,7801
View TopicConditional Formatting to color-code three highest values?30 Jul 2010heatherchellette5,6441
View TopicFinding a common string in two columns28 Jul 2010Sansha5,8562
View TopicAdding up interchanging word22 Jul 2010JordanGoodchild4,1411
View TopicAutomating a web query16 Jul 2010Double A Enterprises4,7121
View TopicIF Statement14 Jul 2010dkalra19814,5313
View TopicExclude Space and restrict text length27 Apr 2010dkalra19815,0271
View TopicChange text based on content29 Mar 2010EBERE4,0631
View TopicImport print screen figures into Excel19 Mar 2010frcrilly4,6191
View Topicselective cells for use in a different spreadsheet15 Feb 2010legepe3,9651
View TopicSearch Function11 Feb 2010ajhat2,2840
View TopicHow to Calulate if a Range of Times Falls Between two Date/Time Stamps21 Jan 2010Michaniker4,4661
View TopicTrouble with VBA query using date with ODBC11 Dec 2009rhawk2043,8840
View TopicDownload Historical NAV form web15 Nov 2009Maheshp6,1875
 Displaying page 2 of 4 

Find relevant Excel templates and add-ins for Automating Data Analysis Tasks in the