Introduces the functions and features of the Microsoft Excel spreadsheet program, shows how to use macros and templates, and discusses customizationCLOSED. WORKBOOKS. In Chapter 8 you learned to write formulas that refer into closed workbooks. These formulas can include functions ... are exactly the same as functions that refer into open workbooks, except that the full path of each external reference is written out. ... which, because of their complexity, cannot refer to closed workbooksathese include OFFSET, COUNTIF, SUMIF, and INDIRECT.

Title | : | Mastering Excel 5 for the Mac |

Author | : | Thomas Chester, Julia Kelly |

Publisher | : | Sybex - 1995 |

Continue