- 67
- 670 032
Excelibur
India
เข้าร่วมเมื่อ 31 พ.ค. 2018
Excel Hacks : Learn Excel : Excel Made Easy : Excel Help : Macros : Excel Automation : Excel VBA
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
Link to Data studio :
datastudio.google.com/
Link to Google Sheets:
docs.google.com/spreadsheets/create
มุมมอง: 538
วีดีโอ
Pivot table in 10 minutes | Slicers | Pivot charts | Pro tips
มุมมอง 801ปีที่แล้ว
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.1Kปีที่แล้ว
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 th-cam.com/video/JG_-L1axIgU/w-d-xo.html Day2 : Quick Execute - Excel Buttons and Custom tabs th-cam.com/video/Ca0RFUelAuQ/w-d-xo.html Day3 : Smart Notification...
Day3 : Smart Notification System - Message Box in Excel
มุมมอง 1.1Kปีที่แล้ว
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 th-cam.com/vid...
Day2 : Quick Execute - Excel Buttons and Custom tabs
มุมมอง 1.9Kปีที่แล้ว
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.2Kปีที่แล้ว
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
มุมมอง 29K2 ปีที่แล้ว
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 : th-cam.com/video/pm0IILyzXco/w-d-xo.html
Send WhatsApp Messages from Google Sheets
มุมมอง 11K2 ปีที่แล้ว
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 : th-cam.com/video/u8R1tXXFPPs/w-d-xo.html
How to use Google Sheets Templates | Download & use FREE Templates from Internet
มุมมอง 3922 ปีที่แล้ว
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.2K2 ปีที่แล้ว
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
มุมมอง 11K2 ปีที่แล้ว
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 !
มุมมอง 1792 ปีที่แล้ว
Join the Excel Automation Bootcamp : excelautomationacademy.com/
Jugnu Challenge in Excel
มุมมอง 1402 ปีที่แล้ว
#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.8K3 ปีที่แล้ว
Macro to Browse and Copy data from one sheet to another excel sheet
Generate Sound Alerts in Excel | Beep Sound in Excel
มุมมอง 18K3 ปีที่แล้ว
Generate Sound Alerts in Excel | Beep Sound in Excel
Create Automatic Cell Blinking in Excel
มุมมอง 31K3 ปีที่แล้ว
Create Automatic Cell Blinking in Excel
Create buttons in google sheets and run macros
มุมมอง 3K3 ปีที่แล้ว
Create buttons in google sheets and run macros
Google forms to Excel sheet automatically
มุมมอง 221K4 ปีที่แล้ว
Google forms to Excel sheet automatically
Export PDF from Excel on a Button Click using VBA | Auto PDF file naming
มุมมอง 24K4 ปีที่แล้ว
Export PDF from Excel on a Button Click using VBA | Auto PDF file naming
Tq
Welcome
Can u share the link
@siddharthacal : "api.whatsapp.com/send?phone="&C2&"&text="&encodeurl(E2)
How to save Macro as a VBA PPT Add in and use that Add In for running Macro in any PPT. Not to plug in VBA code each time.
Can i run a Macro to change a number to Text, so find No 1 & replace with Egypt, Find No 2 & replace with China . i have tried to make a macro to change the numbers to text but all it does is find a number. i have numbers 1-8 and 8 Country names.?. Thank you in advance, sorry using google spreadsheets.
@rock0122 : You can try using a select case statement for this purpose. For each number you can specify a country. Refer to this link for better understanding : learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/select-case-statement
Followed your code but the values are showing on my original data sheet and not the new report sheet. Any ideas why this happened?
@tacosmargs58 : Firstly thank you for watching the video ! Possibly you could check the following : 1 . Make sure that the code is executing . For this use a message box in the code and see if that shows up. 2. Check if you have the data in same cells of the sheet as in your code or are you referring to the correct sheet. 3. Also, check that you select a row before hitting the button to execute the code.
Useless video You mentioned automatic
What is the limit of no. Of chats
🎉 it's working, love you brother
Beast!!
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?
@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
@@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.
@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
@@ExceliburVideos Thank you I will try experimenting with it - legend.
Thank you too ! Have fun :)
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.)
Great tutorial! Thanks.
How to send the message at once to all the people.
Heloo, can you do it in Libre Office calc?.. i usually use hat..
thank u
Thank you so much, I was struggling so much, God bless you with good fortune ❤️❤️❤️❤️
I did downlaod the responses its in raw form...how do I take from that to just number form , to do pilot tests ?
YOu know what.. for the same work there are bunch of softwares are working.. you saved litterally $50 per month for my business.
Good to know that ! :)
Not working
Thanks for this very very useful video!!!
Need the code
@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
Intro volume: 100% The person talking: 10%
Noted 👍
very helpful
Glad to hear that
Very useful
Thank you !
Thanks for the tutorial. It was exactly what I needed
Glad it was helpful 😀
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?
You can use Pivot tables for your case and try to achieve the desired result.
Perfect! Just what I was looking for
Glad to know it was helpful !
GREAT AND MAIN THING YOU ARE NOT KILLING TIME HERE AND THERE
Thanks for the viewing & the feedback !
Thanks a lot ❤
My in responses download response.csv file is not showing up
Great vedio, Keep up the good work
Thanks!
how to automate this
Thank You Bro ❤
I learnt so much from this valued lesson. Thank you so much.
Glad that you learnt something new !
Thanks for the wonderful, simple video. This is very useful.
You are welcome!
@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?
This could be possible, although I havent tried it yet. :)
do you have the video guide on how you did the Generate report card?
@NBH2023 - Please see the following video to see how a report card is generated th-cam.com/video/CvqjH0Ptk-k/w-d-xo.html
very interesting, thanks
You're welcome
omg, this is too funny! the dancing is killin' me! 🤣🤣🤣🤣🤣🤣
Thank you!!
Thank you so much Brother :)
You are welcome !
Useless video
This is very useful and informative !
@tanukadey : Thanks for the feedback.
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
Where did you get the little window that says "Generate Report"
@user-rn9mv7yz7h : This is a button in Microsoft Excel. To learn how to create and use a button, please view the following videos.
th-cam.com/video/noQp3C1IsQg/w-d-xo.html th-cam.com/video/DjiwjUWNNVg/w-d-xo.html
Thank you. Apparently, my Excel program is too old; it does not have the DEVELOPER etc tabs.@@ExceliburVideos
It's free are not
@RUTHVIKTEJASR - Yes, its completely free !
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
@Princess_Rojin : Thanks for watching the video. Please try Sheets("card").activate
Also, please check the following link for clarity on how buttons work in Excel th-cam.com/video/DjiwjUWNNVg/w-d-xo.html
Same issue!! I've written Sheets ("Card"). Activate But still it's showing in the same Data sheet..
Thank you!
You're welcome!
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
@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.
Need Text Blinking permanently when open the excel sheet
@rramesh969 Use the code on the worksheet open event