Description
if you are an intermediate or expert in Excel and Access vba then these report Automations and dashboards are very useful to you. Dashboards are coming directly from your questions so it will give you a real feel of office work. You can use these ideas in your day to day work and create fabulous Projects and Dashboards. Fantastic automation secrets are also revealed in this series. Excel and MS Access reports can be downloaded. Online support by me is available if you have questions. How to create Excel Pivot Dashboards - Preview availableAgent Dashboard simple dashboard is created to begin with. Create a Break Timer for Team members so that they can see their live break duration on system using Excel VBA - Its awesome toolHow to create a Tool which can help Team Leaders to supervise their team associates break timings. Using MS Access integration with Excel VBA- Using SQL and other recordset related loops - Highly Advance Level. How to create a Tool using VBA Arrays and etc to empower user to find out the relevant information inside data and export it in a specific format. How to create a MS Access Dashboard using its VBA to keep tracking of Visitors. It is done by using MS Access VBA. Recently added one more outlook dashboard wherein you can send emails to clients at desired time and also can take follow ups on the auto mode. It is completely handled from excel and user just need to give email id and time. It is one of most advance report I have created using ms word, ms outlook classes and controlling it via ms excel vba.
