Secret #5 seems to be the most popular. Question for you... Are there any time consuming Excel tasks that you'd like to automate with a macro? Leave a comment and let us know. 👇🏼 I'm working on another video on the macro recorder and want to include examples that would be helpful for you. So, your idea or question could be featured in the video.
Make a macro about how to keep the header row fixed on a sheet even if we are scrolling down so that we don't have to go all the way up to check the headers again and again while entering data. Because if we do so there surely is a chance of making mistakes. (I'm a beginner and came across this problem while doing a simple task)
@@florenciaray5954 Hi Florence, you really don't need a macro for that. Put your data into a table (an actual Excel one) and when you scroll down the column letters will be replaced by your table headers! Magic 😁 (and you can see that at minute 9:20 of the video checking day 5 is present in the table created with Power Query)
How about a merge cell macro that mimics Word's merge cell capability, which does not discard data that is not in the upper left cell? And a counterpart macro that splits data across cells?
@@florenciaray5954 Welcome to the Excel world. The program has the built-in Freeze Panes capability that creates header rows and columns. Access Freeze Panes on the View tab.
@@florenciaray5954 Probably easier than a macro for that is to use one of Excel's "Freeze Panes" options (i.e. freeze top row OR freeze 1st column OR freeze whatever's directly above & to the left of the currently selected cell. From the ribbon, go to View tab and right click on the "Freeze Panes" option, then select the "Add to Quick Access Toolbar" option. FWIW, I like to show my Quick Access options BELOW the ribbon, that way more icons can appear without running into the file name AND they're available regardless of what ribbon tab is selected.
2:30 "If you feel that you already know all these techniques, this will be a good reminder to teach them to your co-workers." This is the most important message ever. Too many IT workers like to keep techniques to themselves. It makes them feel better than others. Excel will just laugh at people with that attitude. There is always something new to find in Excel so share what you know.
You've done a phenomenal job of explaining every component of the formulas and explaining exactly what you're doing. This was super helpful! I think a LOT of Excel teachers have their own information bias and forget to explain some things.
The power query to combine files contained in a folder ...... I found this feature on the web a couple days ago, so still new to me, your video just cleared up a sticking point and added more detail. SO simple and will save me so much time and frustration! I will be watching more of your tutorials! Thank you.
As always Jon........AWESOME! You always speak and describe things so well and at just the right pace for me. There's never any time wasting or 'padding' with you, that's why you're always my go to for excel. Thank you so much for sharing. Regards John (Inverurie, Scotland)
Great excel tutorials. I have learnt a lot. The most important was the macro. This will save me a lot of time and make my work super easy. Thank you so much Jon.
Thank you for this one. Although I know a lot of shortcuts, I always find it interesting to watch these kind of videos. For just 17 minutes, I learned one new shortcut/trick - Ctrl Shift End - in case of blanks. An amzing one. Thank you. It will save me more than 17 minutes in the future :)
Thanks so much, Jan! It will take about 40 uses of the shortcut for you to recoup your time. That's assuming you use it on an average of 10,000 rows that take 26 seconds to select. 17 / (26/60) = 39.23 Lot's of assumptions in that equation, but I love to geek out on this stuff. I'd love to know how many thousands of times I've used that shortcut alone. And I think it's awesome that you thought about the time you will save in the future. So good! 🙂
When I have a select enough rows that I can no longer see my formula, then my favorite way to keep that range selected and "scroll" back up to the formula is while that to just hit Ctrl + Backspace. It's fabulous!
if you go to File, Options, Advanced, and Untick Allow editing in Cells, then you will always edit your formulas in the formula bar at the top of the sheet.
Great work as always Jon. At my company, personal macro workbooks have been banned/locked out by IT Security. So far, a workaround is to convert that same workbook to an Excel Add-in and then set it to load on start up. I've got my own personal ribbon with icons linked to the functions in that Add-In and also custom icons on the Excel shortcut dropdown list so i can get to them either way. If you put together a video on the Add-In approach for personal macros, I'm sure it would be popular.
I use a very similar header row macro for my work that includes the filename (=CELL("filename",A2) when it is printed out so that I can find the file using the printed output. It is useful to have a blank row below the header if you use arrays with CurrentRegion.
Great question, Franco! I tend to put several macros in the same module. In my personal macro workbook, I group the macros based on their functionality (or what they do). For example, I have a module named mUnhideSheets that contains several macros for hiding and unhiding sheets. You can see an example in this video. th-cam.com/video/cckNqUEALbQ/w-d-xo.html This organization allows me to find them a bit easier than putting all macros in one module. It also allows me to move a module to a different workbook if I want to use those macros in a specific project. I think there are pros and cons no matter which way you choose to organize your macros. And it's important to find a method that works best for you. One thing to note is that you can use Ctrl+F to find macros in the current procedure, module, or project. So if you don't want to organize them, search is another way to quickly find them. I hope that helps. Thanks again and have a nice weekend! 🙂
@@ExcelCampus Thank you! I will follow your advice to better organize my macros! I didn't know about Ctrl+F. I will definitively use it in the future. Have a nice weekend too!
Thanks for the shortcuts, Jon! They’ll be really helpful at work. I’m having trouble with Excel though-it’s asking for a product key. Does anyone have any idea where I can get one?
Thanks Jon for the informative video. This is excellent. My favourites are Power query and pivot tables that are time savers. Will learn power query in depth to make my life easier. Thanks again.
I appreciate you sharing your knowledge and skills. The videos were informative and simple to understand. I will use all 5 "secrets" to improve productivity. I like that you demonstrate the shortcut keys as you teach. Also, Xlookup was new to me.
As always Jon appreciate your sharing your knowledge of excel your videos are always clear and easy to understand the sheet title layout was extremely helpful, I added an input box to mine so I could fill the title in as I created the sheets works perfectly thank you.
I love that idea, Tom!! 🙌 Save a step in the process. The section on macros seems to be the most popular and I'll do some follow up videos on additional ways to use the macro recorder and modify the macros, including your tip on the input box. It' the InputBox function for anyone reading that wants to learn more.
Ty Jon! Can you run a second macro after the first? Have a situation at work, where I run a macro that creates 4 sheets, and then I create six other sheets in same workbook. Can I create/run a second macro on whole to give same formatting?
Awesome tips. Thanks heaps Jon. I’m so glad I found your channel, it was actually through Primal Video that I discovered your amazing channel and tutorials.
I really enjoyed the Macros but your explanation was great for all of your tips. I am a huge fan of keyboard shortcuts. Do you have a shortcut to automatically increase the column width to fit the data? I am currently using crtl+a and then alt+h+o+i, but I have to do this every time I need to review the data provided and updated from an outside source. I am currently unable to ask them to change their default column width so I am looking to possibly use VBA/macros to automate this step. I am interested to see if you've come across this challenge or if the aforementioned shortcuts are the fastest way to complete the action. Thank you again for teaching and sharing your knowledge, I really appreciate it.
Jon, a fabulously informative video with clear explanations. Many thanks. Sadly I think that I shall have to get a more up to date Office suite in order to be able to use the new functionality!
Thanks for the clear explanation of these often used functions! I knew them, but i think it is always good to keep reading it if you do not use Excel that much. I do have a question about PowerQuery. What if there already is file and you have to add the data of other files to it without creating a new sheet?
Awesome video, thanks for sharing! Do you have any that shows how to use a vlookup formula to compare 2 different dates in 2 separate spreadsheets and then to present the difference in days between one and the other? Thank you! 👍👍
Great video… thanks for sharing! I was already onto most of the tips but the macro bar at the end looks helpful and I’ll check out your video on that! Cheers 🍺🍺
I created buttons on my Quick Access Toolbar and assigned them to the most common macros I use. I didn't know we could make our own ribbon item though!
I'm not sure how to follow along. Are there supposed to be some folders in addition to the file that has a tab called Leads? Do the folders contain CSV files? Where are they? thank you so much! And thank you, also for the wonderful vids!
Hi Jon. Just found your channel today and subscribed. Great tips. May I ask - what screen recorder do you use? You appear to fly through the steps and are able to annotate very fast. I'd love to learn VBA, is there a course you would recommend? Thanks!
Am new subscriber this one really awesome i learned new things especially ctrl+shift+end without knowing that i waste time now u saved everything :) do more video we support u kudos!!🥳
Hi Jon, Thank you for the keyboard shortcut tips. Just a doubt to clarify. When I enter CTRL+SHIFT+End instead of going to end of the Column, the Print Preview Page Pops out. Please could you help me how to resolve this.
Thanks for being a subscriber! We appreciate your support. 🙏 For anyone else reading this, there is a link in the description to join our free weekly Excel Pro Tips Newsletter.
Creating a macro to insert and identically format a top row on multiple sheets is probably not necessary for most spreadsheet users. A different approach is to group a contiguous set of sheets by holding the Shift key, selecting the first sheet's tab and the last sheet's tab. All grouped sheet tabs will indicate that they are in active use. On an active sheet, insert the new first row and apply the desired formatting to the row. Entered text, etc. will be repeated on all grouped sheets. Note that an operation on a grouped sheet might be repeated on all sheets of the group if the operation is valid for all grouped sheets.
Oh my goodness. Power query was the best for me. Thank you so much. On another note, every August we have a huge business meeting (approximately 800 in attendance) that I have to download all the data from the online registration and create name tags (among other things). I usually download all the info into a csv, then create a 'label' in Word, add the fields, .. you get where I'm going. Is there a quicker easier way? Any help would be appreciated. Thank you.
I have never created a macro in Excel, Access yes, but not Excel. Very interesting. You have expanded my knowledge on every point of your tutorial. I will use the quick keys for selecting ranges a lot. For the XLOOKUP function, is there value for naming headers and data in the formula? I know you most did absolute references. I really enjoyed this video. VERY HELPFUL!
The macro - how to use the macro to run an automatic pick for a list of purchase orders every day, based on min and maximum inventory levels, without an inventory management ERP system?
In my very first proper spreadsheet (using Lotus 1-2-3 on MS-DOS), not just trying to learn how to use them, I used lookups. It was only a modest size - but took over twenty minutes to recalculate. Needless to say, auto-recalc was impossible. Things have changed.
Is there a way to select a group of cells in a column, then tab to the next column and have the same amount of grouped cells selected? For example selecting cells A1 thru A12 and tab over to have just B1 thru B12 selected?
Love the cntrl + shift + end reminder, but now that I'm on a Mac we don't have an end button. figured out that shift + command + down arrow works if fields are filled in, but it didn't work when there are empty cells. Would love to know if anyone found the alternative when blanks. 🦋
Secret #5 seems to be the most popular. Question for you... Are there any time consuming Excel tasks that you'd like to automate with a macro?
Leave a comment and let us know. 👇🏼
I'm working on another video on the macro recorder and want to include examples that would be helpful for you. So, your idea or question could be featured in the video.
Make a macro about how to keep the header row fixed on a sheet even if we are scrolling down so that we don't have to go all the way up to check the headers again and again while entering data. Because if we do so there surely is a chance of making mistakes. (I'm a beginner and came across this problem while doing a simple task)
@@florenciaray5954 Hi Florence,
you really don't need a macro for that.
Put your data into a table (an actual Excel one) and when you scroll down the column letters will be replaced by your table headers!
Magic 😁
(and you can see that at minute 9:20 of the video checking day 5 is present in the table created with Power Query)
How about a merge cell macro that mimics Word's merge cell capability, which does not discard data that is not in the upper left cell? And a counterpart macro that splits data across cells?
@@florenciaray5954 Welcome to the Excel world. The program has the built-in Freeze Panes capability that creates header rows and columns. Access Freeze Panes on the View tab.
@@florenciaray5954 Probably easier than a macro for that is to use one of Excel's "Freeze Panes" options (i.e. freeze top row OR freeze 1st column OR freeze whatever's directly above & to the left of the currently selected cell.
From the ribbon, go to View tab and right click on the "Freeze Panes" option, then select the "Add to Quick Access Toolbar" option.
FWIW, I like to show my Quick Access options BELOW the ribbon, that way more icons can appear without running into the file name AND they're available regardless of what ribbon tab is selected.
Crtl Shift End instead of down arrow was new for me. Thanks Jon!
You're welcome. 😀
Same here. But meanwhile I like the table approach more: Ctrl+A, Ctrl+T, then shift+space for rows and Ctrl+space for table column
Same
Really, then you have learnt a new trick
Same here
2:30 "If you feel that you already know all these techniques, this will be a good reminder to teach them to your co-workers."
This is the most important message ever. Too many IT workers like to keep techniques to themselves. It makes them feel better than others. Excel will just laugh at people with that attitude. There is always something new to find in Excel so share what you know.
You've done a phenomenal job of explaining every component of the formulas and explaining exactly what you're doing. This was super helpful! I think a LOT of Excel teachers have their own information bias and forget to explain some things.
The power query to combine files contained in a folder ...... I found this feature on the web a couple days ago, so still new to me, your video just cleared up a sticking point and added more detail. SO simple and will save me so much time and frustration! I will be watching more of your tutorials! Thank you.
Glad to hear that, Diane! 😀
As always Jon........AWESOME!
You always speak and describe things so well and at just the right pace for me.
There's never any time wasting or 'padding' with you, that's why you're always my go to for excel.
Thank you so much for sharing.
Regards
John
(Inverurie, Scotland)
Wow, thank you for your feedback! 😀
Awesome! Double clicking on the fill handle was something I learned from your video. Super useful.
Great excel tutorials. I have learnt a lot. The most important was the macro. This will save me a lot of time and make my work super easy. Thank you so much Jon.
Glad it was helpful! 😀
Thank you for this one. Although I know a lot of shortcuts, I always find it interesting to watch these kind of videos. For just 17 minutes, I learned one new shortcut/trick - Ctrl Shift End - in case of blanks. An amzing one. Thank you. It will save me more than 17 minutes in the future :)
Thanks so much, Jan! It will take about 40 uses of the shortcut for you to recoup your time. That's assuming you use it on an average of 10,000 rows that take 26 seconds to select. 17 / (26/60) = 39.23
Lot's of assumptions in that equation, but I love to geek out on this stuff. I'd love to know how many thousands of times I've used that shortcut alone.
And I think it's awesome that you thought about the time you will save in the future. So good! 🙂
Ctrl+Shift+End is a new thing for me. Thanks
Really nice demonstrations and descriptions here. MS Excel is so powerful now.
Thanks! And yes! 💪
Shift control end is new for me when there are multiple blanks in column and used to do manually. Now i am pro after watching
I've just learnt all of this now! wow! thanks for this!
When I have a select enough rows that I can no longer see my formula, then my favorite way to keep that range selected and "scroll" back up to the formula is while that to just hit Ctrl + Backspace. It's fabulous!
if you go to File, Options, Advanced, and Untick Allow editing in Cells, then you will always edit your formulas in the formula bar at the top of the sheet.
I have asked this very question in comments on other videos and at Microsoft's own help forum and nobody could answer... until now!! Bless you.
@@cindyfillion9192 I learned it from Leila Gharani. 😇
Learning Analytics and these videos you post have been instrumental.
Thanks!
Thanks Jon! I've been scared of PowerQuery - but you made it sound super easy! I'll definitely be looking into it more.
I am so glad I found your channel Jon. This is great and useful information!
I'm glad that you find it helpful. 😀
Great work as always Jon. At my company, personal macro workbooks have been banned/locked out by IT Security. So far, a workaround is to convert that same workbook to an Excel Add-in and then set it to load on start up. I've got my own personal ribbon with icons linked to the functions in that Add-In and also custom icons on the Excel shortcut dropdown list so i can get to them either way. If you put together a video on the Add-In approach for personal macros, I'm sure it would be popular.
I use a very similar header row macro for my work that includes the filename (=CELL("filename",A2) when it is printed out so that I can find the file using the printed output. It is useful to have a blank row below the header if you use arrays with CurrentRegion.
This is the first video I’ve seen of yours. OUTSTANDING!
Very helpful! Compliments on how you present. So easy to follow. Appreciate the effort you put in
Thanks Lindie! I’m happy to hear it helped and appreciate the nice feedback. 🙂
Thank you for the great video and hints. Do you save several macros in the same Module or each macro in a separate Module?
Great question, Franco! I tend to put several macros in the same module. In my personal macro workbook, I group the macros based on their functionality (or what they do). For example, I have a module named mUnhideSheets that contains several macros for hiding and unhiding sheets. You can see an example in this video. th-cam.com/video/cckNqUEALbQ/w-d-xo.html
This organization allows me to find them a bit easier than putting all macros in one module. It also allows me to move a module to a different workbook if I want to use those macros in a specific project.
I think there are pros and cons no matter which way you choose to organize your macros. And it's important to find a method that works best for you.
One thing to note is that you can use Ctrl+F to find macros in the current procedure, module, or project. So if you don't want to organize them, search is another way to quickly find them.
I hope that helps. Thanks again and have a nice weekend! 🙂
@@ExcelCampus Thank you! I will follow your advice to better organize my macros! I didn't know about Ctrl+F. I will definitively use it in the future. Have a nice weekend too!
Thanks for the shortcuts, Jon! They’ll be really helpful at work. I’m having trouble with Excel though-it’s asking for a product key. Does anyone have any idea where I can get one?
Hey Keith! I got my Excel product key from BNH Software and was able to use it without any problems!
@@Ann_779 Hey Ann, I have a question. Does this key work for all the Office programs, or just for Excel?
@@MarkUSAfreedom Hello Mark! It's only for Excel. You can find the product keys for the other programs on the same website. Hope it helps!
Thank you, Ann!! It worked perfectly, and now I can use Excel without any problem!
@@keithM7 You're welcome! I'm happy to help
I sure wish I had found you much earlier, but I'm glad to have found you now. Thanks!!😀
Thanks Jon for the informative video. This is excellent. My favourites are Power query and pivot tables that are time savers. Will learn power query in depth to make my life easier. Thanks again.
Awesome! I'm happy to hear you're interested in learning Power Query. It's an amazing tool for data cleanup tasks.
All of these videos were extremely helpful - Thank you
Mr.Jon continue your great work to the community.Nice video to save the time.
Thank you, will do! 😀
I appreciate you sharing your knowledge and skills. The videos were informative and simple to understand. I will use all 5 "secrets" to improve productivity. I like that you demonstrate the shortcut keys as you teach. Also, Xlookup was new to me.
for my current job, i am most interested in Combing Files. I need to watch it again. thank U
You are welcome! 😀
Great stuff! A guy on Reddit was asking about combining files today, and I was able to link this video! Thanks again!
Glad it was helpful! 😀
Ive watched a few of these videos and they are really helpful. I really appreciate the info you present!
Thanks for your support. We really appreciate it. 🙏
Great video, will be sharing this at work! Someone will make use of it 😊
I'm so happy to hear that and thanks so much for sharing! 🙏
Thank you for the video. Always enjoy your videos, you have a great teaching manner.
I appreciate your feedback. 😀
As usual a very well structured video. I learnt a few new ways to do thing faster, especially the Macro.
🙌 I'm happy to hear you learned some new things. Thanks for letting us know.
As always Jon appreciate your sharing your knowledge of excel your videos are always clear and easy to understand the sheet title layout was extremely helpful, I added an input box to mine so I could fill the title in as I created the sheets works perfectly thank you.
I love that idea, Tom!! 🙌 Save a step in the process. The section on macros seems to be the most popular and I'll do some follow up videos on additional ways to use the macro recorder and modify the macros, including your tip on the input box. It' the InputBox function for anyone reading that wants to learn more.
I have joined your channel today and this was the first video I watch it's amazing. If I go through all the videos I might become a pro
Awesome! Thank you for your feedback. 😀
Ty Jon! Can you run a second macro after the first? Have a situation at work, where I run a macro that creates 4 sheets, and then I create six other sheets in same workbook. Can I create/run a second macro on whole to give same formatting?
Thank you.... These shortcuts are going to be really helpful in future
Glad to hear that! 😀
excellent video, very useful tips ( esp power query and macros) and very well explained.
Many thanks for your feedback! 😀
Thank you for your efforts, explained in great detail yet easy enough for a novice excel user. Great Job.
Thank you for your feedback! 😀
Awesome tips. Thanks heaps Jon. I’m so glad I found your channel, it was actually through Primal Video that I discovered your amazing channel and tutorials.
Awesome! Thank you for your feedback! 😀
I love your efficient videos! Helpful
I really enjoyed the Macros but your explanation was great for all of your tips. I am a huge fan of keyboard shortcuts. Do you have a shortcut to automatically increase the column width to fit the data? I am currently using crtl+a and then alt+h+o+i, but I have to do this every time I need to review the data provided and updated from an outside source. I am currently unable to ask them to change their default column width so I am looking to possibly use VBA/macros to automate this step. I am interested to see if you've come across this challenge or if the aforementioned shortcuts are the fastest way to complete the action. Thank you again for teaching and sharing your knowledge, I really appreciate it.
Jon, a fabulously informative video with clear explanations. Many thanks. Sadly I think that I shall have to get a more up to date Office suite in order to be able to use the new functionality!
Thanks for the clear explanation of these often used functions! I knew them, but i think it is always good to keep reading it if you do not use Excel that much. I do have a question about PowerQuery. What if there already is file and you have to add the data of other files to it without creating a new sheet?
Thank you. Which video that shows how to add my micro tab?
5 for the price of one - one day only! Thanks Jon!
LOL! Tell your friends! 🏃
Yeah, excellent tips to increase productivity. Thank you Jon!!!
Thanks so much Ivan! 🙌
Thanks, Jon! All so helpful, but I think I'll be using the macro function most.
Could you create a style for the SheetTitle macro? I never use the preset styles as they were never quite what I wanted.
Excellent tips and tools. Straight forward explanation.
Thanks, Simon! 😀
15:50 - Please tell me how to add a new sheet, or move or copy an existing sheet without the mouse (keyboard shortcuts).
Awesome video, thanks for sharing! Do you have any that shows how to use a vlookup formula to compare 2 different dates in 2 separate spreadsheets and then to present the difference in days between one and the other? Thank you! 👍👍
Great video… thanks for sharing!
I was already onto most of the tips but the macro bar at the end looks helpful and I’ll check out your video on that!
Cheers 🍺🍺
Thanks for the nice feedback John! I'm happy to hear you'll be learning more about macros. One of my favorite Excel topics. 🙂
I created buttons on my Quick Access Toolbar and assigned them to the most common macros I use. I didn't know we could make our own ribbon item though!
Great excell tips, very helpful! Thank you, Jon! =)
Glad it was helpful! 😀
I am going to benefit the most from Secret #5! Thank you!
That's good to know. 😀
Wow Jon... what a good short leaning video... I am ur new subscriber right away.
Thank you! 😀
the recording macro might have been the most helpful for me but mainly because i already kknew the others. overall great video
Thanks for the feedback! And I'm happy to hear you enjoyed the section on macros. We'll do more videos on that topic in the future.
I'm not sure how to follow along. Are there supposed to be some folders in addition to the file that has a tab called Leads? Do the folders contain CSV files? Where are they? thank you so much! And thank you, also for the wonderful vids!
Marvelous, very value added info
Thanks so much! I'm happy to hear it. 😀
Jon do you have a keyboard shortcut sheet for Mac
Hi Jon. Just found your channel today and subscribed. Great tips. May I ask - what screen recorder do you use? You appear to fly through the steps and are able to annotate very fast. I'd love to learn VBA, is there a course you would recommend? Thanks!
I didn't know you could hit F4 to make references absolute. That's so handy. Thanks!
Thanks about your knowledge
and special thanks for sample file
I can follow video step by step
thanks very much
Am new subscriber this one really awesome i learned new things especially ctrl+shift+end without knowing that i waste time now u saved everything :) do more video we support u kudos!!🥳
Thank you for your feedback! 😀
Hi Jon,
Thank you for the keyboard shortcut tips. Just a doubt to clarify. When I enter CTRL+SHIFT+End instead of going to end of the Column, the Print Preview Page Pops out. Please could you help me how to resolve this.
Hi Ronald, I'm not sure what is causing this. Are you using a laptop? Are you on Windows or Mac?
Thanks for these techniques
You are so welcome! 😀
Thanks for your newsletter bringing me here 😅
Thanks for being a subscriber! We appreciate your support. 🙏
For anyone else reading this, there is a link in the description to join our free weekly Excel Pro Tips Newsletter.
Creating a macro to insert and identically format a top row on multiple sheets is probably not necessary for most spreadsheet users. A different approach is to group a contiguous set of sheets by holding the Shift key, selecting the first sheet's tab and the last sheet's tab. All grouped sheet tabs will indicate that they are in active use. On an active sheet, insert the new first row and apply the desired formatting to the row. Entered text, etc. will be repeated on all grouped sheets.
Note that an operation on a grouped sheet might be repeated on all sheets of the group if the operation is valid for all grouped sheets.
Thanks Jon, these tips are really good, especially about recording macros. Paul
Thanks Paul! I appreciate it and I'm happy to hear the feedback on macros too.
Oh my goodness. Power query was the best for me. Thank you so much.
On another note, every August we have a huge business meeting (approximately 800 in attendance) that I have to download all the data from the online registration and create name tags (among other things). I usually download all the info into a csv, then create a 'label' in Word, add the fields, .. you get where I'm going. Is there a quicker easier way? Any help would be appreciated. Thank you.
Thank you!
Rial life practical job is it. Thanks for sharing
Welcome 😀
I have never created a macro in Excel, Access yes, but not Excel. Very interesting. You have expanded my knowledge on every point of your tutorial. I will use the quick keys for selecting ranges a lot. For the XLOOKUP function, is there value for naming headers and data in the formula? I know you most did absolute references. I really enjoyed this video. VERY HELPFUL!
I want to understand more on the xlookup formula and the thought process to how the formula works. Example why =xlookup(C6?
The macro - how to use the macro to run an automatic pick for a list of purchase orders every day, based on min and maximum inventory levels, without an inventory management ERP system?
Did you get an answer
@@toniantrowers5922 Not yet.
Very good, congratulations!
Thank you! Cheers! 😀
Thank you so much, excellent and helpful.
Glad to hear it was helpful! 😊
Excellent tips, thanks Jon!
Thanks Chris! I appreciate it! 🙌
Very good. Nice job!
In my very first proper spreadsheet (using Lotus 1-2-3 on MS-DOS), not just trying to learn how to use them, I used lookups.
It was only a modest size - but took over twenty minutes to recalculate. Needless to say, auto-recalc was impossible.
Things have changed.
Same! Lotus 1-2-3 as a summer intern in data processing. Had a fancy word processor with a "gold key" too!
It's been a minute...
very helpful!
need a bit more about power query- how do i get more videos on this topic- btw my favorite
Which key is the "Hold" key? 02:14
Really helpful!
Is there a way to select a group of cells in a column, then tab to the next column and have the same amount of grouped cells selected? For example selecting cells A1 thru A12 and tab over to have just B1 thru B12 selected?
very easy and clear
thanks for informative tricks
Great video. Thanks a lots
macros is a great tool to now use thanks
You're welcome! 😀
Some really helpful tips 👍
Great work sir🎉
So nice of you 😀
Woa so macros.... I want to make custom macros for.my business for our internal forms and sheets. I need to figure that out!!!
I need help on how to creates the formula for begin the start and end date then it gives prompt for PayPeriod and Fiscal year in Excel
hello, cant i download the file ure using in ur video???
oh my , i was searching for a day and this is the best video
Glad I could help. 😀
How does control shift end works when on my keyboard end has righ arrow so instead of going down its going to the right side
Love the cntrl + shift + end reminder, but now that I'm on a Mac we don't have an end button. figured out that shift + command + down arrow works if fields are filled in, but it didn't work when there are empty cells. Would love to know if anyone found the alternative when blanks. 🦋
Thanks my friend.
Love this.