Complaint Management System - Part 2 (Creating Excel File, Worksheets and Support Data)
Part Two of Complaint Management System (CMS) in Excel and VBA
This is the Part 2 of Complaint Management System (CMS) in Excel and VBA. We will learn to create Excel file, Worksheets and support data required for this automated project. In next part of this tutorial, we will create UserForm for Complaint Management System in VBA window.
Link of tutorials for CMS (Part 1 to Part 6)
CMS Part 1 (Demo of Complaint Management System)
https://youtu.be/kUHTOngYH44
CMS Part 2 (Creating Excel file and Support Data)
https://youtu.be/RdxTyYrT6QM
CMS Part 3 (Creating UserForm and Input Controls)
https://youtu.be/cLxtUwnfcRQ
CMS Part 4 (Creating Resolve Complaints UserForm)
https://youtu.be/QWwpfFVvcsI
CMS Part 5 (Writing Sub Procedures and Functions)
https://youtu.be/tDJkiZ6lpwc
CMS Part 6 (VBA Code to resolve the pending complaints)
https://youtu.be/IygTWoifyak
You can download the practice file from the below link.
https://thedatalabs.org/automated-complaint-management-system/
Please visit our website www.thedatalabs.org
Please send your query on info@thedatalabs.org
#ProjectInExcel #TheDataLabs
Thanks for watching! Please like, share, comment and subscribe.
Have a great day!
Видео Complaint Management System - Part 2 (Creating Excel File, Worksheets and Support Data) канала TheDataLabs
This is the Part 2 of Complaint Management System (CMS) in Excel and VBA. We will learn to create Excel file, Worksheets and support data required for this automated project. In next part of this tutorial, we will create UserForm for Complaint Management System in VBA window.
Link of tutorials for CMS (Part 1 to Part 6)
CMS Part 1 (Demo of Complaint Management System)
https://youtu.be/kUHTOngYH44
CMS Part 2 (Creating Excel file and Support Data)
https://youtu.be/RdxTyYrT6QM
CMS Part 3 (Creating UserForm and Input Controls)
https://youtu.be/cLxtUwnfcRQ
CMS Part 4 (Creating Resolve Complaints UserForm)
https://youtu.be/QWwpfFVvcsI
CMS Part 5 (Writing Sub Procedures and Functions)
https://youtu.be/tDJkiZ6lpwc
CMS Part 6 (VBA Code to resolve the pending complaints)
https://youtu.be/IygTWoifyak
You can download the practice file from the below link.
https://thedatalabs.org/automated-complaint-management-system/
Please visit our website www.thedatalabs.org
Please send your query on info@thedatalabs.org
#ProjectInExcel #TheDataLabs
Thanks for watching! Please like, share, comment and subscribe.
Have a great day!
Видео Complaint Management System - Part 2 (Creating Excel File, Worksheets and Support Data) канала TheDataLabs
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Daily Activity Tracker in Excel & VBA (Premium Tool)](https://i.ytimg.com/vi/C9MUsiR_Izk/default.jpg)
![How to Create a Magic Search Box in MS Excel Quickly without VBA?](https://i.ytimg.com/vi/gwISBo6pF4k/default.jpg)
![Excel Trick 52 - Custom Number Format to show numbers in Red or Green with Up and Down Arrow #shorts](https://i.ytimg.com/vi/wFo0jkWuxTw/default.jpg)
![Excel Trick 51 - Create a Real Time Search Box for Instant Data Find #exceltricks #shorts #excel](https://i.ytimg.com/vi/97mUsrKsab4/default.jpg)
![Excel Trick 50 - Master Dynamic Range Grouping in Excel #exceltricks #shortsviral #excelsolutions](https://i.ytimg.com/vi/mtenM5NK8f4/default.jpg)
![Excel Trick 49 - Quick Way to Calculate Age In MS Excel #exceltricks #shorts](https://i.ytimg.com/vi/n4xTAzT1J8I/default.jpg)
![Excel Trick 48 - How to compare two lists and find the missing entries #shorts #exceltricks](https://i.ytimg.com/vi/2v4BO-MJL4o/default.jpg)
![Excel Trick 47 - How to Create Progress Circle Chart in MS Excel #shorts](https://i.ytimg.com/vi/S8ns9wMSCmc/default.jpg)
![Excel Trick 46 - How to Add Developer Tab in MS Excel? #shorts](https://i.ytimg.com/vi/ZFwqBC6A4Og/default.jpg)
![Excel Trick 45 - How to Get Workbook Statistics in Microsoft Excel #shorts](https://i.ytimg.com/vi/9V773mNedTE/default.jpg)
![Excel Trick 44 - How to get sum of Top N and Bottom N values in MS Excel #shorts](https://i.ytimg.com/vi/LdgqVUCjOu4/default.jpg)
![Excel Trick 43 - Get Live Currency Exchange Rate in MS Excel #shorts](https://i.ytimg.com/vi/y-GR5-KF-2I/default.jpg)
![Excel Trick 42 - Get LIVE Stock Data in MS Excel Using Stocks Datatype #shorts](https://i.ytimg.com/vi/STwEgt1uayI/default.jpg)
![Excel Trick 41 - Get Geographical Data in MS Excel On a Single Click #shorts](https://i.ytimg.com/vi/gUhmoDjIg8w/default.jpg)
![Excel Trick 40 - Create Chessboard Pattern In MS Excel Using Conditional Formatting #shorts](https://i.ytimg.com/vi/dlaOBZGFIC0/default.jpg)
![Excel Trick 39 - Get Sum of Multiple Columns or Range Using VLOOKUP #shorts](https://i.ytimg.com/vi/kJx8X3lvxH8/default.jpg)
![How to add a Dynamic & Interactvie Pop-up Calendar in MS Excel (Step-by-Step Tutorial)](https://i.ytimg.com/vi/fzDFP4dKcK4/default.jpg)
![Excel Trick 38 - Conditional Custom Format in MS Excel To Show Numbers in Red/Green #shorts](https://i.ytimg.com/vi/iMeSMohgtpY/default.jpg)
![Excel Trick 37 - How to Insert Multiple Rows or Columns in MS Excel like a Pro #shorts](https://i.ytimg.com/vi/nazKksy8SIo/default.jpg)
![Excel Trick 36 - How to generate automatic serial number in MS Excel when data updated? #shorts](https://i.ytimg.com/vi/59pwHETByds/default.jpg)
![Excel Trick 35 - Master 'Show Report Filter Pages' for Ultimate Data Analysis #shorts](https://i.ytimg.com/vi/fi1cQPd77gM/default.jpg)