Advanced Excel essentials

摘要

Spreadsheets have been the workhorse of computational engines for over 30 years. They allow users to perform demanding calculations without requiring learning or using a higher-order programming language like C++ or Fortran. Excel is found on a majority of machines as a fundamental component of one of the Microsoft Office packages. Most users do not get beyond the use of formulas in cells, even in very sophisticated financial, engineering, or scientific applications. Others may use portions of the Visual Basic for Applications (VBA) macro language to add capabilities to their spreadsheets, but VBA is a programming language and must be learned as such. There are many books that have been published over the years describing the capabilities of Excel spreadsheets and VBA. This book builds upon the lessons taught in them. Excel 7 and later are supported.