| Quotes about Excel 2007 |
From Excel 2007 Bible by John Walkenbach (Mr.
Spreadsheet):
|
From Using Microsoft Office Excel 2007 by Bill Jelen (Mr. Excel):
|
|
Some New Features in Excel 2007 (also other Microsoft Office 2007 products) |
|
| 10 Key Enhancements, Craig Stinson, Microsoft web page. | LinkToSite |
| Changes in Excel 2007, Microsoft TechNet web page. | LinkToSite |
| Improving Performance in Excel 2007: Microsoft MSDN web page. | LinkToSite |
| Excel’s New Charting Engine, Stephen Few. | LinkToPDFfile |
| Default font is Calibri (Excel, PowerPoint and Word), The New Paperclip web page. | LinkToSite |
| New Excel Functions, The team blog for Microsoft Excel and Excel Services. | LinkToSite |
| 2007 File formats, Microsoft web page (most Office programs). | LinkToSite |
| 2007 File formats, Compatibility pack for Office 2003. | LinkToSite |
| 2007 Microsoft Office Add-in: Save as PDF | LinkToSite |
| Features depreciated (dropped) | LinkToSite |
|
Information about Excel 2007 |
|
| Microsoft's home page for Excel 2007. | LinkToSite |
| Excel 2007 Demo, From Microsoft, Video, 5-6 minutes. | LinkToSite |
| Excel 2007 Online Training, From Microsoft, all free. | LinkToSite |
| Excel 2007 Online Training: Lynda.com, Video, 5 hours, 1 hour free, need Quick Time. | LinkToSite |
| Excel 2007 Online help, University of Wisconsin Eau Claire Online Help documentation. | LinkToSite |
| Excel 2003 to Excel 2007, Microsoft web page, converts 03 commands to 07. | LinkToSite |
|
Excel 2003 and Excel 2007 Podcasts/Webcasts by Bill Jelen, "Mr Excel."(Need QuickTime) |
|
|
At
Mefeedia.com, web site
with all of the podcasts/webcasts (To use as webcast: a) Select link to Mefeedia.com, b) press enter in black podcast/webcast area, c) after podcast/webcast is loaded double left click in same podcast/webcast area.) |
LinkToSite |
| Directions to view these Podcasts with iTunes. | LinkToSite |
| File Archive for iTunes, Podcasts can be downloaded, starts with 161, 1/5/06.. | LinkToSite |
|
First podcasts that discuss Excel 2007 are: 391 (November 28,
2006), 393, 396, 398, 401, 403, 406, 408, 411, 413, 415, 418, 420, 423, and 425 (January 18, 2007). Additionally, 650 - 654 (December 2007). |
|
|
Excel 2007 Videos on YouTube |
|
| Bill Jelen, Mr Excel, New features. | LinkToSite |
| Excel 2007 Demo, From Microsoft, Video, 5-6 minutes, DemoTrainer (same as above). | LinkToSite |
| Preview, Ed Zollars. | LinkToSite |
| Essential Training by Lynda.com, albanbytyci | LinkToSite |
| Preview, Ed Zollars. | LinkToSite |
| 5 New features, "stzaske." | LinkToSite |
| Open a file, "jfaze." | LinkToSite |
| Formula AutoComplete, "MicrosoftVistaTips." | LinkToSite |
| Combine contents of multiple cells into 1 cell, DemoTrainer | LinkToSite |
| Analyze product sales with a PivotTable report, DemoTrainer | LinkToSite |
| PivotTables, Matthew MacDonald. | LinkToSite |
| PivotTables, Hilary Pike. | LinkToSite |
| Line chart, "namuoc." | LinkToSite |
| Combination chart, Matthew MacDonald. | LinkToSite |
| Column-Line 2-Axis Chart, Ralph Phillips. | LinkToSite |
| VLOOKUP, Ralph Phillips. | LinkToSite |
| Mouse range selection, "stzaske." | LinkToSite |
| Data takes shape with conditional formatting, "DemoTrainer." | LinkToSite |
| Formula AutoComplete, "MicrosoftVistaTips." | LinkToSite |
| Trace formulas, SmartLearn/cirillino69. | LinkToSite |
| Trace formulas, Matthew MacDonald. | LinkToSite |
| Importing data, SmartLearn/cirillino69. | LinkToSite |
|
Excel Best Practices |
|
| Excel Models: PDF file (490 KB, 23 pages), Balik & Mehran, 10/06, (Excel 2003). | LinkToPDFfile |
| Spreadsheet Modeling Best Practice: (1.4 MB, 102 pages), Read & Batson, 4/99. | LinkToPDFfile |
| How do you know your spreadsheet is right? (666 KB, 14 pages), Bewig, 7/05. | LinkToPDFfile |
| The Devil's guide to spreadsheet creation, PraxIS, 4/04. | LinkToSite |
|
Excel web sites |
|
| Mr Excel: Bill Jelen's info about Excel. Bill is known as Mr. Excel. | LinkToSite |
| Mr Spreadsheet: John Walkenbach's web site, John is known as Mr Spreadsheet. | LinkToSite |
| Peltier's Excel Site: Jon Peltier's Excel site, Many Excel chart tips. | LinkToSite |
| Pope's Excel Site: Andy Pope's Excel site, Many Excel tips. | LinkToSite |
| Rubin's Excel tips: Joseph Rubin's web site. Tips for all versions of Excel. | LinkToSite |
| Excel for Duke MBAs: Excel material for Duke University MBA students. | LinkToSite |
| Dashboards: Using Excel 2007 to create Dashboards, The Dashboard Spy web site. | LinkToSite |
| Excel for Business: Charley Kyd's web site for business users of Microsoft Excel. | LinkToSite |
|
Excel blogs |
|
| The MSDN blog for Microsoft Excel and Excel Services | LinkToSite |
| JLD Excel blog | LinkToSite |
| Ken Puls blog | LinkToSite |
| Daily Dose of Excel | LinkToSite |
| Excel blob, Timothy Mayes | LinkToSite |
| Excel News The weblog for Excel spreadsheet news. | LinkToSite |
| Excel blog, Info about Microsoft Excel for Windows | LinkToSite |
|
Excel Charts and Tables |
|
| Graph and Table IQ test, 10 questions, Stephen Few, May 2007. | LinkToSite |
| Uses and Misuses of Color, PDF file, Stephen Few, November 2005. | LinkToPDFfile |
| Best Practices for Understanding Quantitative Data, PDF file, Jonathan Koomey, 2/06. | LinkToPDFfile |
| Designing Effective Tables and Graphs, PDF file, Stephen Few, No date. | LinkToPDFfile |
|
Other Excel features |
|
| Keyboard shortcuts: Charlie’s List, or “214 Keyboard Shortcuts” | LinkToSite |
| Equation Editor in Word 2007 (not in Excel 2007 or PowerPoint 2007), Waterloo Univ. | LinkToSite |
| Microsoft Equation in Excel 2003, same in 2007 | |
| To access: Insert tab, Object in Text group, Object dialog box and Create New tab | LinkToSite |
|
Office 2007 bugs (Service Pack 1 corrects these errors) |
|
| Excel, Mathematical Calculation | LinkToSite |
| PowerPoint bugs | LinkToSite |
| Word Save As bug | LinkToSite |
|
Other Spreadsheet Programs |
|
| Google Spreadsheets: Google's Internet spreadsheet program (registration required). | LinkToSite |
| Zoho Sheet: Zoho.com Internet spreadsheet program (registration required). | LinkToSite |
| Open Office Suite: OpenOffice.org, Free downloadable Office program. | LinkToSite |
| Quattro Pro: Spreadsheet program in Corel WordPerfect Office, current version is X3. | LinkToSite |
| Lotus 1-2-3: Spreadsheet program in Lotus SmartSuite, current version is 9.8. | LinkToSite |
|
Places to purchase Microsoft Office 2007 |
|
|
Microsoft Program: Ultimate Steal For students with edu e-mail address, cost is $59.95, offer ends April 30, 2008. |
LinkToSite |
|
Academic Superstore:
Sells software and hardware, for K-12 and college students and faculty. Quoted price usually includes shipping and taxes, price for Professional Version on 1/1/08 is $169.95. |
LinkToSite |
|
Are Excel Skills Important? |
|
| Daily Dose of Excel, Blog, How important is strong working knowledge of Excel? | LinkToSite |
| West Chester University: Excel exam for upper level finance and accounting courses. | LinkToSite |
| UofC Berkeley Career Center: Advice for Liberal Arts students seeking business jobs. | LinkToSite |
| EphBlog: Williams University student: Issue: Course Selections for a Finance Career. | LinkToSite |
| Houston Astros Internships: Need for Excel skills is mentioned several times. | LinkToSite |
| Jobs at Wells Fargo: Notice mention of both Accounting and Excel. | LinkToSite |
| Student Testimonials, Scared Heart University: Read testimonial of Lisa Nevanpera. | LinkToSite |
| Economics, Queens College: See item 26, Courses outside or Economics. | LinkToSite |
| George Washington University: Students Learn Skills for Working on Wall Street. | LinkToSite |
| Sophisticated Finance: Blog, Issue: The purpose of financial models. | LinkToSite |
Balik's Homepage |
Courses |
Contact Balik |
Resume
Student Comments |
Student Projects and Trip |
Excel and Financial Calculators
Finance & Commercial Law Department
|
Haworth College of Business |
Western Michigan
University
Last Updated on January 10, 2008, e-mail any comments to: robert.balik@wmich.edu