Course details
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.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- VLOOKUP: Mastering in 60 Minutes StudyHubAED 49
AED 955Duration: Upto 1 Hour - Microsoft Excel Certification Level 3 Courses Distance Learning Ltd.AED 184
AED 367Duration: Upto 10 Hours