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.
The skills developed in this Volume will help you get your work done in less time..
Excel practice files and solutions videos are available online so you can work hands-on as you read through the content.
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.
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.
Volume 2 focuses on how to automate recurring-use reports.
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
