Excel University Volume 2 - Featuring Excel 2010 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals

Building on the firm foundation established in the first volume, the second installment in the Excel University series continues to explore the Excel features, functions and techniques relevant to accounting and finance professionals. Volume 2 focuses on how to automate recurring-use reports.Amounts in hands-free reports update the instant updated data is inserted into the workbook, for example, when an updated trial balance is pasted into the data sheet. This volume covers the Excel items needed to build and automate reports, including lookups, dynamic headers, mapping tables, error trapping, conditional summing, and date related functions.Excel practice files and solutions videos are available online so you can work hands-on as you read through the content. The skills developed in this volume will help you get your work done in less time.

Author: Jeff Lenning Cpa

Publisher: Createspace Independent Publishing Platform

Publication Date: Oct 05, 2013

Number of Pages: 284 pages

Binding: Paperback or Softback

ISBN-10: 1484979559

ISBN-13: 9781484979556