*❤ Chapters in this video:* 00:00 Introduction to Excel Secrets 00:22 Tip 1: Insert Data from a Screenshot 01:43 Tip 2: Sum Values Fast Three Different Ways 02:57 Tip 3: Toggle Filters On and Off 03:26 Tip 4: Fast Filter Trick 03:43 Tip 5: Center Text Across Cells 04:44 Tip 6: Cell Message 05:26 Tip 7: Freeze Top Row 06:11 Tip 8: Freeze Top Row with Table 06:47 Tip 9: Freeze Bottom Row 07:16 Tip 10: Print Headers on Every Page 07:59 Tip 11: Move Cells with Mouse 08:36 Tip 12: Copy Cells with the Mouse 09:00 Tip 13: Copy Only the Visible Cells 10:09 Tip 14: Delete Blank Records 10:59 Tip 15: Fill Blank Cells 11:34 Tip 16: Fill Numbers to the Nth Value Using a Series 12:12 Tip 17: Fill Dates to the Nth Value Using a Series 12:50 Tip 18: Flash Fill Numbers 13:47 Tip 19: Flash Fill Letters 14:42 Tip 20: Smart Use of Clipboard 15:40 Tip 21: Quick Bar Chart with the REPT Function 17:28 Tip 22: McKinsey Lollipop Chart 22:36 Tip 23: Display File Path and Workbook Name 24:18 Tip 24: Hide Cell Contents from View 25:28 Tip 25: Center Text Across Cells with VBA 27:13 Tip 26: Remove Cell Formats 28:42 Tip 27: Filter Function, Single Criteria 29:33 Tip 28: Filter Function for Multiple Criteria 31:27 Tip 29: Create New Sheets from Values in a List Using a Pivot Table 33:25 Tip 30: Create New Sheets from Values in List Using VBA *Click here for the article with full VBA code:* www.launchexcel.com/top-30-excel-tips-and-tricks-2024 *Download the Free Excel Workbook* Step 1: Sign up for free: go.launchexcel.com/email-signup-youtube Step 2: Log in here: courses.launchexcel.com/dashboard/en/login Step 3: Download: courses.launchexcel.com/school/course/workbook-downloads/lecture/5074882#headline-44a5e8d5 *TIP: Stay logged in for quick access to all FREE workbook downloads.*
I started my "PC programmer" career a a Lotus spreadsheet guy for THE boss, and spent several years at that before "graduating" to mainframe programming... but my heart always belonged to Lotus (sigh) Now retired, I keep my "hand in" by making worksheets (Excel, Libre & Goog Sheets). Stumbled on this video while looking for something else -- and, half way in, this is the neatest 20 minutes I've spent on line in a while, LOVE IT! I might have to subscribe - just to see what else I don't know!
Thanks for your comment! I love sharing tips and find that I'm always learning new things. "Mastery is not about perfection; it's about a process, a journey. The true master is always a student, constantly evolving, growing, and striving to be better than they were yesterday."
Very helpful, thank you so much. I followed your other video to build a VBA code to center across selection (Tip 25 in this video). Can I ask, if it is possible to do the same, but vertically please? If so, do you mind sharing the VBA code please? I tried to tweak it around, but didn't work :( Thank you :)
Hi! Thanks for your question. It's not so easy to center vertically because Excel doesn't have a built in feature for this. You might need to reconsider what you need the centering for. For instance, can you achieve what you want with a text box? If so, I can help make VBA code for that
@@launchexcel hi Victor, thanks for your response. Yes please , it would be greatly appreciated if you could help make the VBA please. I did try to use the VBA you made for centre across and try to use chatgpt to change it to vertical, it didnt get the result that I wanted :) Thank you
Hi. I would like to ask you if you can help me? When I want to create a simple table. I select some cells, then Insert, then Table, and something appears below that says Create Table. And you can directly give Ok or you can select the box where it says "My table has headers". But even though I don't want to select "My table has headers" and I don't give that, I just give Ok, it appears with "My table has headers". What can I do to stop this from happening, to stop appearing with "headers"? Thank you
I guess Excel likes to automatically detect headers! One thing to try is to add a dummy header row above your data before creating the table. After the table is created, you can remove this dummy row by deleting it. I normally use a table with headers because it helps to know what's in each column.
Sorry for my late reply, just saw your message. Do you mean stock management (inventory) or stocks and shares (finance)? I can take a look at your requirement if you want. Contact me here: www.launchexcel.com/contact
Thanks for the question. I think get data from clipboard / picture works for Excel with an Office 365 subscription, sorry it doesn't work for Excel 2016. For those who use Excel 365, you also need to make sure you go to Excel > Preferences > Privacy and make sure optional connected experiences is enabled.
hi! There is an online text version here: www.launchexcel.com/top-30-excel-tips-and-tricks-2024 You can use a browser extension like PrintFriendly to convert the article into a printable PDF. I use it from time to time: www.printfriendly.com/ Hope that helps
*❤ Chapters in this video:*
00:00 Introduction to Excel Secrets
00:22 Tip 1: Insert Data from a Screenshot
01:43 Tip 2: Sum Values Fast Three Different Ways
02:57 Tip 3: Toggle Filters On and Off
03:26 Tip 4: Fast Filter Trick
03:43 Tip 5: Center Text Across Cells
04:44 Tip 6: Cell Message
05:26 Tip 7: Freeze Top Row
06:11 Tip 8: Freeze Top Row with Table
06:47 Tip 9: Freeze Bottom Row
07:16 Tip 10: Print Headers on Every Page
07:59 Tip 11: Move Cells with Mouse
08:36 Tip 12: Copy Cells with the Mouse
09:00 Tip 13: Copy Only the Visible Cells
10:09 Tip 14: Delete Blank Records
10:59 Tip 15: Fill Blank Cells
11:34 Tip 16: Fill Numbers to the Nth Value Using a Series
12:12 Tip 17: Fill Dates to the Nth Value Using a Series
12:50 Tip 18: Flash Fill Numbers
13:47 Tip 19: Flash Fill Letters
14:42 Tip 20: Smart Use of Clipboard
15:40 Tip 21: Quick Bar Chart with the REPT Function
17:28 Tip 22: McKinsey Lollipop Chart
22:36 Tip 23: Display File Path and Workbook Name
24:18 Tip 24: Hide Cell Contents from View
25:28 Tip 25: Center Text Across Cells with VBA
27:13 Tip 26: Remove Cell Formats
28:42 Tip 27: Filter Function, Single Criteria
29:33 Tip 28: Filter Function for Multiple Criteria
31:27 Tip 29: Create New Sheets from Values in a List Using a Pivot Table
33:25 Tip 30: Create New Sheets from Values in List Using VBA
*Click here for the article with full VBA code:*
www.launchexcel.com/top-30-excel-tips-and-tricks-2024
*Download the Free Excel Workbook*
Step 1: Sign up for free: go.launchexcel.com/email-signup-youtube
Step 2: Log in here: courses.launchexcel.com/dashboard/en/login
Step 3: Download: courses.launchexcel.com/school/course/workbook-downloads/lecture/5074882#headline-44a5e8d5
*TIP: Stay logged in for quick access to all FREE workbook downloads.*
A perfect tutorial with great choice of tipps, presented in a great layout!
Thanks a ton!
Really glad you like this video!
Thank you so much,
Really learned alot.
You actually A great Teacher, the Explanations are perfect
Thank you!
Thank you! I love your videos. You are very detail and easy to follow.
Thanks Tiffany!
Thanks!
Thanks for watching! 👍
very informative tips and tricks for my works, thanks for sharing, greetings from Timor Leste
Thanks Egas!
Nicely done! Great tips. Thank you for sharing.
You're welcome!
Excellent tutorial. Thank you!!!
Thanks @ivancortinas5427!
I started my "PC programmer" career a a Lotus spreadsheet guy for THE boss, and spent several years at that before "graduating" to mainframe programming... but my heart always belonged to Lotus (sigh)
Now retired, I keep my "hand in" by making worksheets (Excel, Libre & Goog Sheets).
Stumbled on this video while looking for something else -- and, half way in, this is the neatest 20 minutes I've spent on line in a while,
LOVE IT!
I might have to subscribe - just to see what else I don't know!
I'll be publishing more good stuff soon!
Brilliant! Thank you Victor.
Thanks for watching and commenting!
Excellent tips!
I'm glad you found them helpful
Aweeeesome, thank you for your video. It was very detailed and nice explained 😎
Glad you liked it!!
Thanks your valuable expertise share with us.
It's my pleasure!
Very Helpful. Thank you!
Glad you found it helpful!
@@launchexcel Do you have any videos on Macros and Power BI Aand Tableau
@@Govinda7995 Macros yes, Power BI and Tableau not yet. What would you most like to do with Power BI and Tableau?
Very nice presentation
Thanks @jayeshkmodi!
Thanks For such a informative video
You're welcome, I'm glad you found it informative!
You're My Real Master
Thanks for your comment! I love sharing tips and find that I'm always learning new things.
"Mastery is not about perfection; it's about a process, a journey. The true master is always a student, constantly evolving, growing, and striving to be better than they were yesterday."
Thank you 🎉
Glad you found this helpful!
Awesome video, thanks a lot
Glad you liked it!
Waoooo
Thanks very much
for sample file
I have follow your video
thanks very much
Glad you liked the video and sample file!
This is very helpful
Glad that you found it helpful
You are awesome
Thanks!
Thank you
You're welcome
Very helpful, thank you so much.
I followed your other video to build a VBA code to center across selection (Tip 25 in this video). Can I ask, if it is possible to do the same, but vertically please? If so, do you mind sharing the VBA code please? I tried to tweak it around, but didn't work :(
Thank you :)
Hi! Thanks for your question. It's not so easy to center vertically because Excel doesn't have a built in feature for this. You might need to reconsider what you need the centering for. For instance, can you achieve what you want with a text box? If so, I can help make VBA code for that
@@launchexcel hi Victor, thanks for your response. Yes please , it would be greatly appreciated if you could help make the VBA please. I did try to use the VBA you made for centre across and try to use chatgpt to change it to vertical, it didnt get the result that I wanted :)
Thank you
Powerful
Yes, and you'll become more powerful after you master these tips 😄
Hi. I would like to ask you if you can help me? When I want to create a simple table.
I select some cells, then Insert, then Table,
and something appears below that says Create Table.
And you can directly give Ok or you can select the box where it says "My table has headers".
But even though I don't want to select "My table has headers" and I don't give that,
I just give Ok, it appears with "My table has headers".
What can I do to stop this from happening, to stop appearing with "headers"?
Thank you
I guess Excel likes to automatically detect headers! One thing to try is to add a dummy header row above your data before creating the table. After the table is created, you can remove this dummy row by deleting it. I normally use a table with headers because it helps to know what's in each column.
If I give you a stock spreadsheet can you help me write formulas for it.
Sorry for my late reply, just saw your message. Do you mean stock management (inventory) or stocks and shares (finance)? I can take a look at your requirement if you want. Contact me here: www.launchexcel.com/contact
insert from picture not exist in excel 2016 what excel version you use?
Thanks for the question. I think get data from clipboard / picture works for Excel with an Office 365 subscription, sorry it doesn't work for Excel 2016. For those who use Excel 365, you also need to make sure you go to Excel > Preferences > Privacy and make sure optional connected experiences is enabled.
Where do I find the printable version
hi! There is an online text version here: www.launchexcel.com/top-30-excel-tips-and-tricks-2024
You can use a browser extension like PrintFriendly to convert the article into a printable PDF. I use it from time to time: www.printfriendly.com/
Hope that helps
You need to declare what version of Excel you are you using. Wasted a lot of my time trying to figure out how to do this with my Excel Student 2021.
Sorry Michael, hope you get to use the full version one day, it's definitely more useful.