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
	Automating a web query login to download data	18 Dec 2006	kilo94	221,339	40
	Send variables to MSQuery via entry in Excel cell range?	09 May 2006	jwhitwell	47,720	12
	Excel web query results destination	13 Aug 2006	jtzako	18,612	4
	Using excel to automatically build a database of stock data	23 Feb 2012	Bokononblue22	17,322	1
	Returning a value from a range of data	20 Feb 2006	tinagi	13,315	1
	Cumulative formula based on entries	24 Feb 2006	v4mpy	11,268	1
	Bloomberg ActiveX control	09 Feb 2007	Ben	10,423	1
	Web Query with Session ID Variable	13 Nov 2009	Excel Helper	9,774	1
	Delete cell items in spreadsheet	11 Apr 2013	FODKOD	9,346	3
	Help creating a list that meet certain criteria ...	26 Oct 2007	XcelGirl	8,407	1
	Using Excel to connect to AS400 database to retrieve data	26 Dec 2010	davidong328	8,403	1
	Calculating the time in Hours	01 Mar 2008	luckyros	7,974	1
	Free software download?	04 Aug 2012	Kynthia Melissa	7,867	0
	Can anyone help to create a project plan?	17 Jul 2012	Kynthia Melissa	7,492	0
	Check PDF files for text from Excel file.	04 Feb 2014	Tubu	7,009	3
	How to pull data from webpage(.aspx) for a excel column?	28 Jun 2012	ppkg2	7,000	2
	Look Up	13 Feb 2007	Geetika Arora	6,840	3
	Looping Query using value from next cell	27 Sep 2007	Torantis	6,704	6
	About 64 bit ODBC Connect Excel 2007 download	18 Dec 2010	satimis	6,533	1
	Download Historical NAV form web	15 Nov 2009	Maheshp	6,454	5

Displaying page 1 of 4

Next

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