Видео

@mayurnaik8038 Thanks Mayur! 😊

@SaunakDey thanksss Saunak! 😊

@pascalcrblancquaert4058 thank you Pascal for the kind message. I m happy i m able to pass on the knowledge i accumulated all these years 😊

Thanks for the feedback Kathy :)

Hey Cara, I believe there is a comment below with the same question. try the answer i provided :)

@alishasong3847 Yes, it is possible to connect two slicers if they are based on the same data source. Here's how you can do it: Steps to Connect Slicers: Ensure Both Slicers Are Based on the Same Data Model: Both the map table and pivot table need to come from the same dataset or data model in Excel. This is essential for slicers to interact with each other. Create Relationships (if applicable): If you're using a data model with multiple tables, make sure there is a proper relationship established between the tables in the Power Pivot data model. Add Slicers: Add slicers to your map and pivot table if you haven’t already. Go to the Insert tab → Slicer. Connect the Slicers: Select one slicer. Go to the Slicer tab on the ribbon. Click on Report Connections (or PivotTable Connections in older versions). A dialog box will open, showing all the pivot tables that can be connected to this slicer. Check the boxes for all relevant pivot tables (including the one used for your map and the other charts). Test the Connection: Now, when you use the slicer, it should filter both the map and the pivot table charts simultaneously. Note: If the map is not updating, verify that it is dynamically linked to the same data source. For advanced interactions, consider using Power BI, which offers more robust slicer functionality across visualizations.

@@ronqmo8755 am happy it s useful 😊

@travisalejandro6690 in the past i used to put the sentence in google translate and copy paste 😅

@EXCELWIZARDINMINUTES well, it sucks that Microsoft don't really make effort in integrating AI into office, so we have to use chatgpt separately since it's preferably in creating more natural sentences. So yeah, copy-paste will not extinct in near future.

Great i helped ! 😊

@@mra893 graciasssss :)

Thanksss :)

@@surjagain thanksss :)))

😊

@@alfeocayabyab8233 i m happy i helped 😊

@vittorialaudani5140 hello vittoria. Ur timing is perfect. I am editing a new vrp video that will come out next monday. It will use google maps api instead of bing to solve. For the time being you can use this to do the step the vrp solver needs. Otherwise just bare with me for 7 days and u ll get a new vrp solver...u can subscribe and put notifications on so u know when the video is out. But it s definately next monday...let me know if this works....

@@EXCELWIZARDINMINUTES that's great, I'll try with the Google api but I will surely watch your next tutorial too

@vittorialaudani5140 basically in the vrp sheet, u need lat long for 1 sheet and the distance and time between each combination of locations. This excel can give you all this. And u can copy paste them. However be aware than in the vrp solver, u need the times in days (u need to convert min to days. Ie /60/24). The simplest thing is just to wait 7 days. Then in 5 min, u can do vrp :))

there is the new video: ruclips.net/video/1z-nTTYdTcY/видео.html Plz like it and comment if possible :)))

Welcome!😊

@tanakornpromthep9025 always nice to hear such nice words 😀

@humanbeing888 hard to achieve the same functionality. Vba coding might help though

@CVgeek To add an image in the body of an email sent using VBA, you can use the HTMLBody property of the email object in combination with HTML to embed the image. Here is an example of how to send an email with an embedded image using VBA: Step-by-Step VBA Code Make sure you have the image you want to embed saved in a folder. Use the following VBA code to send an email with an embedded image: Sub SendEmailWithImage() Dim OutApp As Object Dim OutMail As Object Dim imgPath As String Dim strHTML As String ' Path to the image you want to embed imgPath = "C:\path_to_your_image\image.jpg" ' Create the Outlook application object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) ' Define the HTML body with the embedded image strHTML = "<html><body>" & _ "<p>Hello,</p>" & _ "<p>This is an email with an embedded image.</p>" & _ "<img src='cid:image1'>" & _ "<p>Regards,</p>" & _ "<p>Your Name</p>" & _ "</body></html>" ' Compose the email With OutMail .To = "recipient@example.com" .Subject = "Email with Embedded Image" .HTMLBody = strHTML ' Attach the image and reference it with the Content-ID (cid) .Attachments.Add imgPath, 1, 0, "image1" ' image1 matches the cid in the HTML .Display ' Use .Send to send it directly End With ' Clean up Set OutMail = Nothing Set OutApp = Nothing End Sub Explanation: imgPath: You set the path to the image file that will be embedded in the email. strHTML: This is the HTML body of the email. The image is embedded using <img src='cid:image1'>, where cid:image1 is a reference to the attached image. .Attachments.Add: This attaches the image to the email. The fourth parameter ("image1") links the attachment to the cid:image1 in the HTML body. You can modify the paths, email addresses, and body content as needed.

@georgemathew860 Thank you George :))

@georgemathew860 if u r interested in vba, i have a course that explains arrays and all the concepts needed to code: www.udemy.com/course/vba-course-excel/?referralCode=D136051609B9FE0FD4E5

@georgemathew860 this is an example of a code: Sub FindInArrayAndListObject() Dim ws As Worksheet Dim tbl As ListObject Dim dataArray As Variant Dim i As Long Dim searchValue As String Dim found As Boolean ' Set the worksheet and ListObject Set ws = ThisWorkbook.Sheets("Sheet1") Set tbl = ws.ListObjects("Table1") ' Define the value you are looking for searchValue = "SearchValue" ' Replace this with the value you want to find ' Load the ListObject's data into an array dataArray = tbl.DataBodyRange.Value ' Loop through the array to find the value in the first column found = False For i = LBound(dataArray, 1) To UBound(dataArray, 1) If dataArray(i, 1) = searchValue Then MsgBox "Value found in row " & i found = True Exit For End If Next i If Not found Then MsgBox "Value not found" End If End Sub

I m glad it was useful 😇

@@jasimshaikh8794 hit me up on my whatsapp

My pleasure 😊

@VijayYadav-jm3dc so many hidden things in excel 😅

@bandita445 u need to use custom validation rule like the video. 1 rule is the total num of characters. U can put a min or an exact num of char. Then u have to put a formula for the first 6 char. For example lett(txt, 6)= ...... and u combine the formulas. Have a look at the video and practice. Am sure u ll get the right formula

@@bandita445 ie len(txt)>=6 instead of a specific num of char

@@EXCELWIZARDINMINUTES Thanks! I was able to figure it out, using the same concept as your video with combining them (except I used Or instead of And). My next question, how do I apply that same formula for the whole column? If I select a big range and then set up my Data Validation, they all refer to the same cell (eg cell A2). Instead of having to set up a Data Validation for each cell one by one, is there a way I can do all of them at once, but for it to update the cell?

@bandita445 u must have a prob with the formula u r using. For example a formula like this :=AND(LEN(A1)>=6, LEFT(A1,6)="ABC123") Can be applied on a whole range. Now if the abc123 is in a diff cell for each data validation, i think u can refer to the top cell and it will work for all. Try...

@@EXCELWIZARDINMINUTES I ended up making my report as a Table first, before doing the Data Validation, and that worked. One of the problems I ran into though is that if I copy/paste my formula into the Data Validation, I get an Error saying that there's a problem with my formula, but if I manually type it the exact way, then it works. Any idea why that is?

@hakimfilalibaba4679 i think there might be a workaround to add a line at 20%. (Havent tried it). It s a bit hard to do,i think i have done something similiar in my shorts (quick tips) at the bottom of my playlist where i have added the current date to a chart. Here's how u might try for this chart: Add a new data series to your data representing the 20% line. Add a single constant value of 20% for all categories *Select the new series and change its chart type to Line (in a combination chart) to represent a baseline at 20% %.

@jacqueshollands5630 one idea is to add textboxes: Step 1: Set Up Your Data Input Values: Assume you have the following values: Cell A1: 5 (for the right bar) Cell A2: -5 (for the left bar) Cell A3: Create a formula in this cell to calculate the sum, for example: =A1 - A2 This will yield 10 for the sum of 5 - (-5). Step 2: Create Your Chart Insert a Chart - same as video Step 3: Insert Text Boxes Insert a Text Box: Go to the Insert tab on the Ribbon. Click on Text Box and draw the text box on your worksheet. Link the Text Box to the Sum: Click on the text box to select it. In the formula bar, type = and then click on the cell where you calculated the sum (A3). For example: =A3 Press Enter. The text box will now display the value of 10. Step 4: Position the Text Box Above the Right Bar Copy and Move the Text Box: Click on the text box, then drag it to position it above the right bar in your chart. You may need to resize the text box for better visibility. Format the Text Box (Optional): Right-click on the text box and select Format Shape to change the appearance as desired (e.g., background color, font size). Step 5: Repeat for Additional Bars For Additional Values: If you have more sets of values, repeat the above steps: Create a new cell for each new sum calculation. Insert a new text box for each sum and link it to the corresponding cell. Position each text box above the respective bar in the chart.

@@EXCELWIZARDINMINUTES Perfect solution. Thank you kindly. Don't know why I didn't think of it 😂

@jacqueshollands5630 hahaha. I think this is better than trying to use data labels and changing the values 😅

@jacqueshollands5630 one favour, plz do not hesitate to share the channel with anybody who is struggling with Excel: ruclips.net/user/excelwizardinminutes?submission=1 that will make my day :)

More to come! 😊

@Curic-Ivan thank u Ivan! :)

@@yaserpourgharehkhan welcome Yaser 😊

@alizeeshan9922 i did not get ur question. U meant that ur formula bar is blank? And u dont see anything u type there?

@EXCELWIZARDINMINUTES Yes sir When i type =translate" translate formula doesn't show up

@@alizeeshan9922 u have probably protection on the sheet that doesnt allow to show anything in formula bar. I have a video about this but it s not out. In the meantime: 1. Unprotect the Sheet: Go to the Review tab on the Ribbon. Click on Unprotect Sheet. If a password was used to protect the sheet, you will be prompted to enter it. Enter the password and click OK. Once the sheet is unprotected, you should be able to see the data or formulas in the formula bar when you select any cell. 2. Remove Protection from Specific Cells: If you want to remove protection only from certain cells (but leave the rest of the sheet protected), here’s how to unlock those cells: Select the Cells: Highlight the cells from which you want to remove protection. Open Format Cells: Right-click the selected cells and choose Format Cells. Go to the Protection tab. Uncheck "Locked": Uncheck the "Locked" box. This will allow these cells to remain editable and visible in the formula bar when the sheet is protected, while the rest of the sheet remains protected. Protect the Sheet Again: Go to the Review tab and click Protect Sheet again to reapply protection if necessary (this time the selected cells will not be locked).

@@cyrusezazi 😊😊

The issue is that the api is now terminated. Am trying to make a new video with google maps api. You need to get a api key for the numbers to come correctly and bing has changed their api.

Hello Daniel! Since the API is no longer available, I have made a better version using Google Maps API. You can check it out and get the new workbook: ruclips.net/video/uIRz2k21lEo/видео.html

Hahaha thankssss :)

You r welcome, Alan!

@AshwinChanil excel is a bit boring sometimes hehe. This is why a bit of animation never hurts hehe

To remove a Power Query in Excel, follow these steps: 1. Remove the Query Table from the Worksheet: Right-click on the table or data produced by the Power Query on the worksheet. Select Delete. This will remove the query result from the sheet, but not the query itself. 2. Delete the Query from the Workbook: Go to the Data tab on the ribbon. Click on Queries & Connections (usually on the right side). In the Queries panel that opens, find the query you want to remove. Right-click on the query and select Delete. 3. Optional: Clear Data Connections (if applicable): Go to the Data tab. Click on Connections. In the Workbook Connections window, select the Power Query connection. Click Remove.