تفاصيل الدورة

The course covers design techniques and simple ways to monitor the status of locked and unlocked worksheet cells. How-to Excel expert David H. Ringstrom, CPA, will demonstrate the numerous techniques he uses to improve the integrity of spreadsheets that he builds for himself and others.

You learn how to:

  • Use a simple design technique that greatly improves the integrity of Excel's SUM function.
  • Use the TEXT function to create report titles that update themselves.
  • Compare and contrast IFNA, IFERROR, and ISERROR, and see which versions of Excel support each of these worksheet functions.
  • Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.
تحديث بتاريخ 28 February, 2018
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Microsoft Excel ابتداءً من الآن. See all courses

قيِم هذه الصفحة