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
	Data Profiling in Excel	18 Feb 2022	excel-template	784	0
	Formula selecting	30 Sep 2021	Andrew Perkins	1,324	2
	Data Analysis with Beautiful Charts in Microsoft Excel & Office 365	06 Aug 2021	Charles Friedo	1,104	2
	duplicate invoice numbers	02 May 2018	esweeney	2,614	1
	Facing difficulty in Financial Reporting and Analysis	19 Dec 2017	BrianPugh	1,465	0
	simple spreadsheet that finds m and b of y=mx+b given two cartesian points	04 Mar 2015	mackconsult	3,732	2
	Web query	29 Aug 2014	cgrauballe	5,060	7
	Check PDF files for text from Excel file.	04 Feb 2014	Tubu	6,837	3
	Fetch Data automatically in a single cell	26 Oct 2013	krishna2221	5,989	1
	Delete cell items in spreadsheet	11 Apr 2013	FODKOD	9,168	3
	Free software download?	04 Aug 2012	Kynthia Melissa	7,783	0
	Can anyone help to create a project plan?	17 Jul 2012	Kynthia Melissa	7,421	0
	Newbie join here!	28 Jun 2012	Kynthia Melissa	3,432	0
	How to pull data from webpage(.aspx) for a excel column?	28 Jun 2012	ppkg2	6,834	2
	Using excel to automatically build a database of stock data	23 Feb 2012	Bokononblue22	17,148	1
	Is this possible - Change dates in URL?	18 Oct 2011	DMKPDX	6,219	6
	Convert numbers to a specific text string	01 Oct 2011	francis	5,188	1
	Institutional ownership 13F form downloads from SEC and Bloomberg	19 Jul 2011	alammiman	3,940	0
	Taking out middle names on a long list of names	06 Jun 2011	joe8489	6,064	5
	Finding max value based on data that contains both text and numbers	18 Apr 2011	Margretjona	6,252	3

Displaying page 1 of 4

Next

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