TheDataLabs
TheDataLabs
  • Видео 200
  • Просмотров 12 316 404
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!
Просмотров: 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)

Комментарии

  • @hashimalsindee9113
    @hashimalsindee9113 7 часов назад

    gffI hathe

  • @mehdibakhtiari300
    @mehdibakhtiari300 20 часов назад

    Thank you

  • @user-cm9co3ob3g
    @user-cm9co3ob3g 23 часа назад

    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

  • @pizzazonenadiad2429
    @pizzazonenadiad2429 2 дня назад

    Kindly someone tell me that From Where these two Columns Input has taken *Submitted By* and *Submitted On* ?

  • @dipokmodak8896
    @dipokmodak8896 4 дня назад

    Can't download

    • @thedatalabs
      @thedatalabs День назад

      Sorry for the inconvenience. Will fix the link. Thanks!

  • @TGTube-ls8cm
    @TGTube-ls8cm 5 дней назад

    how can I have multiple dynamic combobox

  • @PK-iu9nc
    @PK-iu9nc 5 дней назад

    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.

  • @PopoyTanke
    @PopoyTanke 6 дней назад

    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.

  • @Simz-dr5tb
    @Simz-dr5tb 7 дней назад

    Not free

  • @nerlierosepangan584
    @nerlierosepangan584 7 дней назад

    How can we lock the sheets? It’s still editable

  • @myothiha6151
    @myothiha6151 8 дней назад

    Unfortunately, it can not be downloaded for free and asking for payment. 😅

    • @rku6449
      @rku6449 10 часов назад

      😅😅

  • @freepilot7732
    @freepilot7732 8 дней назад

    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.

  • @limoshbs
    @limoshbs 9 дней назад

    Hai bro...for me while press play its showing run-time error‘424’. object required..please help to solve this issue💐

  • @FarukHossain-ux7bn
    @FarukHossain-ux7bn 10 дней назад

    good , saudi riyad.

  • @ashishkothari8469
    @ashishkothari8469 10 дней назад

    Brother I got error in this problem can u Plss correct it

  • @ravishankar-sg9ry
    @ravishankar-sg9ry 11 дней назад

    Plzz in hindi

  • @mrwatcherofmovies
    @mrwatcherofmovies 11 дней назад

    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?

  • @jaisilon
    @jaisilon 13 дней назад

    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

  • @SheenaMauhay
    @SheenaMauhay 13 дней назад

    This tutorial is so easy to follow and fun! Thank you!

  • @mstechnical1937
    @mstechnical1937 15 дней назад

    1st 5 mint are wasting Time

  • @juonariobaterzal6063
    @juonariobaterzal6063 15 дней назад

    Great big help!!! Thank you!!!

  • @nellylee1952
    @nellylee1952 16 дней назад

    Is very good, thank you.

  • @SrMalgato
    @SrMalgato 17 дней назад

    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.

  • @vikasagarwal7323
    @vikasagarwal7323 17 дней назад

    Hi @thedatalabs can you please create another video how you create this form starting from new sheet.

  • @broderp
    @broderp 17 дней назад

    Very helpful. Two things: Why did Excel say "Authentication Failed," and how did you not notice you left a ' in that field?

  • @winningwings
    @winningwings 17 дней назад

    Pls upload making video.

  • @AjeetShukla-zf9gs
    @AjeetShukla-zf9gs 18 дней назад

    Sir can you share VBA Password

  • @kriti4698
    @kriti4698 20 дней назад

    can we do the same in google sheets ?

  • @MANAVSARKAR-jc9kp
    @MANAVSARKAR-jc9kp 20 дней назад

    well

  • @nerlierosepangan584
    @nerlierosepangan584 23 дня назад

    This is amazing! How can we protect the database sheet please? Is there a code suggested? Thanks!

  • @user-et9rq8po4g
    @user-et9rq8po4g 24 дня назад

    thanks nice.....please make automatic invoice tutorial

  • @iZacq
    @iZacq 25 дней назад

    Share Link to Download please

  • @AhmedMohammed-cx5ho
    @AhmedMohammed-cx5ho 26 дней назад

    What if we have one month data by date and table not named as date

  • @xjuux548
    @xjuux548 27 дней назад

    Can you make the start and end time lockable so that they can't manipulate the data?

  • @latanyaalexandre9324
    @latanyaalexandre9324 28 дней назад

    I'm loving this! Thank you Dilip!!!

  • @justinoz06
    @justinoz06 28 дней назад

    Worked for a couple of hours with copilot/chat gpt but it could not come up wth this :) good work, thank you.

  • @AndrewLouieBusog
    @AndrewLouieBusog 28 дней назад

    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!

  • @papalongsvideos3046
    @papalongsvideos3046 29 дней назад

    Where did u put the textID, is it hidden .?

  • @omkarnathkaja300
    @omkarnathkaja300 29 дней назад

    EXCELLENT SIR

  • @sumardjo
    @sumardjo 29 дней назад

    Thanks Very Much the Sample File to easy follow you, step by step video thanks very much

  • @royaljatt2001
    @royaljatt2001 29 дней назад

    My header start from 4th row

  • @user-jz1zw2ez4i
    @user-jz1zw2ez4i Месяц назад

    wow, thanks

  • @hinata6757
    @hinata6757 Месяц назад

    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.