Excel University Volume 2 - Featuring Excel 2010 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals (Excel University - Featuring Excel 2010 for Windows)
暫譯: Excel 大學 第二卷 - 專為 Windows 的 Excel 2010 設計:針對 CPA 和會計專業人士的 Microsoft Excel 培訓 (Excel 大學 - 專為 Windows 的 Excel 2010)

Jeff Lenning CPA

  • 出版商: CreateSpace Independ
  • 出版日期: 2013-10-05
  • 售價: $1,360
  • 貴賓價: 9.5$1,292
  • 語言: 英文
  • 頁數: 282
  • 裝訂: Paperback
  • ISBN: 1484979559
  • ISBN-13: 9781484979556
  • 相關分類: Excel
  • 海外代購書籍(需單獨結帳)

相關主題

商品描述

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.

商品描述(中文翻譯)

在第一卷建立的堅實基礎上,《Excel大學》系列的第二卷繼續探討與會計和財務專業人士相關的Excel功能、函數和技術。第二卷專注於如何自動化重複使用的報告。當更新的數據插入工作簿時,無需手動操作的報告中的數量會立即更新,例如,當更新的試算表平衡貼上到數據表中時。本卷涵蓋了構建和自動化報告所需的Excel項目,包括查找、動態標題、映射表、錯誤捕捉、條件求和和日期相關函數。Excel練習檔案和解決方案視頻可在線獲得,讓您在閱讀內容的同時進行實作。本卷中發展的技能將幫助您在更短的時間內完成工作。