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,4221
View TopicConditional formatting of the last entry in the column only04 Feb 2011environdata5,0733
View TopicAuto copy from drop down list to three new sheets26 Jan 2011allyc08205,4374
View TopicUsing Excel to connect to AS400 database to retrieve data26 Dec 2010davidong3287,9401
View TopicAbout 64 bit ODBC Connect Excel 2007 download18 Dec 2010satimis6,1621
View TopicRun Macro IF Specific URL Changes30 Oct 2010indi visual4,6583
View TopicConcatenate string and lookup in array?11 Oct 2010Lhadrepsak5,6981
View TopicConditional Formatting to color-code three highest values?30 Jul 2010heatherchellette5,5491
View TopicFinding a common string in two columns28 Jul 2010Sansha5,7702
View TopicAdding up interchanging word22 Jul 2010JordanGoodchild4,0501
View TopicAutomating a web query16 Jul 2010Double A Enterprises4,6221
View TopicIF Statement14 Jul 2010dkalra19814,4373
View TopicExclude Space and restrict text length27 Apr 2010dkalra19814,9381
View TopicChange text based on content29 Mar 2010EBERE3,9731
View TopicImport print screen figures into Excel19 Mar 2010frcrilly4,5201
View Topicselective cells for use in a different spreadsheet15 Feb 2010legepe3,8821
View TopicSearch Function11 Feb 2010ajhat2,2490
View TopicHow to Calulate if a Range of Times Falls Between two Date/Time Stamps21 Jan 2010Michaniker4,3451
View TopicTrouble with VBA query using date with ODBC11 Dec 2009rhawk2043,8300
View TopicDownload Historical NAV form web15 Nov 2009Maheshp6,0985
 Displaying page 2 of 4 

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