Leila you really do deliver master class-tier content for Excel, and I find myself *uniformly* inspired to do better through watching your videos. You treat the audience with respect, and it is so very much appreciated. Thank you for being an amazing content creator =]
I've been following your videos religiously and even taken several of your Udemy courses (right now in the dashboard course). You're an excellent teacher! This newly minted MOS Excel expert salutes you.
Thanks Leila. All your videos are really useful and informative. I think your skills of explaining things precisely makes all your videos more relevant and valuable.
Explanation of how to use wildcards with ifs function is really amazing. It helped to deal with large data set with multiple criteria. This simple explanatory video really helped me a lot. Thank you for posting this video
I thoroughly enjoy all of your videos. They are very clear and concise and have helped me solve a lot of problems and streamline a lot of processes at work. Thank you very much for the time and effort you put into this. It is very much appreciated.
Hi Leila.. great tip and so logical. Before watching, I first tried something like this: =SUMPRODUCT(ISNUMBER((SEARCH(D1,A1:A3)))*B1:B3) with my criterion range in A1:A3, my sum range in B1:B3 and my criteria in D1. It works, but maybe is cumbersome to understand than SUMIFS() with its structured arguments. I never thought of using the wildcard characters to modify the criteria within SUMIFS(). Of course, that makes sense, now that you provided the example and opens new possibilities, as you demonstrated with LEFT and RIGHT. Excellent! Thanks and Thumbs up!
Thank you! This was very comprehensive and thourough! I was actually looking for the *NOT operator such that sum everything except if a cell has a string in it and it was easy to get there by simply adding the ** in front of your function segment. It may seem simple but without it being said or not being able to search on that it was difficult to find this video which was the EXACT video I needed!! THANK YOU so much!!
Excellent. Every video you are kindling an interest learn more & more tricks. Thanks a lot to my beloved/beautiful/brainy/awesome/witty Excel Teacher. You are making us MAD OF EXCEL. Really I love/like your videos very much.
Having an Excel exam tomorrow for new position at work. Looked up most of your videos, excellent job. Much appreciate it. Great refresher and few things i did not know about. Looking forward to more videos of yours. Thanks a mill. It's a sub !
@@LeilaGharani Easier then expected. Few nested IFs with ANDs and ORs, vlookup, basic math, just long formula, pivot chart with slicers and forecast model. Nailed it :) Waiting for official feedback, but pretty sure will be offered the possition. Thank You very much for all the videos. Helped me a lot.
Guess you helped in building Excel. You are just too much! I wouldn't be surprised you would be introducing some new functions to to the Excel developers soon. You are awesome!
Thanks to you, I could get the same results using SUMPRODUCT function. For example: we can get the sum quantity which contains AT, E6, 10, or 30_ by using this formula: =SUMPRODUCT(--ISNUMBER(SEARCH(F6,$A$4:$A$15)),$C$4:$C$15) and almost the same with next other conditions using SUMPRODUCT with LEFT and RIGHT functions. . Keep uploading the challenging excel videos :)
You are so so kicking ass with your tutorials. Never a dull moment when watching your skills, tips and tricks to improve. My hat´s off with a big thank you. Keep it up. :)
i guess im randomly asking but does any of you know a trick to log back into an instagram account..? I stupidly lost my account password. I would love any tips you can give me
@Adrien Sonny I really appreciate your reply. I got to the site through google and I'm in the hacking process atm. Takes quite some time so I will reply here later with my results.
Great stuff..especially the combination of left and right function added with customer combination.it took a bit of time but finally understood.thanks!
Grüß Gott Leila, I know this is an old video but this is such a good tip rather than adding a helper column with a left formula. In the end, all roads lead to Rome but you definitively got the smartest shortcuts!!
You are good at explaining the ins and outs of Excel. I'm curious about your first language; is it Hindi? Your English is very good. Keep up the great videos.
Brief, analytic and right on the spot as always Leila. Thank you for your videos. I have a question, and though it is not very related to this video, I thought of placing it here due to the use of wildcards. It is about the CTRL + F command. So here goes; Let's say that I need to exclude cells that have particular added values, while I need to find all the others that don't have them. Example; I have 5 cells that contain the word "Bread" and 5 more that contain the words "White Bread". Let's say that I need the "Find" command to show me only the cells with the "Bread" value. If I hit CTRL + F and type "Bread" it will return all 10 cells. Is there a wildcard which will do the opposite of "*"? So that if I place it in front and at the end of the letter/letters/word that I need excel to exclude from the search, it will comply? For example, let's say that this wildcard exists and it is the "#" symbol. If I hit CTRL + F and type "#Wh#Bread" it will give me only the 5 cells with just the "Bread" value? Also if you select multiple cells by holding down the CTRL key, is there a way to deselect a mistakenly selected cell, without having to repeat the whole process again from the beginning? Thanks in advance. Stay Safe.
Hi Leila, Great lecture Is there a way to use wildcards and sumifs when your criteria range are numbers? lets say to add amounts for all the 4000s account numbers? (I tried 4&"*" as my criteria but didn't work)
Absolutely Outstanding! This is one of those prime issues in Excel - You have a glob of text and numbers in a many-rowed column spreadsheet, yet you need to sum up those costs are of a particular word(s) or number(s) are inside the chosen column. For instance: ashfkdhakljahdkjToolingjkjdd $3,000 janskjfnkajsdToolingddasdfc $20,000 adfodiajfoiadjfoidajfifjdoafo $15,000 fkdkfjkjToolingkmnjnjnjknkj $100,000 What are all the tooling costs for the Purhase Orders we have done?
Can you do this with multiple parameters that would output different words if TRUE? I have 5 different codes that need to have a proper name in another column. Each code has the same 3 letters that is equal to a proper name, but the three letters vary in what position they hold.