In our day to day work one tool that most of us use for planning, tracking, analysis and reporting purpose is excel, which we think is one of the most powerful and most userfriendly tool.
Here we present a list of examples that can be utilized in day to day activity related to excel
- Display excel charts in userform (Giving a better and interesting interface to the user and giving him the freedom to see what he wants )
- Excel message box (Giving out a message to the excel user to lead him in correct direction and keep the user informed)
- Update the chart dynamically based on date range (slecting a date range will dynamically update the chart, without any manual effort)
- Popup Calendar (A popup calendar in excel to fill i dates in forms etc)
- Creating Pivot Table in Excel (Simple and easy steps to create a pivot table in Excel)
- Protect Selected Region in Excel (Protecting only the selected region(s) in excel to stop from being modified
- Dropdown List (Create a dropdown list in excel to input data in a much more easier way)