![TheDataLabs](/img/default-banner.jpg)
- Видео 200
- Просмотров 12 316 404
TheDataLabs
Индия
Добавлен 7 янв 2017
This channel is dedicated to support the professional community through our experience sharing in Excel, VBA, Dashboard creation, Report generation and Automation techniques. Everything we offer here is freely available, and we don’t engage in any paid training or services.
Comparative Sales Analysis Dashboard in MS Excel & Power Pivot #salesdashboard #comparativeanalysis
Comparative Sales Analysis Dashboard in MS Excel & Power Pivot
In this video, I will walk you through the steps to undestand the Comparative Sales Analysis Dashboard in Micorosft Excel and Power Pivot. This Sales Vs. Target Dashbaord is interactive and provides insights to take business decisions.
You can download the Comparative Sales Analysis Dashboard from the below link.
thedatalabs.org/comparative-sales-analysis-dashboard/
If you are looking for Tempates and Trackers then follow the below link to download it from our website.
thedatalabs.org/category/templates-trackers/
#thedatalabs #Dashboard
Thanks for watching! Please like, share, comment and subscribe. Have a great day!
In this video, I will walk you through the steps to undestand the Comparative Sales Analysis Dashboard in Micorosft Excel and Power Pivot. This Sales Vs. Target Dashbaord is interactive and provides insights to take business decisions.
You can download the Comparative Sales Analysis Dashboard from the below link.
thedatalabs.org/comparative-sales-analysis-dashboard/
If you are looking for Tempates and Trackers then follow the below link to download it from our website.
thedatalabs.org/category/templates-trackers/
#thedatalabs #Dashboard
Thanks for watching! Please like, share, comment and subscribe. Have a great day!
Просмотров: 2 737
Видео
Automated Task & Activity Management Tracker in Excel & VBA (Premium Tool)
Просмотров 44 тыс.7 месяцев назад
Daily Activity Tracker in Excel & VBA (Premium Tool) In this video, I will walk you through the Daily Activity Tracker developed in Excel and VBA. This is the premium tool and it's free of cost for limited time only. You can download the tool from the below link. thedatalabs.org/daily-activity-tracker-in-excel/ #DailyActivityTracker #excelautomation #activitytracker #thedatalabs Correction: In ...
How to Create a Magic Search Box in MS Excel Quickly without VBA?
Просмотров 4,4 тыс.8 месяцев назад
Create a Magical Search Box in MS Excel Quickly without any VBA Code. In this tutorial, we will learn how to create a magic search bar in MS Excel to find records from the large set of records quickly. Download the demo file from the below link. thedatalabs.org/magic-search-box-in-excel/ #thedatalabs #MagicSearch #ExcelTricks Thanks for watching! Please like, share, comment and subscribe. Have ...
How to add a Dynamic & Interactvie Pop-up Calendar in MS Excel (Step-by-Step Tutorial)
Просмотров 4,9 тыс.10 месяцев назад
How to add a Dynamic & Interactvie Pop-up Calendar in MS Excel (Step-by-Step Tutorial)
How to create a Live and Beautiful Analog Clock in Excel using VBA?
Просмотров 5 тыс.11 месяцев назад
How to create a Live and Beautiful Analog Clock in Excel using VBA?
How to create a Data Entry Application using ChatGPT in MS Excel and VBA
Просмотров 18 тыс.Год назад
How to create a Data Entry Application using ChatGPT in MS Excel and VBA
Sales Dashboard In Power BI (Interactive and Dynamic) - Demo
Просмотров 1,6 тыс.Год назад
Sales Dashboard In Power BI (Interactive and Dynamic) - Demo
Interactive Sales Dashboard in MS Excel
Просмотров 30 тыс.Год назад
Interactive Sales Dashboard in MS Excel
How to create Scrollable Table and Chart in MS Excel
Просмотров 14 тыс.Год назад
How to create Scrollable Table and Chart in MS Excel
How to use in-built Translator in Microsoft Excel (Same as Google Translator)?
Просмотров 1,7 тыс.Год назад
How to use in-built Translator in Microsoft Excel (Same as Google Translator)?
How to make an organizational chart in Excel (Quick and Easy Steps updated)
Просмотров 2,5 тыс.Год назад
How to make an organizational chart in Excel (Quick and Easy Steps updated)
Develop Customer Feedback or Survey form in Excel and VBA - Step by Step Tutorial
Просмотров 5 тыс.Год назад
Develop Customer Feedback or Survey form in Excel and VBA - Step by Step Tutorial
VBA To Send Email from Excel with File as Attachment and Image in Mail body - Email Automation
Просмотров 21 тыс.Год назад
VBA To Send Email from Excel with File as Attachment and Image in Mail body - Email Automation
Create SQL Code Executor Application in MS Excel and VBA ( Step by Step)
Просмотров 10 тыс.2 года назад
Create SQL Code Executor Application in MS Excel and VBA ( Step by Step)
How to run UserForm in Full Screen Mode in Excel and VBA
Просмотров 35 тыс.2 года назад
How to run UserForm in Full Screen Mode in Excel and VBA
How to Run UserForm without Showing Excel Window
Просмотров 105 тыс.2 года назад
How to Run UserForm without Showing Excel Window
How to develop an Animated Chart in Excel
Просмотров 18 тыс.2 года назад
How to develop an Animated Chart in Excel
How to Develop a Visitor Data Entry Form in Excel and VBA
Просмотров 12 тыс.2 года назад
How to Develop a Visitor Data Entry Form in Excel and VBA
VBA Code to Identify whether a file exists or Not at given path
Просмотров 6 тыс.2 года назад
VBA Code to Identify whether a file exists or Not at given path
Display a User Form based on Selection In VBA & Excel
Просмотров 9 тыс.2 года назад
Display a User Form based on Selection In VBA & Excel
How to develop live currency converter project in MS Excel and Power Query
Просмотров 3,7 тыс.2 года назад
How to develop live currency converter project in MS Excel and Power Query
Automated Transaction Monitoring Form in Excel and VBA with Dashboard, Auto Email and Other Features
Просмотров 25 тыс.2 года назад
Automated Transaction Monitoring Form in Excel and VBA with Dashboard, Auto Email and Other Features
Multi-Level Drop-Down with a Single Custom Function in Excel and VBA
Просмотров 22 тыс.2 года назад
Multi-Level Drop-Down with a Single Custom Function in Excel and VBA
Automated Customer Order Form ( Google Sheet and Google Apps Script)
Просмотров 41 тыс.2 года назад
Automated Customer Order Form ( Google Sheet and Google Apps Script)
Automated Data Entry Form in Google Sheet and Google Apps Script- Part 4 (Reset & Delete Function)
Просмотров 38 тыс.3 года назад
Automated Data Entry Form in Google Sheet and Google Apps Script- Part 4 (Reset & Delete Function)
Automated Data Entry Form in Google Sheet and Google Apps Script - Part 3 (Edit Function)
Просмотров 43 тыс.3 года назад
Automated Data Entry Form in Google Sheet and Google Apps Script - Part 3 (Edit Function)
Automated Data Entry Form in Google Sheet & Google Apps Script - Part 2 (Search Function)
Просмотров 95 тыс.3 года назад
Automated Data Entry Form in Google Sheet & Google Apps Script - Part 2 (Search Function)
Automated Data Entry Form in Google Sheets & Apps Script - Part 1 (User Form Design & Transfer Code)
Просмотров 848 тыс.3 года назад
Automated Data Entry Form in Google Sheets & Apps Script - Part 1 (User Form Design & Transfer Code)
Time Tracking Sheet in Excel and VBA
Просмотров 43 тыс.3 года назад
Time Tracking Sheet in Excel and VBA
How to Display a Progress Bar in a UserForm in Excel and VBA (Step by Step Tutorial)
Просмотров 36 тыс.3 года назад
How to Display a Progress Bar in a UserForm in Excel and VBA (Step by Step Tutorial)
gffI hathe
Thank you
Hi Dilip, thanks you so much for sharing your wealth of knowledge. I'm wondering whether you might know why my PDF files don't appear in the folder until I publish another file to pdf
Kindly someone tell me that From Where these two Columns Input has taken *Submitted By* and *Submitted On* ?
Can't download
Sorry for the inconvenience. Will fix the link. Thanks!
how can I have multiple dynamic combobox
Why you substracted purchase values from total sales to calculate revenue. Revenue itself says overall sales of a company. That means, Summing up the sales column gives you the total revenue of the organisation.
Hi! Quick question: When I press the Search button, my database sheet is filtering the data I'm searching but I'm getting the error 1004: Unable to get the Match property of the WorksheetFunction class to the code line: iCount = Application.WorksheetFunction.Match(sColumn, shDatabase.Range("A1:I1"), 0). Can someone help me with this? Thank you.
Not free
How can we lock the sheets? It’s still editable
Unfortunately, it can not be downloaded for free and asking for payment. 😅
😅😅
Perhaps I didn't follow correctly but at the moment I, "try" the button I get an error msg, "Microsoft Visual Basic Run-time error '380': Could not set the RowSource property. Invalid property value." Any suggestions? Thank you.
Hai bro...for me while press play its showing run-time error‘424’. object required..please help to solve this issue💐
good , saudi riyad.
Brother I got error in this problem can u Plss correct it
Plzz in hindi
but when you delete for example the data in (Serial No.) S No. 5, the the succeeding number which is number 6 will go up but it will not update to become number 5, why is this?
Hi ... I am getting Database Error - Either BOF or EOF is True or the current record has been deleted. Requested operation requires a current record.3021 Please Note- I follow the video and the correctly but still getting this entry As I am entering data on Userform and transferring it to MS Access Database At present the database is empty Please help in resolving the code
This tutorial is so easy to follow and fun! Thank you!
1st 5 mint are wasting Time
Great big help!!! Thank you!!!
Is very good, thank you.
Thank you for creating this excellent tutorial.. Your instructions were excellent. I made many mistakes but only due to my poor spelling and thinking too much. I had setup a table for my Database sheet, this was a mistake and once I deleted it everything ran perfect. Thank you, and God bless you. I would like to find a way to collect a signature for my print before exporting to pdf as a record of receipt... something to think about.:).... again thank you.
Hi @thedatalabs can you please create another video how you create this form starting from new sheet.
Very helpful. Two things: Why did Excel say "Authentication Failed," and how did you not notice you left a ' in that field?
Pls upload making video.
Sir can you share VBA Password
can we do the same in google sheets ?
well
This is amazing! How can we protect the database sheet please? Is there a code suggested? Thanks!
thanks nice.....please make automatic invoice tutorial
Share Link to Download please
What if we have one month data by date and table not named as date
Can you make the start and end time lockable so that they can't manipulate the data?
I'm loving this! Thank you Dilip!!!
Worked for a couple of hours with copilot/chat gpt but it could not come up wth this :) good work, thank you.
Hi. there seems to be a problem with your calendar. If you select a day between 1-12, say for example I need to input May 8, 2024, if I click on the month and day, it will automatically proceed to month of August. Same goes until 12, it will automatically proceed to month of December. But the rest day 13-30 is good. Hope you can fix it. Thank you!
Where did u put the textID, is it hidden .?
EXCELLENT SIR
Thanks Very Much the Sample File to easy follow you, step by step video thanks very much
My header start from 4th row
How to set 4 row for header
wow, thanks
but we don't use office 365? how can we search in sheet1 using 3 textboxes searching project, date from and date to from the table in sheet2. And by clicking the button, the concatenated last name and first name from different columns in sheet2, rating and final rating will be displayed in sheet1 table.