Discussion Logical functions, lookup functions, data validation, or pivot tables – which tool set brings the most value to analyzing data? Defend your choice by offering details concerning the tool set and what value it brings to making business decisions.
Use at least 2 features of Excel’s database functions to perform an analysis on your data,one of which needs to be data validation.
Based on the database you created in Week 1, make any modifications you feel are needed now that you have additional knowledge of databases and add 20 more records to your original database. Use at least 2 features of Excel’s database functions to perform an analysis on your data,one of which needs to be data […]