11 ай бұрын
Жыл бұрын
Пікірлер
@soloboygamer 2 күн бұрын
there is no pdf option in ms office 2019
@ExcelUpNorth 2 күн бұрын
That’s brutal. The example in this video uses Microsoft Office 365.
@KatotsuSama 4 күн бұрын
I'm trying to use Checkboxes after getting a new computer, and it doesn't create the checkbox. The button seems to do nothing. I opened an old spreadsheet that DID have checkboxes already placed, and they were unformatted as well. Any idea what computer/Windows/Excel setting needs to be enabled?
@gopaldangar1050 5 күн бұрын
This is Awesome, dude
@ExcelUpNorth 5 күн бұрын
@@gopaldangar1050 Thanks, I appreciate the kind words!
@Thunderin11 6 күн бұрын
If I use a built-in table in Excel (ListObject), is there a way to format a table field to have this new type of checkbox in every newly added table row (ListRow)?
@ExcelUpNorth 6 күн бұрын
Hey! Thanks for leaving a comment. You can add checkboxes to your tables and it will automatically add new checkboxes when rows are added.
@Thunderin11 6 күн бұрын
@@ExcelUpNorth Thank you for confirming that, I truly appreciate it. Just to give you an idea for a possible extension of this video, nobody in KZbin has any reference to these checkboxes appearing in built-in tables as far as I searched.
@yeyensuwardi 11 күн бұрын
What to do if we click that insert check box button and no check boxes appear?
@ExcelUpNorth 6 күн бұрын
Maybe there’s data already in the cell you’re trying to insert a checkbox in? It’s hard to tell.
@CekkoLP 12 күн бұрын
Is there a way to insert and remove those new checkboxes with vba code? Was trying all day to find something but no luck so far :(
@ExcelUpNorth 12 күн бұрын
Yep! Try using the following where ‘Selection’ refers to the currently selected cell. ‘Selection.CellControl.SetCheckbox’ to add a checkbox and ‘Selection.ClearContents RemoveControls:=True’ to remove the checkbox.
@jessicammeyer4621 12 күн бұрын
This is a super helpful video and I think it can help me with what I was looking for, but I have 2 worksheets that have similar data and I need the one with more data, but only need all the data from spreadsheet 1 for the subset in spreadsheet 2 if that makes sense. Is there a way to do that with these methods you have listed?
@ExcelUpNorth 12 күн бұрын
Hey, I’m glad you found the video helpful! As for your question, are you looking to combine the 2 worksheets while removing any duplicates between spreadsheet 1 and spreadsheet 2 at the same time?
@NickMuzi-v3x 13 күн бұрын
The GOAT
@ExcelUpNorth 13 күн бұрын
Thank you for your kind comment! 🙏
@guillermosadir6759 13 күн бұрын
What's NCB?
@ExcelUpNorth 13 күн бұрын
Those are the keys on your keyboard needed to insert a checkbox. In this case, you would press the Alt, N, C, B keys in sequence, one after another.
@jand1833 13 күн бұрын
this requires the newest version of excel, what about older versions ?
@ExcelUpNorth 13 күн бұрын
Yes, this requires Microsoft 365. It doesn’t look like older versions of Excel will be supported at the moment unfortunately.
@clarewade3072 14 күн бұрын
hi, i had this show up last week and now it has disappeared. do you know why this would of happened??
@ExcelUpNorth 14 күн бұрын
That’s interesting… I did notice that it moved to a different position in the Insert tab of the ribbon but it shouldn’t have disappeared on you!
@metaflame113 15 күн бұрын
thank you
@ExcelUpNorth 14 күн бұрын
You’re welcome! Thanks for stopping by!
@jeromebereber7854 16 күн бұрын
Nice video. I would suggest add more explanation on why you're doing it :)
@ExcelUpNorth 16 күн бұрын
Thank you! I appreciate your constructive feedback 😄
@j.b.1342 18 күн бұрын
Nice job! Good info!
@ExcelUpNorth 17 күн бұрын
Thank you for the kind words! 😄
@sbskmusicmind 24 күн бұрын
Thank u sir
@ExcelUpNorth 24 күн бұрын
You’re welcome! Thanks for leaving a comment.
@Drew-si5ht 25 күн бұрын
Thank you for your presentation. Clearly detailed
@ExcelUpNorth 25 күн бұрын
@@Drew-si5ht Thank you for leaving a comment! I appreciate the kind words.
@Shmank 29 күн бұрын
Awesome, thanks!
@ExcelUpNorth 29 күн бұрын
You’re welcome! Thank you for leaving a comment! 😁
@ExcelUpNorth 29 күн бұрын
Interesting… Locking cells in an Excel Table works the same way as if it wasn’t. Maybe there’s something else going on?
@Veronica-wu6uo Ай бұрын
Great video. I was hooked from the intro!!
@ExcelUpNorth Ай бұрын
I’m happy that you enjoyed it! 😁
@Shmank 29 күн бұрын
What about locking Table cells? This seems to not work…
@GideonBlustein Ай бұрын
Excellent video! I had no idea it was this easy to convert PDF to excel. Thank you for the great tutorial!
@ExcelUpNorth Ай бұрын
Thank you for the kind words! Cheers!
@dtnt2000 Ай бұрын
This was VERY helpful!!!
@ExcelUpNorth Ай бұрын
Glad it was helpful! Thanks for leaving a comment! 😁
@mehdimirj Ай бұрын
Thanks for the tip, but I have a question: how can I use this formula in combination with INDIRECT due to variable sheet names?
@shadyfahal4759 Ай бұрын
This is awesome, thanks for sharing!
@ExcelUpNorth Ай бұрын
Thank you for the kind words! I’m glad you liked it! 😄
@EvansKabubu_init Ай бұрын
Good explanation. I have a Question, my IFS value is returning the cell information fourmula instead of calculating it e.g Q12*0.145 instead of doing the calculation. What could be the remedy for this?
@EvansKabubu_init Ай бұрын
No worries I've rewatched the video and sorted out my issue
@ExcelUpNorth Ай бұрын
Amazing, I’m glad it got figured out! 😄
@NadezhdaSimeonova-y7j Ай бұрын
Great video! My excel does not recognize VSTACK formula though..
@ExcelUpNorth Ай бұрын
Thank you for stopping by! The VSTACK function is available in Microsoft 365. Is that the version you’re using?
@NadezhdaSimeonova-y7j Ай бұрын
@@ExcelUpNorth Yes, but also I have found some comments in the Internet that somehow working on VPN is restricting this formula, I have no idea why. Even though I managed via Query :)
@ExcelUpNorth Ай бұрын
Woah, that’s unusual for a VPN to affect Excel, but Excel can definitely be a bit temperamental at times.
@NadezhdaSimeonova-y7j Ай бұрын
@@ExcelUpNorth Yeah, May be she was mad or with PMS :D Thanks so much for engaging!
@ExcelUpNorth Ай бұрын
@@NadezhdaSimeonova-y7j haha!
@GavinPatterson-c9n Ай бұрын
Absolutely a lifesaver, thank you. I do have a question about changing the columns from text to numbers. I have a few columns I need to convert into numbers, $ currency & decimal points, but when I try to change them I get an error message in the header box. How do I make the changes? Cheers
@ExcelUpNorth Ай бұрын
Thank you for your comment! Usually changing data types in PowerQuery is pretty solid. It could be a number of things though. The first thing I'd check is to see if there are any leading spaces in the text or letters. If those exist then you'll need to remove those first before converting.
@BarbaraWales 2 ай бұрын
Wondering if you can answer a question for me regarding formatting cells. Is there a way to set a default format for currency? I would like my default to be US$ with ZERO decimal places. Excel typically brings up the formatting box with no currency marker and 2 decimal points. Randomly, the US$ will appear selected in that formatting box, but I have not diagnosed when/how that happens. Many Thanks!
@ExcelUpNorth Ай бұрын
Sorry, I don’t believe there’s a way to set a specific format when creating a new file. It’ll always start with the ‘General’ format. For me, when I need to copy a specific format (i.e. not one of the default formats) from one workbook to another, I’ll copy the Custom format code. Hope this helps! Thanks for stopping by and leaving a comment!
@BarbaraWales Ай бұрын
@@ExcelUpNorth There should be a way to set your preferred Units! Even mar car allows me to designate whether I prefer metric or imperial. I don't have to reset that every time I start my car. I also don't understand why once in a while, the dollar sign will be selected. I download the same data format yet once in a while when I hit Cntl-1 to format the dollar sign appears. Hmmmm Thank you. (And I like your clear concise descriptions!)
@ExcelUpNorth Ай бұрын
Yeah, that’s such a good comparison! And thank you so much for the kind words 😄
@ExcelUpNorth 2 ай бұрын
Want to learn more about converting a PDF to Excel? Check out my Part 2 Q&A video here! kzbin.info/www/bejne/hpKciKSjib-Kr7s
@ExcelUpNorth 2 ай бұрын
Want to learn more about these NEW checkboxes? Check out my follow up video here! kzbin.info/www/bejne/ipbNg5JtrZJ9npI
@DanFuerhoff 2 ай бұрын
I can use the checkbox under the Insert tab but when I save, close the file, and reopen the file the checkboxes are gone replaced with FALSE.
@ExcelUpNorth 2 ай бұрын
Hey! That is a very interesting situation. I’m not sure what’s going on. The only time I’ve come across FALSE values being shown, so far, is when clearing the format of the cells with checkboxes.
@frederickwrighthypnotherap240 2 ай бұрын
Very Helpful thankyou but so so painful trying to listen to what you are saying with that "music" in the backround. I couldn't get to the end.
@ExcelUpNorth 2 ай бұрын
Thank you for the feedback! I totally understand how distracting the background music can be, and I really appreciate you pointing that out. The good news is that I’ve stopped using it in my more recent videos, so hopefully you’ll find those much easier to follow. Thanks for watching!
@MSExcelSolutions- 2 ай бұрын
Your explanation is simple and easily understood. Avoid background music in your future posts
@ExcelUpNorth 2 ай бұрын
Thank you for the kind words and for the feedback! I took out the background music in my recent videos now as it was distracting.
@roitadmor 2 ай бұрын
Great vid. Thanks!
@ExcelUpNorth 2 ай бұрын
I’m happy that you enjoyed it. Thank you for leaving a comment!
@michaelhead3949 2 ай бұрын
Did not work on a scanned PDF.
@ExcelUpNorth 2 ай бұрын
I believe it depends on how the information was scanned. I’ve tried using Optical Character Recognition (OCR) with moderate success but the information can still come through distorted.
@linkProjects-l4n 2 ай бұрын
Thanks from Brazil, it was realy helpful!!
@ExcelUpNorth 2 ай бұрын
Wow! All the way from Brazil? That is amazing. Thanks for leaving a comment and I’m glad that you found it helpful!
@Dennis07-yl3cf 2 ай бұрын
well if your pdf file is that simple you’ll have no problem
@ExcelUpNorth 2 ай бұрын
Very true! I’ve seen some terribly formatted PDFs before because of the way they were saved.
@Dennis07-yl3cf 2 ай бұрын
@@ExcelUpNorth is there any other way for those?
@ExcelUpNorth 2 ай бұрын
I imagine there would be additional transformations to make in PowerQuery depending on how the PDF data is structured.
@MitchMuenster 2 ай бұрын
Looking for something like this. get a manager coming to me in a panic because something was sent over in a PDF for some reason. I never used the feature before but this helped me learn. thanks for doing this.
@ExcelUpNorth 2 ай бұрын
That’s amazing news! Thanks for stopping by to leave a comment and sharing your story.
@noK3NSH1 2 ай бұрын
Why can I not find Sparklines in the Insert tab?
@ExcelUpNorth 2 ай бұрын
What version of Excel are you using? Sparklines were introduced in Excel 2010 and are available in all later versions of Excel 2013, Excel 2016, Excel 2019, and Excel for Office 365.
@Aether550 2 ай бұрын
@@ExcelUpNorth I'm using office 365 on a Mac, I cannot find any sparklines button anywhere. Looked it up in 'help' and everything. Cannot find it anywhere.
@Aether550 2 ай бұрын
I figured it out. It's because I'm using the browser version. I must download the application to get full capabilities.
@noK3NSH1 2 ай бұрын
@@Aether550 I think that was my problem as well.
@shreevisakan688 2 ай бұрын
this option have Office 365 Professional plus or not
@ExcelUpNorth 2 ай бұрын
The example in this video uses Office 365.
@markgipson5969 2 ай бұрын
Even Though I Specified to only Highlight Rows that Column Q has "Not Paid" it highlight on row with PAID Items and not the other Rows that have Not Paid! Any Ideas?
@ExcelUpNorth 2 ай бұрын
With what you provided I’d probably check the cell reference used in the conditional formatting rule. It might have been a typo where it is off by one row.
@markgipson5969 2 ай бұрын
Question on Conditional Formating, I have used it for many years... but I seem to have an Issue maybe you can help with it?
@ginnygabriel260 2 ай бұрын
Super helpful! Thanks a lot! 🤗
@ExcelUpNorth 2 ай бұрын
You’re welcome! I’m glad that you found it helpful! 😁
@parveshbishnoi8377 2 ай бұрын
Hi bro how to contact you..i have a pdf file with a lot of data and i want some value from it....Thanks for your help in advance 😊
@ExcelUpNorth 2 ай бұрын
Hey, thank you for your comment! I actually have a video on how to import a PDF to Excel here: kzbin.info/www/bejne/sF7dZmx5q8d-ebc
@andypettit3776 3 ай бұрын
Interested in learning how to add layers of dependancy. Basically I am interested in making the menu options available in "Job Titles" to be dependent on BOTH the selection in Department AND Roles. Thanks so much, this video was very helpful.
@ExcelUpNorth 2 ай бұрын
Thanks for stopping by and leaving a comment! I’m glad you found it helpful! 😁 That is a very interesting concept. I’d say it would involve modifying the FILTER function in cell E11 to check against the Department and Role columns, rather than the Role column by itself, leaving everything else the same.
@calanahill237 3 ай бұрын
How about more than one check box in a cell? I need two check boxes in one cell and can't figure it out.
@ExcelUpNorth 3 ай бұрын
Unfortunately not as there’s an underlying TRUE or FALSE value behind each checkbox that occupies the entire cell.
@peterfj6218 3 ай бұрын
Excellent - just what i needed.
@ExcelUpNorth 3 ай бұрын
That’s great. Thank you for stopping by!
@saad8111 3 ай бұрын
Thank you for the short and valuable video
@ExcelUpNorth 3 ай бұрын
You’re welcome! I’m glad that you found it helpful! 😁
@soup1207 3 ай бұрын
What about if the table in the new PDF moved to let say another page? How to update those setting please?
@ExcelUpNorth 3 ай бұрын
Interesting question! Assuming that the name of the table remains the same then it can exist on any page and this method will work just fine. If the name ends up changing however, then that’s a different story!
@mariaaguileragarcia9526 Ай бұрын
@@ExcelUpNorth Could you do a video on that please?
@munmundas0506 3 ай бұрын
Thanks this is exactly what I needed 👍
@ExcelUpNorth 3 ай бұрын
You’re welcome! Thank you for your comment!
@Thatvandaguy 3 ай бұрын
Great video, but you can use the Sum function. Use =SUM((B2:M2)*1). Multiplying the range by 1 turns TRUE and FALSE to 1 and 0.
@ExcelUpNorth 3 ай бұрын
That’s a very neat solution! Converting it to 1s and 0s then adding them that way!
@BelindaParker-s1e 4 ай бұрын
Thanks for the video, is there a way to format the check box? I don't want the black infill in the box, I'd rather the old version of a clear box and black tick. Thanks
@ExcelUpNorth 4 ай бұрын
Thanks for stopping by and leaving a comment! Sadly, it doesn’t look like there’s a way to control the fill of the checkbox at the moment. It’s pretty much limited to only changing the color of the checkbox. Maybe they’ll have different types of checkboxes available in the future!