Topic |
Site |
Description |
Excel Tips, Techniques |
Excel Chart Links Workbook
|
Workbook with 150 links to on-line how to articles and downloads. use query button to enter topic and get links that you can view right from Excel.
Workbook updated by ProcessTrends.Com regularly
|
DataPig Technologies |
Video tutorials on all aspects of Excel, Charting and VBA |
Contextures |
Well Organized Site - Excel tips/techniques and downloads - Data Validation |
Chip Pearson |
Excel tips/techniques |
Mr Excel PodCasts |
Short PodCasts on various aspects of Excel |
XL-Logic |
Excel Tips/techniques, Downloads on Excel, charting and VBA |
Charting with Excel |
Andy Pope |
Great selection of Excel Chart examples with download files. |
Ed Ferrero |
Selection of Excel Chart examples with download files. |
Jon Peltier |
Excellent tutorials and download files. |
John Walkenbach |
Original Excel Guru. His Excel Charts book is a must have if you are serious about charting with Excel. Link to J-Walk Chart Tools Add-in http://j-walk.com/ss/excel/files/charttools.htm |
Tushar Mehta |
Advanced Excel charts, add-ins |
Apps Pro |
Home of XY Chart Labeler add-in |
Bernard Liengme |
Author of two Excel books, one for scientists and engineers, one on business applications |
John Mansfield |
John is a frequent Excel Chart User Forum participant. |
Excel User |
Charley Kyd's site tells you all you want to know about Excel Dashboards. His e-book is excellent.
ExcelUser has an great selection of Excel Chart links. It's a good place to start your search for a chart how to. ExcelUser -- Excel Charts
|
John Lacher |
Several tutorials on Excel charting |
Data Visualization
|
NBR - Naomi Robbins |
"Creating More Effective Charts". First book you need to start your journey to effective charting. |
Perceptual Edge (Stephen Few) |
Stephen Few's website. Author of "Show Me the Numbers" and "Information Dashboard Design". |
The Work of Edward Tufte and Graphics Press |
Edward Tufte - leading author on data visualization. |
Juice Analytics |
Interesting Blog - focus on practical data visualization tips and techniques. |
Gary Klass - Illinois State University |
Presenting Data: Tabular and graphic display of social indicators
Examples of Good and bad charts and good charting principals.
|
Junk Chart |
blog dedicated to recycling chart junk as junk art. Data visualization discussions mixed in with some humor and examples of good and bad charting. |
The Dashboard Spy |
Dashboard Blog - many examples of good/bad dashboards, some in Excel. |
Getting Data from Databases |
Querying External Data in Excel |
Dick Kusleika site. Shows you how to use Excel's Get External Data tools to get data from Access databases. Must site if you want to get data from Access to Excel. |
Erlandsen Data Consulting |
Shows you how to read, write data between Excel and Access |
VBA |
Code Snippets for VBA |
Wide selection of VBA code snippets |
Beyond Technology |
Excel power user how-to's. Introduction to VBA |
Excel Blogs |
MS Office Reporter |
|
Excel Blogs - Headlines |
J Walkenbach has set up this Excel headlines blog. |
Daily Dose of Excel |
This blog is administered by Dick Kusleika, and written by many contributing authors. Very active comments to posts. |
Excel MVP Sites |
Excel MVP Web Sites |
Learn from the best |
Favorite Tools |
VB Code Cutter |
I use this VBA code editor to copy, store and paste my code snippets. Lets me reuse my code over and over, saving time and improving my code reliability. |
VB Code Print |
I use this Excel add-in to improve the print quality of my VBA code print-outs. Allows flexible use of font color and size. |