Automating Data Analysis Tasks

Excel Help Forum for Automating Data Analysis Tasks

Forum Category

New 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 Topics		Date	Author	Views	Replies
	Basic Excel data categorization	29 Mar 2011	anu_17	5,450	1
	Conditional formatting of the last entry in the column only	04 Feb 2011	environdata	5,109	3
	Auto copy from drop down list to three new sheets	26 Jan 2011	allyc0820	5,465	4
	Using Excel to connect to AS400 database to retrieve data	26 Dec 2010	davidong328	7,986	1
	About 64 bit ODBC Connect Excel 2007 download	18 Dec 2010	satimis	6,187	1
	Run Macro IF Specific URL Changes	30 Oct 2010	indi visual	4,684	3
	Concatenate string and lookup in array?	11 Oct 2010	Lhadrepsak	5,724	1
	Conditional Formatting to color-code three highest values?	30 Jul 2010	heatherchellette	5,578	1
	Finding a common string in two columns	28 Jul 2010	Sansha	5,795	2
	Adding up interchanging word	22 Jul 2010	JordanGoodchild	4,079	1
	Automating a web query	16 Jul 2010	Double A Enterprises	4,649	1
	IF Statement	14 Jul 2010	dkalra1981	4,470	3
	Exclude Space and restrict text length	27 Apr 2010	dkalra1981	4,964	1
	Change text based on content	29 Mar 2010	EBERE	4,000	1
	Import print screen figures into Excel	19 Mar 2010	frcrilly	4,548	1
	selective cells for use in a different spreadsheet	15 Feb 2010	legepe	3,904	1
	Search Function	11 Feb 2010	ajhat	2,262	0
	How to Calulate if a Range of Times Falls Between two Date/Time Stamps	21 Jan 2010	Michaniker	4,374	1
	Trouble with VBA query using date with ODBC	11 Dec 2009	rhawk204	3,846	0
	Download Historical NAV form web	15 Nov 2009	Maheshp	6,124	5

Back

Displaying page 2 of 4

Next

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