We will learn some basic and advanced date functions to use date and time dynamically. Also, we will cover calculation of working days by setting up holidays dynamically.
We will learn data validation functionality in Excel. It will cover how we can set specific inputs in the cells so that data entry errors can be avoided.
Data visualization is one of the key elements of report/MIS presentation nowadays, which can be done through a modern tool like interactive dynamic dashboards.