Excelibur
Excelibur
  • 67
  • 646 321
Create Interactive Dashboards using Google Data Studio
This video demonstrates how to create interactive dashboards using google data studio in 10 minutes for FREE !
Link to Data studio :
datastudio.google.com/
Link to Google Sheets:
docs.google.com/spreadsheets/create
Переглядів: 411

Відео

Pivot table in 10 minutes | Slicers | Pivot charts | Pro tips
Переглядів 796Рік тому
This video explains how to create pivot table in 10 minutes, slicers, pivot charts and work with different settings of pivot table is excel. 00:00 Introduction 00:27 Pivot tables 09:17 Creating groups 10:39 Slicers 12:57 Pivot charts 16:24 Removing blank cells 17:18 Shortcuts
Day4 : Cojoint Inputs - Interactive User Form in Excel
Переглядів 1,1 тис.Рік тому
Create Forms inside your Workbook. Learn the procedure for loading of Forms and how to make interactive user form in excel to take user inputs. Quiz Link : forms.gle/GTd94qpy3zvaUM9h7 Day 1: Day1 : Auto Code Way - Basics of Excel Macros ua-cam.com/video/JG_-L1axIgU/v-deo.html Day2 : Quick Execute - Excel Buttons and Custom tabs ua-cam.com/video/Ca0RFUelAuQ/v-deo.html Day3 : Smart Notification S...
Day3 : Smart Notification System - Message Box in Excel
Переглядів 1,1 тис.Рік тому
Make your own Message Box in Excel. Also learn how to customize message box in excel as required. Get an insight into various Workbook & Worksheet events. Quiz Link : forms.gle/YnGfXeHeo6KyECrY8 Please use the comments section for questions 00:00 Introduction 00:52 Message box syntax 04:12 Activation on events 08:57 Ok & Cancel Day 1: Day1 : Auto Code Way - Basics of Excel Macros ua-cam.com/vid...
Day2 : Quick Execute - Excel Buttons and Custom tabs
Переглядів 1,8 тис.Рік тому
Understand the different types of Buttons and their Customization, how to create your own Buttons and assign Macros to them. Also, learn how to create your own Tabs, Shortcuts and Quick Access Links. Quiz Link : forms.gle/iT2ufsuCZfEiRFRC9 Please use the comments section for questions 00:00 Introduction 00:33 Recap Day 1 00:48 Buttons - Type & Customization 04:35 Run Macro with button 06:50 Ima...
Day1 : Auto Code Way - Basics of Excel Macros
Переглядів 3,2 тис.Рік тому
Learn excel macros starting from the basic settings, Sheet Security , Workbook Configuration. By the end of the day you will be able to Record and Run your own Macros in excel. Quiz Link : forms.gle/12DFPAkGFKUsCzS29 Please use the comments section for questions 00:00 Introduction 02:04 Basics & Setup 03:31 Activate developer tab 04:26 Macro settings 06:42 Record macro 12:23 Relative References...
Send Customized WhatsApp Messages from Google Sheets | Bulk Messaging
Переглядів 27 тис.Рік тому
This video will show you the procedure to create customized WhatsApp messages and send them directly from google sheets. Also, see : Send WhatsApp Message from Google Sheets : ua-cam.com/video/pm0IILyzXco/v-deo.html
Send WhatsApp Messages from Google Sheets
Переглядів 10 тис.Рік тому
This video will show you the procedure to send WhatsApp messages from google sheets directly. The url required to send the message is below : api.whatsapp.com/send?phone=xxxxtext=yyyy Also, see : Sending Customized messages from Google Sheets : ua-cam.com/video/u8R1tXXFPPs/v-deo.html
How to use Google Sheets Templates | Download & use FREE Templates from Internet
Переглядів 3692 роки тому
This video shows how to use the default Google Sheet Templates and also how you can search on the internet and use FREE templates Learn the techniques to work faster 🏃‍♂️without having to remember 🧠 formulas, with the use of macros! - ABSOLUTELY FREE ! Join my Excel Automation Bootcamp to: ✅ Make your excel sheets more *attractive and interactive* ✅ Get results on a *single button click*? ✅ Red...
Introduction to Google Sheets for beginners
Переглядів 1,1 тис.2 роки тому
Start your journey with Google Sheets.. Introduction to the Google sheets - Opening, Naming, Menus & Options Learn the techniques to work faster 🏃‍♂️without having to remember 🧠 formulas, with the use of macros! - ABSOLUTELY FREE ! Join my Excel Automation Bootcamp to: ✅ Make your excel sheets more *attractive and interactive* ✅ Get results on a *single button click*? ✅ Reduce your time spent o...
Automate Macros to RUN based on Time
Переглядів 11 тис.2 роки тому
This video helps you understand and automate macros based on time Learn the techniques to work faster 🏃‍♂️without having to remember 🧠 formulas, with the use of macros! - ABSOLUTELY FREE ! Join my Excel Automation Bootcamp to: ✅ Make your excel sheets more *attractive and interactive* ✅ Get results on a *single button click*? ✅ Reduce your time spent on excel sheets by *70%* Join the Excel Auto...
Thank You Video !
Переглядів 1782 роки тому
Join the Excel Automation Bootcamp : excelautomationacademy.com/
Jugnu Challenge in Excel
Переглядів 1382 роки тому
#jugnuchallenge #jugnu #badboyshah This video shows a way in which we can create the famous Jugnu Challenge in Excel. To watch the complete video with music click on the following link : excelautomationacademyreel/CW-5gjprtnw/
Macro to Browse and Copy data from one sheet to another excel sheet
Переглядів 2,7 тис.2 роки тому
Macro to Browse and Copy data from one sheet to another excel sheet
Generate Sound Alerts in Excel | Beep Sound in Excel
Переглядів 18 тис.3 роки тому
Generate Sound Alerts in Excel | Beep Sound in Excel
Create Automatic Cell Blinking in Excel
Переглядів 30 тис.3 роки тому
Create Automatic Cell Blinking in Excel
Remove Grid Lines in Excel
Переглядів 2513 роки тому
Remove Grid Lines in Excel
Animation in Excel
Переглядів 2,2 тис.3 роки тому
Animation in Excel
Camera in Excel
Переглядів 1893 роки тому
Camera in Excel
Real time stock data in Excel
Переглядів 3823 роки тому
Real time stock data in Excel
Create Keyboard Shortcuts in Excel
Переглядів 11 тис.3 роки тому
Create Keyboard Shortcuts in Excel
Create buttons in google sheets and run macros
Переглядів 2,8 тис.3 роки тому
Create buttons in google sheets and run macros
Automate Google Sheet with Macro
Переглядів 24 тис.3 роки тому
Automate Google Sheet with Macro
Google forms to Excel sheet automatically
Переглядів 212 тис.3 роки тому
Google forms to Excel sheet automatically
Jump between sheets in Excel - 3 ways
Переглядів 1743 роки тому
Jump between sheets in Excel - 3 ways
Export PDF from Excel on a Button Click using VBA | Auto PDF file naming
Переглядів 24 тис.4 роки тому
Export PDF from Excel on a Button Click using VBA | Auto PDF file naming
Generate Automatic Reports in Excel
Переглядів 92 тис.4 роки тому
Generate Automatic Reports in Excel
How to Track Changes in Excel
Переглядів 1114 роки тому
How to Track Changes in Excel
Create Microsoft Word macros
Переглядів 1,3 тис.4 роки тому
Create Microsoft Word macros
How to use PowerPoint Macros VBA
Переглядів 148 тис.4 роки тому
How to use PowerPoint Macros VBA

КОМЕНТАРІ

  • @amanjuyal3379
    @amanjuyal3379 19 днів тому

    What is the limit of no. Of chats

  • @abdulmuiz1224
    @abdulmuiz1224 Місяць тому

    🎉 it's working, love you brother

  • @ramontremosapons4787
    @ramontremosapons4787 Місяць тому

    Beast!!

  • @DS-cf1zc
    @DS-cf1zc Місяць тому

    How easy would it be to extend the report card function to say produce an automated paragraph that sets out how the student is performing - So as means of an example. Using the Sorabh example in the video We have found that Sorabh has performed well in Physical Education, Maths and Hindi, but could focus on improving English and Science. So the paragraph is contextualised to what the report card is showing - Do you have any ideas?

    • @ExceliburVideos
      @ExceliburVideos Місяць тому

      @DS-cf1zc : Thanks for watching the video and conceptualizing the further ideas. What you suggest is surely possible. Using a code in the script , you can easily identify by comparison, the weak subjects ( lets say score below 60 ) and in the end create a message box or write a text in a cell what you desire. The text will be majorly static and only the subjects can be variable which come out from the comparison function

    • @DS-cf1zc
      @DS-cf1zc Місяць тому

      @@ExceliburVideos Thank you - have you got a video of how you could do this - or could you put together one that shows me how it could be done? I think once i have seen one way of doing it - I suspect I could adapt it.

    • @ExceliburVideos
      @ExceliburVideos Місяць тому

      @DS-cf1zc : please add this code (tested) . Its just a basic code but can be improvised and improved further : Dim a,b,c,d,e If Smarks1 < 60 Then a = "English" End If If Smarks2 < 60 Then b = "Hindi" End If If Smarks3 < 60 Then c = "Science" End If If Smarks4 < 60 Then d = "Maths" End If If Smarks5 < 60 Then e = "PE" End If Cells(15, 3).Value = "Student needs improvement in : " & a & " " & b & " " & c & " " & d & " " & e

    • @DS-cf1zc
      @DS-cf1zc Місяць тому

      @@ExceliburVideos Thank you I will try experimenting with it - legend.

    • @ExceliburVideos
      @ExceliburVideos 25 днів тому

      Thank you too ! Have fun :)

  • @omnipop4936
    @omnipop4936 Місяць тому

    Will this code really keep working even when the workbook is closed and then re-opened? I did an Application OnTime macro last week (to run another macro) at a certain time of day, and it worked. But when I changed the time and closed / re-opened the workbook, it didn't run the macro when the new time arrived. I had to insert a separate Workbook Open event, to call the Application OnTime macro whenever the workbook is re-opened. 🤷‍♂ (I'd hate to have to do a Workbook Open call to every individual timer macro.)

  • @omnipop4936
    @omnipop4936 Місяць тому

    Great tutorial! Thanks.

  • @mohitvishwakarma1
    @mohitvishwakarma1 Місяць тому

    How to send the message at once to all the people.

  • @TheMarkdo1980
    @TheMarkdo1980 Місяць тому

    Heloo, can you do it in Libre Office calc?.. i usually use hat..

  • @lasanthirajapaksha9027
    @lasanthirajapaksha9027 Місяць тому

    thank u

  • @athaliangcwangu5533
    @athaliangcwangu5533 2 місяці тому

    Thank you so much, I was struggling so much, God bless you with good fortune ❤️❤️❤️❤️

  • @jayesoteric9106
    @jayesoteric9106 2 місяці тому

    I did downlaod the responses its in raw form...how do I take from that to just number form , to do pilot tests ?

  • @motivation-mantra
    @motivation-mantra 2 місяці тому

    YOu know what.. for the same work there are bunch of softwares are working.. you saved litterally $50 per month for my business.

  • @kiranarana7274
    @kiranarana7274 2 місяці тому

    Not working

  • @Omwereru
    @Omwereru 3 місяці тому

    Thanks for this very very useful video!!!

  • @jasonclarkcarbon5456
    @jasonclarkcarbon5456 3 місяці тому

    Need the code

    • @ExceliburVideos
      @ExceliburVideos 3 місяці тому

      @jasonclarkcarbon5456 : The code is below Sub test() Sheets("Data").Activate i = ActiveCell.Row Dim Sfirstname Dim Slastname Dim SRoll Dim Sclass Dim Smarks1 Dim Smarks2 Dim Smarks3 Dim Smarks4 Dim Smarks5 Sfirstname = Cells(i, 3).Value Slastname = Cells(i, 4).Value SRoll = Cells(i, 5).Value Sclass = Cells(i, 2).Value Smarks1 = Cells(i, 6).Value Smarks2 = Cells(i, 7).Value Smarks3 = Cells(i, 8).Value Smarks4 = Cells(i, 9).Value Smarks5 = Cells(i, 10).Value '*************************************************** Sheets("Report Card").Activate Cells(3, 3).Value = Sfirstname & " " & Slastname Cells(4, 3).Value = SRoll Cells(5, 3).Value = Sclass Cells(8, 4).Value = Smarks1 Cells(9, 4).Value = Smarks2 Cells(10, 4).Value = Smarks3 Cells(11, 4).Value = Smarks4 Cells(12, 4).Value = Smarks5 End Sub

  • @cid2087
    @cid2087 3 місяці тому

    Intro volume: 100% The person talking: 10%

  • @ExtensionWithoutBorders
    @ExtensionWithoutBorders 4 місяці тому

    very helpful

  • @gamestechandmovies6207
    @gamestechandmovies6207 4 місяці тому

    Very useful

  • @davidloop5437
    @davidloop5437 4 місяці тому

    Thanks for the tutorial. It was exactly what I needed

  • @meganathann3205
    @meganathann3205 4 місяці тому

    Hii!! I have different data for different scenario, i have different template for each scenario, i need excel which when selected the scenario it will show the data needs to be filled for the scenario and it should give the sentence with the template with entered data for that scenario, can you please help me with this?

    • @ExceliburVideos
      @ExceliburVideos 4 місяці тому

      You can use Pivot tables for your case and try to achieve the desired result.

  • @ENTN8
    @ENTN8 4 місяці тому

    Perfect! Just what I was looking for

  • @AZIMUDDINAHMAD-c3y
    @AZIMUDDINAHMAD-c3y 4 місяці тому

    GREAT AND MAIN THING YOU ARE NOT KILLING TIME HERE AND THERE

    • @ExceliburVideos
      @ExceliburVideos 4 місяці тому

      Thanks for the viewing & the feedback !

  • @KACS.KODIKARA
    @KACS.KODIKARA 5 місяців тому

    Thanks a lot ❤

  • @bibinjacob846
    @bibinjacob846 5 місяців тому

    My in responses download response.csv file is not showing up

  • @RavindraSingh-pr3rt
    @RavindraSingh-pr3rt 5 місяців тому

    Great vedio, Keep up the good work

  • @vivekmishra8
    @vivekmishra8 5 місяців тому

    how to automate this

  • @rutvikprajapati6030
    @rutvikprajapati6030 6 місяців тому

    Thank You Bro ❤

  • @HaseenaChandni
    @HaseenaChandni 6 місяців тому

    I learnt so much from this valued lesson. Thank you so much.

  • @vijisuresh1962
    @vijisuresh1962 6 місяців тому

    Thanks for the wonderful, simple video. This is very useful.

  • @paddyofurniture3988
    @paddyofurniture3988 6 місяців тому

    @Excelibur I was told I could leverage these VBA to simulate or group multiple animation on ONE object, so I could use that object on different slides??? Does that sound remotely possible?

    • @ExceliburVideos
      @ExceliburVideos 6 місяців тому

      This could be possible, although I havent tried it yet. :)

  • @NBH2023
    @NBH2023 7 місяців тому

    do you have the video guide on how you did the Generate report card?

    • @ExceliburVideos
      @ExceliburVideos 6 місяців тому

      @NBH2023 - Please see the following video to see how a report card is generated ua-cam.com/video/CvqjH0Ptk-k/v-deo.html

  • @pAULEE_wORLi
    @pAULEE_wORLi 7 місяців тому

    very interesting, thanks

  • @MoniMeka
    @MoniMeka 7 місяців тому

    omg, this is too funny! the dancing is killin' me! 🤣🤣🤣🤣🤣🤣

  • @leannesmith1059
    @leannesmith1059 7 місяців тому

    Thank you!!

  • @jiteshsharma8306
    @jiteshsharma8306 8 місяців тому

    Thank you so much Brother :)

  • @henryhoang4538
    @henryhoang4538 8 місяців тому

    Useless video

  • @tanukadey1038
    @tanukadey1038 8 місяців тому

    This is very useful and informative !

    • @ExceliburVideos
      @ExceliburVideos 8 місяців тому

      @tanukadey : Thanks for the feedback.

  • @MohammadAsif-pr5el
    @MohammadAsif-pr5el 8 місяців тому

    sir meri data entry ki job hai ek ek karke forms fill karne hote hain koi tarika bataye data ek saath copy ho jaaye forms mei

  • @MaurineRamos-k1e
    @MaurineRamos-k1e 8 місяців тому

    Where did you get the little window that says "Generate Report"

    • @ExceliburVideos
      @ExceliburVideos 8 місяців тому

      @user-rn9mv7yz7h : This is a button in Microsoft Excel. To learn how to create and use a button, please view the following videos.

    • @ExceliburVideos
      @ExceliburVideos 8 місяців тому

      ua-cam.com/video/noQp3C1IsQg/v-deo.html ua-cam.com/video/DjiwjUWNNVg/v-deo.html

    • @MaurineRamos-k1e
      @MaurineRamos-k1e 8 місяців тому

      Thank you. Apparently, my Excel program is too old; it does not have the DEVELOPER etc tabs.@@ExceliburVideos

  • @RUTHVIKTEJASR
    @RUTHVIKTEJASR 9 місяців тому

    It's free are not

    • @ExceliburVideos
      @ExceliburVideos 9 місяців тому

      @RUTHVIKTEJASR - Yes, its completely free !

  • @Rojin.Marzooki
    @Rojin.Marzooki 9 місяців тому

    I followed the instructions, but the data was entered in the cells of the same sheet not in the second sheet although iam sure that i wrote activate the second sheet. What is the problem I wrote: sheet(“card”).activate But nothing was written in it It was written in the data sheet cells…. But also you didn’t show how you connected the code to the button. I did insert command button and added the code to when click on it

    • @ExceliburVideos
      @ExceliburVideos 9 місяців тому

      @Princess_Rojin : Thanks for watching the video. Please try Sheets("card").activate

    • @ExceliburVideos
      @ExceliburVideos 9 місяців тому

      Also, please check the following link for clarity on how buttons work in Excel ua-cam.com/video/DjiwjUWNNVg/v-deo.html

    • @SamSam_249
      @SamSam_249 3 місяці тому

      Same issue!! I've written Sheets ("Card"). Activate But still it's showing in the same Data sheet..

  • @Ppanos423
    @Ppanos423 9 місяців тому

    Thank you!

  • @johnson863
    @johnson863 9 місяців тому

    How to save the output file on the same path wherever we maintain the excel macro.. pls help Even if i move the excel to any path, the output must generate on same path

    • @ExceliburVideos
      @ExceliburVideos 9 місяців тому

      @johnson863 : The path of the PDF file is defined in the macro code. You are free to modify\define this path on your own. This will allow you to generate the report on the same path irrespective of the excel file.

  • @rramesh969
    @rramesh969 10 місяців тому

    Need Text Blinking permanently when open the excel sheet

    • @ExceliburVideos
      @ExceliburVideos 9 місяців тому

      @rramesh969 Use the code on the worksheet open event

  • @fildzahfifi3068
    @fildzahfifi3068 10 місяців тому

    Hi, why my macro is not working? need to debug, but im not sure which one is wrong, mind to help me?

  • @dnahealthcarestudies
    @dnahealthcarestudies 10 місяців тому

    how to sent image ?

  • @AnjaliKumari-vd3rl
    @AnjaliKumari-vd3rl 10 місяців тому

    Thank you so much sir

  • @asifosman
    @asifosman 11 місяців тому

    How to automate this?

  • @bernardweber142
    @bernardweber142 Рік тому

    Is it also possible to select a radio button via vba?

  • @SameerGoyal-su9cx
    @SameerGoyal-su9cx Рік тому

    Nice video sir... I want to insert images in ppt so what is the VBA code for that? please tell me