This edition covers the upgraded version of Excel, from fundamental features for beginning users, to such advanced topics as charting, pivot tables, macros and Visual Basic for Applications (VBA) for skilled Excel users. More than 60 easy-to-find sidebar boxes throughout the book offer insider tips and more advanced information on complex Excel tasks and features. There is also extensive coverage of popular new features, including hyperlinks between Office documents, Internet publishing add-ins, data mapping and workgroup editing.Using Functions That Refer to Closed Workbooks In Chapter 8, you learned to write formulas that refer to closed workbooks. ... are exactly the same as functions that refer to open workbooks, except that the full path of each external reference is written out. ... These include OFFSET, COUNTIF, SUMIF, and INDIRECT.
|Title||:||Mastering Excel 97|
|Publisher||:||Sybex - 1997|