Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel | Access VBA | BI Dashboards & Projects -Super Advance
Rating: 3.5 out of 5(4 ratings)
104 students

Excel | Access VBA | BI Dashboards & Projects -Super Advance

Real Data Super Advance Reports & Projects using Excel VBA , Access VBA and PowerBI - Magnificent projects
Created byajay parmar
Last updated 7/2025
English

What you'll learn

  • Super advance amazing excel and ms access based dashboards or summary reports. See the magic of excel vba and access Vba in these powerful dashboards.
  • Every dashboard file is downloadable and explained in a video pretty well. You must be good in Excel VBA and Access VBA because this series is not for beginers.
  • Extract outlook attachments at specific time and make pivots on that and create high level automated Reports.
  • Excel VBA Useform Tool - How to create break timer which pop up in your screen and keeps showing you break time in HH:MM:SS Format. It is superb automation.
  • Dashboard integrated with Access and Excel VBA Forms - How a Supervisor now can track team members adherence to break timings .
  • How to Create super duper VisItor time Record keeping Dashboard in MS Access using its VBA. It is awesome.
  • How to export filter data as per the color choice and headers criteria's using VBA Arrays- Highly advance Report
  • Some tips and secrets which you should know while planning to create any Dashboard based on Excel or Access VBA.
  • My recent dashboard - Outlook Emailers at specific date and time with follow ups - Its super fun and Super Advance
  • One more Voucher distribution dashboard is added today - VBA Userform - using arrays, vlookup, loops in VBA- Highly advance

Course content

2 sections • 24 lectures • 16h 15m total length

  • What are we covering - A Quick discussion10:57
  • Dashboard 1 - Create Agent Break Time Tool44:55

    • In this Tool,we are learning the method to create a break timer for associates who if leave their workstation needs to click on start break time button and on return need to stop it. So.this way as a Team Manager or supervisor we can come to know if there is any break misuse happened or how was the team members adhering to breaks .

    • This Tool is made using excel VBA language integrated with MS Access Database. Use of SQL is quite obvious.

    • Highly advance level Tool made with VBA. Only those who know VBA very well can understand the code OR if you are a beginner but having a zeal to learn more and more and to see the power of VBA can go for this Dashboard.

  • Dashboard 1 - Team Leader Monitoring Reporting Tool1:04:40
  • Dashboard 2 - MS Access Visitor Record keeping Part 11:06:58

    • This is ms access dashboard for access programmers. This is done by using Access VBA language.

    • Database is attached in zip file. Please go and practice on it after watching all lectures of this dashboard

  • Dashboard 2 - MS Access Visitor Record Keeping Part 231:39
  • Dashboard 2 - MS Access Visitor Record Keeping Part 322:12
  • Dashboard 3- Advance Tool on Outlook & Pivot Automation1:24:05

    • An automation report which extracts the file from outlook folder ,save it on desktop and then opens it at specific time in a day to create the pivots from it and finally taking the snapshots of pivots and sending the emails to clients with those snapshots.

    • Great source of information for those students who want to see the outlook and pivot automation at its best. You  must know the VBA Pivots and outlook connectivity in order to understand the concept used in this highly advanced report. Should you have any doubts or question please email me at ajayk3802@gmail.com.

    • "Files are uploaded in the downloadable materials section"

  • Dashboard 4 - Project using VBA Arrays - Super Advance- Part117:07

    • A project where we compared two different data sets using VBA arrays and then exporting them in the required sheet .

    • Multi-dimensional Arrays, if conditions, Loops , sub loops, collection loops - everything is used in this project

  • Dashboard 4 - Project using VBA Arrays - Super Advance- Part247:50
  • Dashboard 5 - Project using VBA Arrays - Super Advance- Part331:30
  • Dashboard 5 - Project using VBA Arrays - Super Advance- Part428:51
  • Dashboard 5- Project using VBA Arrays - Super Advance- Part529:31

    how to add lines or connectors showing the relationship between two cell values in this project.

  • Dashboard Secrets -Tips for Excel VBA Userform32:39

    • One of the most used Form VBA Events in dashboards is "Change event" and "After Update". Discussion on their use in projects and the difference between them.

  • Dashboard Secrets -Tips for Excel VBA Userform42:58

    How do we scroll next or previous in USERFORMS. This is often we need it in our projects  as data accessing is very common requirement user wants.

  • Tips you can use in Access Dashboards - Fabulous VBA Events16:41

    What is the importance of global or public variables in dashboards. This is a super awesome tip for you.

  • My Courses with links and Coupon Codes - 30 + Series waiting for you0:59

    I also have wonderful detailed in-depth series on Advance Excel/ Excel VBA/ MS Access  and MS Access VBA programming language. You can see each of the series in sequence if you like to a master in entire course OR

    You can pick any touch topic as per your need and be a master but dont forget to see basic requirements need by the course in this selective picking of course.

  • What are we going to achieve through this dashboard - Let us discuss first.3:43

    One of very recent project on outlook automation. From giving outlook subject, body , signature control to users to defining the time as to when to send the email or when to take a follow ups, you hardly have to do anything, All set in this excel file and just little twisting and you are done. This is a highly advance code which wants you to have a good knowledge of outlook and ms word classes. as we are using both of them.

    I have explained each line very slowly and in full detail.. Hope you will this my new dashboard or Report whatever you may call it.

  • How to send Emails to Clients and follow ups - Advance Level Part120:55

    This is first stage of our dashboard, In this we are discussing how we have given the controls to user through excel sheet wherein he or she can just create a email body content , italic or bold the letters if needed, use any logo or image under signature and can easily see it in a preview before sending out to clients.

    We are taking the help of ms word application and you can run each code line by line on F8 mode, to get  real learning.

  • How to send Emails to Clients and follow ups - Continuing.. Part254:02

    Setting up the time in excel sheets with email sender list and then running the automation tool from a range you like to run and what you like to send. It has everything, From subject line, to email body content, setting up date time for emails and not only emails but follow up emails as well. we have everything.

  • How to Create a Voucher or Token distribution system - Excel VBA Forms - Advance1:03:13

    We are creating a Excel VBA User form which helps us in tracking the Voucher numbers or token. First, we want to assign the available vouchers to team mates and then to track if they are exhausted or needs to be transferred to others. This Dashboard uses Arrays, VLOOKUP function and Loops.

  • Voucher Tracking Part244:34

Requirements

  • Only those students should go for these dashboards who holds good knowledge of ms excel vba and ms access vba.
  • if you understand the core of VBA or you are a beginner in VBA but not someone who does not know anything then this course is for you.

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 available

  • Agent 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 tool

  • How 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.


Who this course is for:

  • Students or professionals who work in excel and access 24*7 and looking to create dashboards.
  • Students who understands VBA (access as well as excel) and want to see the use of programming in dashboards and projects.
  • Students who want to take their career to new heights and want to shine in the industry through their powerful automation dashboards
  • if you are passionate about excel ,excel vba and ms access and its vba -come and join me in this super thrilling and powerful dashboards. See the idea ,logics and tricks used in these dashboards and use in your projects.

Report abuse