Curtis Frye's professional bibliography

Books

Books on Microsoft Excel

• Microsoft Excel 2013 Step by Step, Microsoft Press, March 2013

• Microsoft Excel 2013 Plain & Simple, Microsoft Press, April 2013

• Brilliant Excel VBA Programming, Pearson UK, April 2013

• Microsoft Office Excel 2010 Step By Step, Microsoft Press, June 2010

• Microsoft Office Excel 2010 Plain & Simple, Microsoft Press, June 2010

• Excel 2007 Charts Made Easy, McGraw-Hill Osborne, September 2008 (co-author)

•  Excel 2007 Pocket Guide, O’Reilly & Associates, October 2007

• Microsoft Office Excel 2007 Step By Step, Microsoft Press, January 2007

• Microsoft Office Excel 2007 Plain & Simple, Microsoft Press, January 2007

• Excel Annoyances, O’Reilly Media, December 2004

• Microsoft Office Excel 2003 Programming Inside Out, Microsoft Press, January 2004 (lead author)

• Excel Pocket Guide, O’Reilly & Associates, October 2003

• Microsoft Office Excel Version 2003 Step By Step, Microsoft Press, August 2003

• Microsoft Excel Version 2002 Plain & Simple, Microsoft Press, November 2001 (lead author)

• Microsoft Excel Version 2002 Step By Step, Microsoft Press, June 2001

Books on Other Microsoft Products

• Microsoft Office Access 2010 Plain & Simple, Microsoft Press, January 2007

• Microsoft Office Accounting 2007 Professional Step by Step, Microsoft Press, October 2007 (lead author)

• Microsoft Office Access 2007 Plain & Simple, Microsoft Press, January 2007

• The 2007 Microsoft® Office System Step by Step, Microsoft Press, January 2007

• Microsoft Office Small Business Accounting 2006 Step By Step, Microsoft Press, October 2005 (lead author)

• Microsoft Office System 2003 Step By Step, Microsoft Press, August 2003 (co-author)

• Faster Smarter Home Networking, Microsoft Press, November 2002

• Microsoft Office v. X for the Mac Inside Out, Microsoft Press, May 2002 (unindicted co-conspirator)

• Microsoft Access Version 2002 Plain & Simple, Microsoft Press, January 2001

• Microsoft Office XP Step By Step, Microsoft Press, July 2001 (co-author)

• Introduction to Active Server Pages, ActiveEducation, October 2000

• Microsoft Access 2000 Step by Step Courseware Expert Skills Student Guide, Microsoft Press (via ActiveEducation), March 2000

• Master Microsoft Access 2000 Visually, IDG, 1999

Books on Business Topics

• Privacy-Enhanced Business, Quorum, December 2000

• The State of Web Commerce (with Dick Peck), O'Reilly, January 1997

Books on Other Topics

• Winning Secrets of Online Poker, Course Technology, February 2005 (co-author)

Online Courses

• Up and Running with QlikView, 11/14, lynda.com

• Securing Microsoft Office Files, 10/14, lynda.com

• Office Online Essential Training, 7/14, lynda.com

• Up and Running with Excel Cluster Analysis, 5/14, lynda.com

• Up and Running with Tableau, 5/14, lynda.com

• Up and Running with Mathematica 9, 4/14, lynda.com

• Crystal Reports 2013 Essential Training, 4/14, lynda.com

• Up and Running with Octave, 1/14, lynda.com

• Up and Running with Excel What-If Analysis, 1/14, lynda.com

• Excel 2013: PivotTables in Depth, 4/13, lynda.com

• Excel 2013 Power Shortcuts, 2/13, lynda.com

• Crystal Reports 2011 Essential Training, 5/12, lynda.com

• Up and Running with VBA in Access, 10/11, lynda.com

• Excel 2010: Financial Functions in Depth, 6/11, lynda.com

• Excel 2010: PivotTables in Depth, 4/11, lynda.com

• Excel 2007: Business Statistics, 12/10, lynda.com

• Excel for Mac 2011 Essential Training, 10/10, lynda.com

• Up and Running with VBA in Excel, 6/10, lynda.com

• Excel 2007: Creating Business Budgets, 6/10, lynda.com

• Excel 2010: Real-World Projects, 1/10, lynda.com

• Excel 2007: Creating Charts with Dynamic Data, 11/09, lynda.com

• Excel 2007: Creating and Managing Invoices 11/09, lynda.com

• Migrating from Excel 2003 to Excel 2007 11/09, lynda.com

• Excel 2007: Introduction to Formulas and Functions 11/09, lynda.com

• Excel 2007: Pivot Tables for Data Analysis 11/09, lynda.com

• Excel 2008 for Mac: Pivot Tables for Data Analysis 9/09, lynda.com

• Excel 2007: Financial Analysis 8/09, lynda.com

• Excel 2000 Data Formatting and Customization http://www.digitalthink.com/catalog/ms/ms210/  

• Excel 2000 Data Analysis and Dissemination http://www.digitalthink.com/catalog/ms/ms310/ 

• Advanced Database Design Data Analysis http://www.digitalthink.com/catalog/dc/dc200/ 

Webcasts

• Analyzing Data Dynamically Using Excel 2007 PivotTables

• Creating Effective Conditional Formats Using Excel 2007

• Tips and Tricks to Manage Data Effectively by Using Excel Tables

• Create Attractive Charts and Graphics Using Excel 2007

Training, Testing, and Certification

Instructor-Led Courses

• Forecasting and Trend Analysis Using Microsoft ® Office Excel® 2003, August 2005

• Summarizing Microsoft® Office Excel® 2003 Data to Make Better Business Decisions, August 2005

Certification

Defined the skills to be tested in Microsoft Learning's next generation of certification exams for Excel 2007 and Access 2007. Tasks included defining the target audience, determining the skills for the minimally qualified candidate, and specifying questions and problems to test those skills.

Testing

• Developed bank of 80 questions to test the abilities of Excel 2002 and 2003 users (ReviewNet)

Chapters, Articles, and Papers

Microsoft Work Essentials

• Use PivotTable reports to discover business intelligence

• PivotTable report position recall

• Communicate design changes effectively by using OneNote

• Manage office equipment with Visio and Excel

• Calculating subtotals and working with levels in Excel

• Introduction to custom macros in Excel

• Choosing the macro security level that's right for you

• Set the best price for your product

• Price elasticity of demand calculator

• Improve budgeting using balanced scorecards

• Use key performance indicators for effective budgeting

Microsoft Office Online Articles

• 10 Ways to Get Ready for Excel 2007

• 5 Tips for Working with Columns, Rows, and Cells in Excel 2007

• Create Flexible, Effective Conditional Formats in Excel 2007

• Design Effective Cell Styles in Excel 2007

• Design Terrific Workbook Themes in Excel 2007

• Organize Data into Excel 2007 Data Tables

Microsoft Office (2007) Beta Community Expert Articles

• Preview the Enhanced Microsoft Office Excel 2007 Business Intelligence Capabilities

• Improve the 2007 Microsoft Office system experience by customizing the Quick Access Toolbar

• Preview the Enhanced Microsoft Office Excel 2007 Charting Capabilities

• Getting to the Heart of Your Data More Quickly Using Microsoft Office Excel 2007

Other Articles, Papers, and Book Reviews

• Technology and Society Book Reviews. Over 100 reviews published since February 15, 1998. http://www.techsoc.com/

• “Protecting the customer", Publish.  October 2000. p. 64.

• Over 200 tutorials on digital cameras, scanners, game controllers, Lotus ScreenCam, and SnagIt for Service911.com.

• "Web Commerce", Chapter 35 in Internet: The Complete Reference, Millennium Edition, by Margy Levine Young.

• "EU Privacy Directive's Impact on U.S. Business",  The Internet Newsletter: Legal and Business Aspects. September 1998. http://www.ljx.com/newsletters/internet/1998/1998_09_index.html (dead link)

• "Regulated Privacy", Infobahn. June 1995.

• "Comparing US and Japanese Technology Development Strategies", presented at EURO XII/TIMS XXI Joint Conference on Operational Research and Management Science. Helsinki University of Technology (Espoo, Finland). June 30, 1992.