Walkenbach John. Microsoft Excel 2010 Formulas + CD

Учебное пособие. Wiley Publishing Inc. , 2010. - 818 p.
ISBN: 978-0-470-47536-2
Язык: Английский
Качество: Изначально компьютерное (eBook)
Прилагаемый диск содержит примеры, рассматриваемые в книге.Описание:
This is not a book for beginning Excel users. If you have absolutely no experience with Excel, this is probably not the best book for you — unless you’re one of a rare breed who can learn a new software product almost instantaneously.
To get the most out of this book, you should have some background using Excel. Specifically, I assume that you know how to
Create workbooks, insert sheets, save files, and complete other basic tasks
Navigate through a workbook
Use the Excel 2010 Ribbon and dialog boxes
Use basic Windows features, such as file management and copy and paste techniquesPart. Basic Information
Excel in a Nutshell
Basic Facts about Formulas
Working with NamesPart: Using Functions in Your Formulas
Introducing Worksheet Functions
Manipulating Text
Working with Dates and Times
Counting and Summing Techniques
Using Lookup Functions
Tables and Worksheet Databases
Miscellaneous CalculationsPart: Financial Formulas
Borrowing and Investing Formulas
Discounting and Depreciation Formulas
Financial SchedulesPart: Array Formulas
Introducing Arrays
Performing Magic with Array FormulasPart: Miscellaneous Formula Techniques
Intentional Circular References
Charting Techniques
Pivot Tables
Conditional Formatting and Data Validation
Creating Megaformulas
Tools and Methods for Debugging FormulasPart: Developing Custom Worksheet Functions
Introducing VBA
Function Procedure Basics
VBA Programming Concepts
VBA Custom Function ExamplesPart: Appendixes
Appendix A: Excel Function Reference
Appendix B: Using Custom Number Formats
Appendix C: Additional Excel Resources
Appendix D: What’s on the CD-ROM?