Book 16

Excel Data Analysis

by Jinjer Simon

Published 31 March 2003
Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-90% of the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suit your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.

Book 19

Excel Programming

by Jinjer Simon

Published 1 January 2002
Excel(r) Programming 2nd Edition Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including: Creating and launching keyboard shortcuts Setting macro security Assigning a digital signature Developing a function with VBA Displaying a built-in dialog box Converting a list into an array Using the msgbox function Processing a runtime error Saving a workbook in a specified format Finding the intersection of two ranges