Excel & Access VBA Dashboard and Projects Series 15
3.5 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
27 students enrolled

Excel & Access VBA Dashboard and Projects Series 15

Super Advance Reports and Projects - VBA
3.5 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
27 students enrolled
Created by ajay parmar
Last updated 9/2019
English
Current price: $17.99 Original price: $29.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 11.5 hours on-demand video
  • 1 article
  • 7 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • You will learn the art of making Reports/Dashboards. 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.
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.


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 passionalte 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.
Course content
Expand 17 lectures 11:25:31
+ Advance Level Dashboards - Excel VBA & MS Access
17 lectures 11:25:30

This project will give you an idea how we can play with pivots and use them in dashboards using formulas. We have created a dashboard which can give us yearly performance of companies on just one click. Not only the performance but it is shown in graphs.

A scroll bar is created which is an activeX control to move the data up and down .

Preview 56:12
  • This dashboard gives you an creative idea as to how we can change the data and graphs using Active-x Controls.

  • How we can set up our pivots and date calendars to auto populate the numbers.


    Please note  you put the images in your d drive as shown in project.

Dashboard 2 - Agent Performance Report
01:06:43
  • 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 3 - Create Agent Break Time Tool
44:55
Dashboard 3 - Team Leader Monitoring Reporting Tool
01:04:40
  • 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 4 - MS Access Visitor Record keeping Part 1
01:06:58
Dashboard 4 - MS Access Visitor Record Keeping Part 2
31:39
Dashboard 4 - MS Access Visitor Record Keeping Part 3
22:12
  • 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 5- Advance Tool on Outlook & Pivot Automation
01:24:05
  • 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

Preview 17:07
Dashboard 6 - Project using VBA Arrays - Super Advance- Part2
47:50
Dashboard 6 - Project using VBA Arrays - Super Advance- Part3
31:30
Dashboard 6 - Project using VBA Arrays - Super Advance- Part4
28:51

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

Dashboard 6 - Project using VBA Arrays - Super Advance- Part5
29:31
  • 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 Userform
32:39

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.

Dashboard Secrets -Tips for Excel VBA Userform
42:58

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

Preview 16:41

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.

Preview 00:59