Recent Microsoft Excel Spreadsheet Software Articles

First
Prev
1
Next
Last

Sort by:

Date (Ascending)

Date	Title	Author
05/08/12	Creating dropdown combo in excel	senthilkumarsb
04/12/12	Banking, Bookkeeping & Excel - in practice, lesson 2. Excel skill level…	anthonymellorfca
04/15/12	Accounting & bookkeeping file saving version control protocol	anthonymellorfca
04/15/12	Banking, Bookkeeping & Excel - in practice, lesson 1. Excel skill level…	anthonymellorfca
04/06/12	Banking, Bookkeeping & Excel - made very simple, do your accountant …	anthonymellorfca
04/12/12	Workbook link problems after copying tabs to a new workbook?	dlmille
04/29/12	Microsoft Excel - Creating Drop-Down lists that depend on the value of an…	redrumkev
05/24/12	How to quickly and accurately populate Word documents with Excel data, …	dlmille
02/18/12	Improved? Move/Copy Add-in Replacement	dlmille
12/21/11	Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/w…	dlmille
05/23/12	Excel performance - approximate matching with MATCH and VLOOKUP	andrewssd3
04/23/12	A Better Concatenate Function	aikimark
02/05/12	Using XLM with Range Names and Conditional Formatting to automatically for…	brettdj
12/10/11	An overview of using NPV and IRR in Excel for evaluating investment decisi…	brettdj
03/28/12	Part II - Drop Down List with Unique/Distinct Values (ComboBox, ListBo…	dlmille
05/11/12	Excel: Using INDEX and MATCH	Funinig_Stroll
03/26/12	Dealing with unintended Excel Active-X resizing quirks (VBA code simulat…	dlmille
02/06/12	Drop Down List with Unique/Distinct Values (enhancing the ComboBox wi…	dlmille
03/22/12	Stacked Column and Combination Charts with Excel 2010 Sparklines	teylyn
02/29/12	Cascading Validation Lists	jppinto
10/19/11	Adding a horizontal line to an Excel chart	pdoelle
10/19/11	Quickly creating a summary differential sheet or linked output sheet - ignori…	brettdj
04/02/12	Change the Shape of a Cell Comment	jppinto
02/05/12	Getting your EE Ranking statistics in Excel - The Next Generation	Qlemo
05/20/12	Parent Class Builder Add-In for Microsoft Excel	matthewspatrick
10/19/11	Understanding Excel File Internals	gbanik
10/19/11	Using Excel Workbook in a shared Environment without sharing at all - PAR…	suvmitra
03/30/12	Fun with Data Forms in Microsoft Excel 2007	Bordeaux0113
05/12/12	Excel VBA to create a Table of Contents (TOC) summary sheet	brettdj
03/29/12	Creating and Writing to a CSV File Using Excel VBA	brettdj
04/02/12	Misaligned Dates in Excel	hiteshgoldeneye
01/25/12	Automate Finding Cell Errors with the 'Find Cell Errors' Utility	ProdOps
05/20/12	Fixed Rate Loan Amortization Schedule with Optional Extra Principal Payments	matthewspatrick
05/20/12	How to Automatically Update Your PivotTables and PivotCharts	matthewspatrick
10/19/11	Manipulating Local Files Using VBA	agillanders
10/19/11	Adding a "Subtract Range" method alongside Union & Intersect	brettdj
10/19/11	Using Find and FindNext to efficiently delete any rows that contain specific t…	brettdj
10/11/11	Produce an Excel list of the attributes of all MP3 files that sit in or below the …	brettdj
05/19/12	Collating worksheets from one or more workbooks into a summary file	brettdj
10/19/11	Trapping a change to a filtered list with VBA	brettdj
03/08/11	A fast method for determining the unlocked cell range	brettdj
10/19/11	Using a recursive NavigateArrows Method to analyse all local and off sheet …	brettdj
03/29/12	Using Variant Arrays in Excel VBA for Large Scale Data Manipulation	brettdj
05/20/12	Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work	matthewspatrick
03/16/12	Mappit! - a free Excel model auditing addin	brettdj
01/20/11	Compare Two Worksheets in Excel	DrUltima
03/22/11	Combine all of your sheets data into one sheet	jppinto
03/30/12	Beginner's Guide to Improving the Speed and reducing the Size of Excel fil…	alainbryden
10/11/11	Excel "Invisible" broken links	Leon822
05/25/12	Fast Data Push to Excel	aikimark
02/03/12	Eliminating duplicate data with Duplicate Master V2	brettdj
10/19/11	Excel Macros: Solutions using the Current Selection	harfang
04/09/12	Excel Tips & Tricks: The Camera Tool	harfang
02/02/12	Getting your EE Ranking statistics in Excel	Qlemo
05/14/12	A VBA Progress Bar for Excel and Other Microsoft Apps.	alainbryden
05/02/12	Excel - Using a Sheet Tab as a Button for Expanding/Collapsing Suppleme…	alainbryden
10/19/11	Automate Exporting all Components in an Excel Project	alainbryden
03/30/12	Get Excel OpenText to Import Exact File Contents	alainbryden
12/23/11	Use Excel's hidden data store to share data across VBA projects	scott
03/28/12	Option to open excel 2007 documents in a new instance	alainbryden
10/19/11	Excel code to find and report on links in the selected ActiveWorkbook (form…	brettdj
02/18/12	How to dynamically control form List Box controls in Excel.	alainbryden
10/19/11	Excel Formatting Tip to hide zeros	sstampf
09/16/10	Add letter before content in a cell (excel macro)	Gudorian
02/02/11	Create a Durable Relative Cell Reference	bhwithun
10/19/11	Combine multiple Chart Types	bhwithun
10/19/11	Linked dropdowns in MS Excel	patrickab
10/19/11	Excel macro for working with data files that have a header line - set up hea…	TerryAtOpus
09/16/10	Playing with Time Conversion in Excel	saurabh726

First
Prev
1
Next
Last

Loading Advertisement...

Top MS Excel Experts

dlmille

1,351,499

Genius

10,680 points yesterday
Profile

Rank: Genius
ssaqibh

542,555

Sage

0 points yesterday
Profile

Rank: Genius
rorya

381,757

Wizard

4,225 points yesterday
Profile

Rank: Savant
imnorie

334,112

Wizard

0 points yesterday
Profile

Rank: Genius
teylyn

282,850

Guru

20 points yesterday
Profile

Rank: Genius
barryhoudini

280,460

Guru

0 points yesterday
Profile

Rank: Genius
redmondb

235,511

Guru

2,000 points yesterday
Profile

Rank: Sage
matthewspatrick

230,947

Guru

2,010 points yesterday
Profile

Rank: Savant
byundt

197,840

Guru

820 points yesterday
Profile

Rank: Savant
zorvek

144,626

Master

0 points yesterday
Profile

Rank: Savant
StephenJR

136,537

Master

0 points yesterday
Profile

Rank: Genius
nutsch

117,005

Master

0 points yesterday
Profile

Rank: Genius
gowflow

110,036

Master

0 points yesterday
Profile

Rank: Sage
MartinLiss

107,333

Master

0 points yesterday
Profile

Rank: Wizard
GlennLRay

95,652

Master

0 points yesterday
Profile

Rank: Guru
robhenson

90,250

Master

0 points yesterday
Profile

Rank: Sage
ScriptAddict

88,470

Master

0 points yesterday
Profile

Rank: Guru
kgerb

85,022

Master

0 points yesterday
Profile

Rank: Wizard
aikimark

84,456

Master

3,310 points yesterday
Profile

Rank: Genius
andrewssd3

80,242

Master

0 points yesterday
Profile

Rank: Wizard
Wiesje

69,918

Master

0 points yesterday
Profile

Rank: Master
Shanan212

66,418

Master

0 points yesterday
Profile

Rank: Master
krishnakrkc

59,548

Master

0 points yesterday
Profile

Rank: Wizard
Michael74

54,744

Master

0 points yesterday
Profile

Rank: Wizard
regmigrant

51,070

Master

0 points yesterday
Profile

Rank: Guru

Hall Of Fame