CHAPTER 1. Overview -- 2. Book Conventions -- 3. Excel Conventions -- 4. How to make the most -- 5. Foundations overview -- 6. Selected Shortcuts -- 7. Named References -- 8. Tables -- 9. Data Validation -- 10. Conditional Formatting Basics -- 11. Better Summing -- 12. Skinny Row -- 13. Hide Worksheets -- 14. Highlight input cells -- 15. Workbook Organization -- 16. Worksheet Organization -- 17. Nested Functions -- 18. Selection Groups -- 19. Workbook Design Principles -- Conclusion.

During live CPE training sessions, and through Excel articles featured in magazines such as the Journal of Accountancy and California CPA Magazine, Jeff Lenning, founder of Excel University, Inc., has shown thousands of CPAs and accounting professionals across the country how to use Excel more effectively. Drawing on his experience as an auditor, a financial analyst in industry, an accounting manager at a public company, and a consultant, he has demonstrated how to leverage Excel in order to improve efficiency by reducing the time it takes to complete job tasks.

Written to reach those he won’t have the opportunity to meet in one of his CPE sessions, Lenning’s series, Excel University: Microsoft Excel Training for CPAs and Accounting Professionals, offers a comprehensive collection of the features, functions, and techniques that are of direct benefit to accountants working in industry, public practice, consulting, or not-for-profit. Concentrating on Excel for Windows, his books offer a hands-on approach to learning and include narrative, screenshots, video content, Excel practice files, and exercises that demonstrate the practical application of the items presented in each chapter. Visit http://www.excel-university.com to access the Excel University video library and to download the practice files. Features, functions and techniques are presented in a sequential and progressive manner, so the books are best read in order. In Volume 1, the author presents material and information that will prove useful to every accountant, regardless of the type of work they do. Blown away by the power of Excel, readers are sure to find this series relevant, enlightening, and extremely easy-to-follow.