Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Table of Contents
Title Page
Introduction
Part I: Basic Information
Chapter 1: Excel in a Nutshell
Chapter 2: Basic Facts about Formulas
Chapter 3: Working with Names
Part II: Using Functions in Your Formulas
Chapter 4: Introducing Worksheet Functions
Chapter 5: Manipulating Text
Chapter 6: Working with Dates and Times
Chapter 7: Counting and Summing Techniques
Chapter 8: Using Lookup Functions
Chapter 9: Working with Tables and Lists
Chapter 10: Miscellaneous Calculations
Part III: Financial Formulas
Chapter 11: Borrowing and Investing Formulas
Chapter 12: Discounting and Depreciation Formulas
Chapter 13: Financial Schedules
Part IV: Array Formulas
Chapter 14: Introducing Arrays
Chapter 15: Performing Magic with Array Formulas
Part V: Miscellaneous Formula Techniques
Chapter 16: Importing and Cleaning Data
Chapter 17: Charting Techniques
Chapter 18: Pivot Tables
Chapter 19: Conditional Formatting
Chapter 20: Using Data Validation
Chapter 21: Creating Megaformulas
Chapter 22: Tools and Methods for Debugging Formulas
Part VI: Developing Custom Worksheet Functions
Chapter 23: Introducing VBA
Chapter 24: Function Procedure Basics
Chapter 25: VBA Programming Concepts
Chapter 26: VBA Custom Function Examples
Part VII: Appendixes
Appendix 1: Excel Function Reference
Appendix 2: Using Custom Number Formats
← Prev
Back
Next →
← Prev
Back
Next →