Use the restricting input with data validation, importing data and naming ranges.
Illustrate the uses of different advanced excel functions.
Identify pivot tables, adding calculated field, and formatting pivot tables.
Utilize trace precedents/dependents tools.
Determine the essentials of data management to import and export data in excel.
Explain macros and how to use them in excel.
Comprehend the “what-if” functions and how to use them beneficially.