Exploring Excel: Establishing Spreadsheet Internal Controls
Added by Referral on 2018-05-28
Conference Dates:
Start Date: 2018-06-04Last Day: 2018-06-04
Deadline for abstracts/proposals: 2018-06-04
Conference Contact Info:
Contact Person: Ashutosh swainEmail: [email protected]
Address: 2479 East Bayshore Road, Palo Alto, United States
Conference Description:
Using Data Validation to create a rule that ensures dates entered within a cell are greater than or equal to today’s date.Overcoming VLOOKUP’s quirks by using SUMIF to look up numeric values.
Using Conditional Formatting to identify unlocked cells into which data can be entered.
Ensuring proper VLOOKUP integrity by using Data Validation to create an in-cell drop-down list.
Improving the integrity of spreadsheets with Excel’s VLOOKUP function.
Creating an in-cell list by way of Excel’s Data Validation feature.
Creating resilient SUM functions that won’t break when users insert additional rows.
Using a custom number format to hide zero amounts within a specific area of a spreadsheet.
Utilizing Data Validation to limit percentages entered in a cell to a specific range of values.
Protecting sensitive information by marking key worksheets as VeryHidden.
Using Excel's IFERROR function to mask # sign errors like #N/A.
Toggling the Locked status of a worksheet cell on or off by way of a custom shortcut.