Manage and format data in workbooks. Use formulas and cell formatting to create a spreadsheet that can be manipulated without changing the integrity and appearance of the final product.
Give users the ability to change inputs while locking the outputs through settings. Validate data through the use of conditional formatting rules to ensure duplicate entries in key fields are identified for review.
Use advanced logical, look up, and time and date formulas for data analysis. Generate formulas that calculate results using nested functions.
Create and modify charts, data tables, pivot tables, and simple macros. Use data from multiple workbooks to generate charts for analysis.