that some of these workbooks contain macros. )
(Excel 2003, ~25K)
Illustrates a critical worksheet design mistake
and how to correct it.
References (Excel 2003, ~749K)
(Excel 2003, ~54K)
- A Chart Technique (Excel 2003, ~82K)
On defining data in the formula bar.
- Using Excel's Built-In Calendar (Excel 2003, ~72K)
on Excel DFunctions
a Simple Drop-Down for Data Entry
(Excel 2003, ~127K)
(Updated 10/2009 for Excel 2007. ~100K)
(Excel 2003, ~49K)
- Notes on Excel 2007 Forecasting Tools (PDF, ~880K) and ForecastingTools2007.xlsx (Excel 2007, ~41K)
the Listbox and Spinner
controls, the Index and Lookup functions (EXCEL 2003, ~36K) Note that this
is not an entirely self-explanatory workbook.
and Logic Demo
IF in a Macro
(EXCEL 2003, ~80K)
- Call Solver with a Macro (EXCEL 2003, ~309K)
of the Ordinary
(EXCEL 2003, ~173K)
A grab bag of formulas, formatting, drawing and graphics, etc.
- Hiding & Protection Notes
(EXCEL 2003, ~39K)
on List Sorting and Formulas
Unhiding, and Working with Visible Data
(EXCEL 2003, ~380K)
- excel's Projection And Regression Tools (EXCEL 2003, ~165K)
(EXCEL 2003, ~259K)
(EXCEL 2003, ~968K)
Chart Titles and Legends
Headers and Footers
(EXCEL 2003, ~103K)
(EXCEL 2003, ~26K)
A technique to flag when data values in a column change.
- TrANSFORMING EXCEL DATA (EXCEL 2003, ~395K)
Parse, convert text to numbers, preserve number formats in concatenations.
- Filter Data by Date with a Graphical Interface (~190K)
- Bissantz Sparklines & Custom Colors (EXCEL 2003, ~335K)
sparklines created using Excel add-in Bissantz Sparkmaker software. See http://www.bissantz.de/sparklines/download.asp#sparkmaker
- Excel-Generated Sparklines (EXCEL 2003, ~260K)
- Sparklines from Excel Line Charts
(EXCEL 2003, ~950K)
- Control Conditional Formatting with A Graphical Interface (EXCEL 2003, ~220K)
- Custom Color Templates for Excel 2003
Custom color template example files: ETufte.xlt, DBricklin.xlt, RockLichen.xlt, Citron.xlT, CartoonBank.xlt, SWGarden.xlt
- Notes on Excel 2007 Range name constraints (EXCEL 2007, ~80K)
- New Features: Excel 2007 Text Box Text (Excel 2007)
on Excel 2003 Forecasting Tools (PDF, ~620K)
Data Table, Scenario
Manager, Goal Seek, & Solver AND ForecastingTools.xls (~36k), THE accompanying Excel workbook.
- Excel 2003 Data
338K) and the Xertech Exercise
- Excel 2007 Data Tables (PDF) and the Xertech Exercise (Excel 2007).
to Excel 2003 Pivot Tables (PDF,
- INTRODUCTION TO THE EXCEL 2007 PIVOT TABLE (PDF, ~1.4 K)
excel 2003 XY (Scatter) Plot (PDF,
- Excel 2003 Worksheet
- Excel 2003 Web
Queries (Word, ~25k)
- excel 2003 Custom and Conditional Formats (Excel, ~30K)
- Notes on Excel 2007 Forecasting Tools (PDF, ~440K) and ForecastingTools2007.xlsm (Excel, ~41K)
- Excel 2007 Macro Security (PDF, ~325K)
- excel 2003 Proficiency
~470K) and Solutions.xls
Svelte Glove Problem - With
Step-By-Step Instructions for Excel 2003 and Workbook
~121K and Excel, ~104K)
- Excel 2007 Proficiency Exercises (pdf document), EXCEL 2007 Proficiency exercise sOLUTIONS (PDF document) and Solutions for Excel 2007.xlsm (Excel workbook)
Oak Products Problem, a sample Excel 2003 workbook,
and its Word data file
~428K, Excel ~72K, and Word, ~23K)
Padgett's Widgets excel 2003 Problem (PDF,
Shoes excel 2003 Exercise
- IF, MAX, and MIN, With Step-By-Step Instructions and
(PDF, ~75K, Excel, ~95K)
2003 Solver Practice and
Workbook (PDF, ~47K and Excel,
- EXCEL LOGIC EXERCISES ON PAPER (PDF, ~495K)
(to Fuqua-only download)
(to Fuqua-only download)
on SensIt and Treeplan (PDF, ~173K)
User's Guide (The author's documentation, Word, ~778K)
2003 Quick Guide (What you need to run Regress, PDF, ~160K)
Regress for Excel 2007 Notes (Word, ~570K)
Skill Building and Quick Guide
(Same as above plus step-by-step skill-building demo notes, PDF, ~420K)
and sample files: SmythPieData.xls
to Install Regress for excel 2003
- HOw to install regress for Excel 2007 (Word, ~112K)
Add-Ins: Sources & Information
Tutorial & Reference Guides (2003, 2007, 2010)
- Microsoft Excel 2003: Comprehensive
Ageloff, Course Technology, intensive tutorial guide
ISBN 0-61920-665-9, paperback, 842 pages
This text offers a case-based, problem-solving approach especially recommended for a good
MBA pre-program review.
- MICROSOFT EXCEL 2003 STEP BY STEP
Curtis Frye, Microsoft Press,
- Microsoft Excel 2003 Inside Out
Craig Stinson and Mark Dodge, Microsoft Press
Best Practices for Business and the Excel Best Practices for Business author's website for the book.
Loren Abdulezer, Wiley,
Covers Excel 2003, 2002, and 2000.
MICROSOFT EXCEL: DATA ANALYSIS AND BUSINESS MODELING
Wayne L. Winston
Microsoft Press, ISBN 0-7356-1901-8
- ACCESSING AND ANALYZING DATA WITH MICROSOFT EXCEL
Microsoft Press, ISBN 0-7356-1895-X
- microsoft Office OnlineSelf-Paced Training for Excel 2003
- Microsoft Office Excel Step By Step
Curtis D. Frye, Microsoft Press, 432 pages
- Microsoft Excel 2007 INSIDE OUT
Dodge and Stinson, Microsoft Press, the standard Microsoft Excel reference.
- Excel 2007: Beyond the Manual
Helen Dixon, Apress, 417 pages
- Excel 2007 Formulas
John Walkenbach, Wiley, 804 pages
- Excel 2007 Bible
John Walkenbach, Wiley, 866 pages
- Excel 2007 Power Programming with VBA
John Walkenbach, Wiley, 1104 pages
- Excel as your Database
Paul Cornell, Apress, 250 pages (for Excel 2003 and 2007)
- Microsoft Office Online Self-Paced Training for Excel 2007
- Microsoft Excel & Access integration with Office 2007
Michael Alexander and Geoffrey Clark (Duke MBA 2000) , Wiley, ISBN 978-0-470-10488-0
- Learn excel 2010 essential skills with the smart method
The Smart Method Ltd.
Fantastically easy-to-use and efficient lessons for beginning to intermediate users. Each lesson is fully described on two facing pages. Nothing extra to wade through. Great for self study. Web-based sample files at: http://www.LearnMicrosoftExcel.com
- Learn excel 2010 expert skills with the smart method
The Smart Method Ltd.
The follow-up expert version (see above). Again, fantastically easy-to-use and efficient lessons, each described on two facing pages. Web-based sample files at: http://www.LearnMicrosoftExcel.com
- Microsoft Office Excel 2010 Bible
John Walkenbach, Wiley
Another thorough reference guide on Mr. Walkenbach's specialty.
Video/CD-ROM Excel Courses
KeyStone Learning Systems, Video or CD-ROM formats. Beginning
and intermediate training. Order online or 1-800-581-9732.
LearnKey Training,Video or CD-ROM
formats. Order online or 1-800-865-0165.
Excel 2010 Skills Builder. Free online video training.
Power Keyboarding Resources
Microsoft Excel Team Favorite Keyboard Shortcuts
Excel Keystroke shortcuts exercise (2007 workbook)
Wall St Training: Advanced Excel Keyboard Shortcuts (also see Wall St Training's Self Study exercises)
- Wall Street Prep FInancial Training Solutions Crash course in excel, including "Accelerate the internalization of key time-saving shortcuts via exercise-based internalization drills, audio guidance, and interactive quizzes."
- A Perspective from the blog Stuff Investment bankers like - "The other thing investment bankers love about Excel are macros and shortcuts. Where would my life be without you Alt+E+S+T? (Allows you to paste the format from one cell to another). These little shortcuts allow investment bankers to make our worksheets proper and save us a great deal of time... During training, the programs like Training the Street even have contests to see how quickly investment banking analysts can format in Excel using all the shortcuts we have been taught. The sad thing is, they brainwash us to the point where we think it's cool and really want to be the fastest. Who wants to play the guitar or go for a run outside when you can be the fastest Excel formatter in the land? The programs keep a scoreboard from all the banks and lead us in cheers for our top competitors. The fastest formatter can wear this title like a badge of honor and even put this accolade on the good ol' resume."
On Excel 2010's PowerPivot add-in:
=powerpivot(pro) - Great site for intro and advanced users.
PowerPivotGeek - primarily problem analyses.
MrExcel PowerPivot Forum - Q&A.
Kasper de Jonge PowerPivot Blog - "Bringing BI to the masses."
Excel Now! For purchase self-contained tutorial of Excel essentials. Reasonably priced. Well organized and easy to use.
- Excel Audit: Managing spreadsheet risk. Website that gives chilling examples of the impact of failing to manage risk, gives suggestions for managing spreadsheet risk, and provides a survey to see how well you're currently managing spreadsheet risk.
More on auditing and spreadsheet risk:
SSRB: Spreadsheet Standards Review Board (publishers of "Best Practice Spreadsheet Modelling Standards"), and
Spreadsheet Safe - Skills and training course website, and
EuSpRiG - The European Spreadsheet Risks Interest Group. An interest group of academia and industry promoting research regarding the extent and nature of spreadsheet risks, methods of prevention and detection of errors and methods of limiting damage. An especially useful article on that site:e: Spreadsheet Modelling Best Practice.
- CF (Goodwill Community Foundation) - Excel basics in text and video. Free online lessons.
- PErceptual Edge: Visual Business Intelligence - Fabulous, thought-provoking website and blog by Stephen Few. "Perceptual Edge focuses on the tools and techniques of visual business intelligence to help you make better use of your valuable information assets."
- Topo.ly - Data visualization professional Drew Kesler makes mapping simple. The what, why, and how of mapping in your business. Map locations from an Excel spreadsheet. Tutorials, blog, support.
- CHANDOO: Learn excel & charting online, A lively and witty site packed with practical techniques, approaches, and tips. Every Excel business user (with the energy) should be following Chandoo's quickly-expanding blog. Chandoo's web-based "Excel School" is also occasionally available along with interesting guest bloggers. Follow this site long enough and you'll not only become an Excel expert, you'll also feel like you've known Chandoo for years.
- ExcelCharts.com - An attractive, thoughtful, practical, and entertaining site by Jorge Camoes, in Lisbon Portugal. Jorge writes on data visualization, business charts, and dashboards. His site includes both free- and fee-based tutorials and his posts are always thought-provoking. Interested in exploring Tableau? Follow Jorge's experience.
- Clearly and Simply: Intelligent Data Analysis, Modeling, Simulation and Visualization - This blog's title pretty much says it all. An intelligent and elegant website by Robert Mundigl (Germany) that includes many interesting and thought-provoking free example files and templates, mostly for Excel. Robert's blog title is from this quote by Karl Popper: "Anyone who cannot speak clearly and simply should say nothing and continue to work until he can do so." Robert also addresses Tableau visual analysis software in his blog.
- PERCEPTUAL EDGE - Articles by Stephen Few, author, critic, designer, and inventor. This link is to his Library. Also available: Blog, Discussion, Examples, etc.
- FLOWING DATA: Nathan Yau's brilliant depictions of data. Not necessarily Excel-oriented but stunning and inspiring.
- Post an Excel question and get suggestions from a community of Excel users. Extensive archive of past Q&A. Access forum also available. Mr. Excel and associates have authored many books on Excel. Also lLearn Excel from MrExcel Video PodCasts. "
Every weekday, I produce and send out a free 2-minute video demonstrating how to do a particular task in Excel. Initially, the podcast was a video companion to Learn Excel from MrExcel - but after 275 episodes, I had podcast the book in it's entirety. Today, any podcast episode might feature a viewer question or a concept from one of my Excel books."
- An entire (long) page of Excel-topic web links from
Macro Systems with links Organized by type (VBA, stock market, financial
analysis, engineering, etc.).
- Better Solutions - Addresses Word and PowerPoint as well as Excel.
Tips - Beyond Technology Development Corp.
- Excel User - Charlie Kyd's Excel website. Practical tips, advice, Excel version previews, etc.
- http://www.excelbestpractices.com/excel/ - Loren Abdulezer's website supporting his often-referenced and outstanding book Excel Best Practices.
- http://www.tushar-mehta.com/Excel/ - Fabulous website by the now legendary Tushar Mehta with ideas and add-ins for Excel charting along with notes on many other Excel topics.
- A lively website by Jon Peltier with lots of business-focused Excel
charting instructions and tips. Downloadable materials both free and for purchase. Dashboard recommendations and ideas plus a downloadable book on dashboarding with Excel.
- Pearson Software Consulting, LLC.
Spreadsheet Page - JWalk & Associates, Inc. Prolific Excel book author John Walkenbach shares tips and views on this site. Also a humor corner.
Excel Tips - Accounting Advisors.
Excel Logic Page - Aaron Blood.
- The Microsoft
Assistance Online for Excel XP
Excel 2010 Skills Builder (free online videos)
- Rob Bovey's
AppsPro Free Utilities Page
- Excel User: For Business Users of MS Excel including an Excel Help Portal page.
- VB Numerical Methods - Excel VBA code for financial and mathematical applications. Free downloads and a numerical methods discussion forum.
- A page with links to other Excel information sites.
- D. Dalgliesh's CONTEXTURES Excel site. Excel tips and techniques elegantly explained and illustrated.
- Miricle Solutions List of Excel Links.
- Aviran's Place: The Technology Hangout (includes articles on Office products)
- Pioneer Training blog - Tips, tricks, opinions, and information for business computer users.
- VISUAL BASIC EXPLORER - A website that helps a novice VB programmer learn Visual Basic (note: Not Visual Basic for Applications)
- CLICK Consulting - Excel tips and training especially for accounting.
Navigator + Project Finance Excel Shortcuts for financial modelers. Download a comprehensive list of Excel shortcuts. "The knowledge of the key shortcuts in Excel can make a big difference in the finance industry. Often things have to get done very quickly and yet big investments will be made backed up by your analysis. It is critical that you know the best ways of using common tools in Excel, and also know the best ways of minimising your mistakes. This collection of finance shortcuts for Excel will help you improve the quality of your work by adding consistency and efficiency to your keyboard skills. "
- Joseph Rubin's Exceltip.com
- Excel Wiki - A new public Wiki; a work in progress.
- DataPig Technogies: Discover Your Data - An excellent free tutorial site created and maintained by author Michael Alexander, author of multiple books on Excel and Access including Excel 2007 Dashboards & Reports for Dummies.
- JKP Application Development Services, Jan Karel Pieterse. Many useful articles, interesting Excel add-in downloads.