- 3
- 245 194
SKYXCEL
United States
Приєднався 24 вер 2019
Welcome to SKYXCEL's UA-cam channel!
SKYXCEL is a company that specializes in creating custom Microsoft Excel solutions to allow end users to experience more beneficial capabilities Excel has to offer. Our mission is to increase your efficiency by transforming Excel into a user friendly environment that eliminates any time consuming hassles. Imagine having a fully automated, custom Excel template that is designed specifically for you needs. Just plug in the numbers and we will make Excel do the rest.
While our services include designing custom Excel templates, Excel consulting and Excel training, we are excited to introduce tutorial videos on various tip & tricks to utilize Excel more efficiently. These videos are part of SKYXCEL's blog, but we want to be able to reach out to people across multiple platforms that are seeking help with any Excel questions.
SKYXCEL is a company that specializes in creating custom Microsoft Excel solutions to allow end users to experience more beneficial capabilities Excel has to offer. Our mission is to increase your efficiency by transforming Excel into a user friendly environment that eliminates any time consuming hassles. Imagine having a fully automated, custom Excel template that is designed specifically for you needs. Just plug in the numbers and we will make Excel do the rest.
While our services include designing custom Excel templates, Excel consulting and Excel training, we are excited to introduce tutorial videos on various tip & tricks to utilize Excel more efficiently. These videos are part of SKYXCEL's blog, but we want to be able to reach out to people across multiple platforms that are seeking help with any Excel questions.
How to Sum Values If a Cell Contains a Specific Text | SKYXCEL
Welcome to SKYXCEL Tips & Tricks! Today we will be showing you how to sum values if a cell contains a specific text. Additionally, we will reveal how to enhance the SUMIF function to create criteria that matches values beginning or ending with specific text.
Please give this video a like if you found this tutorial helpful and subscribe to receive updates for future tutorial videos that will save you time and increase your efficiency.
We invite you to leave any questions or request in the comments below!
In need of more Excel assistance specifically for you? Visit
www.skyxcel.com/ where we can design fully customizable, automated spreadsheets that are tailored specifically for your needs.
You can also visit our blog at www.skyxcel.com/blog for more Excel tips & tricks.
Please give this video a like if you found this tutorial helpful and subscribe to receive updates for future tutorial videos that will save you time and increase your efficiency.
We invite you to leave any questions or request in the comments below!
In need of more Excel assistance specifically for you? Visit
www.skyxcel.com/ where we can design fully customizable, automated spreadsheets that are tailored specifically for your needs.
You can also visit our blog at www.skyxcel.com/blog for more Excel tips & tricks.
Переглядів: 129 555
Відео
How to Highlight a Cell or Row with a Checkbox in Excel | SKYXCEL
Переглядів 114 тис.4 роки тому
Welcome to SKYXCEL Tips & Tricks! Today we will be showing you how to highlight a cell or row based on if a checkbox is clicked or not. Combing user form controls and conditional formatting is a great start for creating more interactive and dynamic Excel spreadsheets. Please give this video a like if you found this tutorial helpful and subscribe to receive updates for future tutorial videos tha...
How to Create a Dynamic Drop Down List in Excel | SKYXCEL
Переглядів 2,2 тис.4 роки тому
Welcome to SKYXCEL Tips & Tricks! Today we will be showing you how to create a dynamic drop down list in Excel by utilizing tables and data validation. This method allows you to add new items to a table and Excel will automatically update and include those new items in the drop down list. Please give this video a like if you found this tutorial helpful and subscribe to receive updates for futur...
You are Genius man God bless you
Thank you so much!
How to change the TRUE to Complete and FALSE to In Progress?
how can i sum text?
How do you move the box to the exact centre of the cell?
How can you resize the checkbox like this, i tried everything but it wont work
Thanks.... Professor!....
THANKS! MAY YOU HAVE A BLESSED LIFE!
what if I want to give a (no fill), when the checkbox is unchecked
Thank you very much for the explanation. It was very clear, calmly spoken and excellent explanation.
Thank you. Can I use orange as an option in addition to green and red?
I fucking hate excel lottery followed every single second of your wonderful video and nope won’t work
Awesome tutorial. ty!
wow. I would never have gotten that on my own...
What if I want when click to select specific text, I want this text displays on the top of the form. Example: If select the Category Fax. I want the Fax word displays on the top on the cell C3, if selects Category Letter, shows the word Letter on the Category Field: Letter on C3. Only one category can be selected.. The reason I want this is people selects from big category list in the middle of the form up to the bottom with 2 columns of categories on the form, and the users have to keep scrowling down up and down to see the selected category. So placing the category name on the top is going to save a lot clicks up and down. We receive 100 forms per day with category selected. So if automated, we would receive the forms displaying the category displayed on the top, without deleting the categories list in the form.
hi, i need to link to 1000 entries. As per your comments, you mentioned it can be done via VBA. could you please create a new video on it showing how it can be done in VBA? thanks a lot for the video.
If have 250 checkboxes, is there a quick way to format the control or do I have to each one manually?
Any answer to this?
i hope someone could help.. same question
No
Have you figured it out? Im in the same situation
Same issue here.
THANK YOU! I could not find anyone else with a tutorial to this.
Awesome! Precisely what I wanted to know. This was explained in a way that is very easy to understand. Thx a mil!
I have a worksheet with the following data,,, vendors name in Column A2 , Paymnt Amount in Column B2. Check-boxes in Column C2, Paid/Unpaid text in Column D2. I would like to establish a link between check-boxes and the 'amount' column. Specifically, I want the checkbox in column C2 to be automatically checked when I enter an amount in cell B2. Additionally, when the checkbox is automatically marked as checked, I would like the text 'Paid' to appear in column D2. Is it possible to achieve this using a formula or VBA/Macro?
This is exactly what I needed! Thank you!!!
Thank you...this tutorials such a big help for starters
is it possible to do exactly this when some of the cells are locked. This solution works, nearly, perfect, but won't work at all when the sheet is protected because some of the cells are locked.. I need to keep said cells locked because of the formulas they contain.
Hello, Great question! Give this a try and let me know if it works for you. 1. Right click the checkbox 2. Click Format Control... 3. Click the Protection tab 4. Unselect the box labeled "Locked" 5. Click Ok 6. Select the linked cells that your checkboxes use that input TRUE or FALSE. In the video this range would be B4:B6. 7. Right click the selected range and click Format Cells... 8. Click the Protection tab 9. Uncheck the box labeled "Locked" 10. Click OK 11. Protect the sheet and test it out!
Thank you!!!!This was so helpful!!!
Thanks 🙏
Comprehensive tutorial!
Super useful!!
What if I'd like to do the sum of two specific words?
Thank you
If we have morethan one colum then how it will work ? because with me just working one colum as you mentioned in the video .
Hello, are you referring to having multiple columns for the criteria or multiple columns to sum?
awesome
Not working in windows 10 i add tick box from developer option and i tick it countif formula not working
Thank you soooo much!!
Great video! my check boxes are so small (Mac excel) can't hey be made bigger? thanks!
My Default check box is way to small for what I want. How can I resize the Check Box itself? I'm not talking about the selection bounding box around it. Can I change the default size or resize after I have put it in the form? Nothing I try seems to work to resize the check box. Definitely not very intuitive.
what if i want to match the value of 2 cells and not just 1 cell?
Thank you
WEEEEEEEEEEEEEEEEEEEEEELLLLLLLLLLLLLLLLLLL Doneeeeeeeeeeeeeeeeeeee
Can you help me? HSPW-0000 this is employee number P= Philippines & W= worker. Please tell me formula that I write employee ID and get its Nationality
Hello, if "HSPW-0000" is in cell A1 then a basic formula would be: =IF(FIND("P",A1),"Philippines"). This formula states that if the letter "P" is found within the text in cell A1 then output "Philippines". However, this formula may only work for certain situations, if there is another employee number that contains the letter "P", but has a different meaning then this formula will not work. Depending on how many different forms the employee numbers can be in the formula may need to be tweaked to account for different scenarios. If the nationality is always defined by the 3rd character in the string I would suggest setting up a nationality key in a table form with letters in one column and the associated nationality to that letter in another column like so: (Column D, Column F) E, English F, French G, German Then use the MID function to extract/look at the 3rd character of the string and combine the VLOOKUP function to output the nationality associated to that letter using the table: Employee Number (cell A1) = HSFW-0000 Formula: =VLOOKUP(MID(A1,3,1),$D$1:$E$3,2,0) = French I hope this helps or gives a sense of guidance to an appropriate solution. Feel free to reach out for any more questions!
Interesting. Thanks 😊
this video was great thank you. I finish my project.
thanks, i learned
❤
Hi Is possible to sum all WA11? (A1) WA11 4 (A2) AdBlue 1, WA11 223 (A3) AdBlue 3, WA11 32, shift 4 ... and everything is in one column.
=SUMPRODUCT((--(ISNUMBER(FIND("WA11",A1:A3)))))
So, if i want to "Format Control", I have to do it to each cell individually in a list of 500+ entries?
Hello, great question. Yes, you would have to do it manually which would not be ideal. Maybe using special characters to activate the conditional formatting rules rather than checkboxes would be a better solution. However, if you wish to have a ton of checkboxes then you can automatically link the checkbox to its adjacent cell by applying VBA code.
Can you show me how to do this please ?
Thank you very Useful
I love your voice hahaha <3
Thankkk youu
I am looking for a way to format some dependent tasks if the trigger is checked done. Is there a way to do that in excel?
More than likely, but it might depend on how your spreadsheet is setup and how you are adding depending task. Some VBA may be required. I would have to see an example to come up with a more direct answer. If you would like to share I would be more than happy to see if I can come up with a solution for you!
@@skyxcel6080 Where would I need to send the information to?
what if it contains time and cost in same cell but i only want to sum the currency in each cell on the column,,, example (A1) "bob 3:00 oclock $450" (A2) "julie 5 o clock $20" how do i sum only the cost? when the description and time and cost is all in one cell? any assistance would be greatly appreciated
Great question! What I would do in that particular situation is create a helper column to extract the dollar amounts into a separate column then sum up the helper column. Going along with your example, in cell B1 insert this formula: =NUMBERVALUE(RIGHT(A1,LEN(A1)-FIND("$",A1))) This formula extracts all the characters to the right of the "$" sign and converts it into a number. Copy this formula down to cell B2 and then add a simple SUM formula to total up the column: =SUM(B1:B2) I hope this helps and please let me know if you have any further questions!