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...

The fourth installment in the Excel University series covers the Excel features, functions, and techniques that will help you build reliable workpapers. The first part of this volume explores a variety of useful features, including outlines and protection. We discover that formatting choices impact productivity and learn how to use accounting underlines and custom number formats. We also use hyperlinks to help organize our digital files. The second part examines numerous functions that help make our workbooks efficient to maintain and update each period. Our examination includes lookup...

The fourth installment in the Excel University series covers the Excel features, functions, and techniques that will help you build reliable workpapers. The first part of this volume explores a variety of useful features, including outlines and protection. We discover that formatting choices impact productivity and learn how to use accounting underlines and custom number formats. We also use hyperlinks to help organize our digital files. The second part examines numerous functions that help make our workbooks efficient to maintain and update each period. Our examination includes lookup...

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...