Sort Data Left to Right to Create Report Quickly in Excel | Vivekananda Sinha | Video 154
HTML-код
- Опубликовано: 23 июл 2024
- Sort Data Left to Right to Create a Report Quickly in Excel
In most cases, while working on Excel Reports, we get the source data from any software or our collogues. Image a source data contains 50 columns and I want 20 columns from that source data to create my report and the order of the columns are not exactly the same. So it will consume lots of my time by doing it manually using traditional cut-paste method. The task is more hectic and monotonous because it is my daily task. In this tutorial, I will show you an awesome way to get the desired columns quickly. The trick shown will work across all versions of Excel. Be it Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365.
📂 Download the file: futureinhands.com/youtube/ass...
📚 WHAT YOU WILL LEARN:
Excel Data Sorting
Excel Data Sorting Left to Right
Data Sorting Advance Options
Excel Magical Trick
Report Creating Technique
MIS Reporting Methods
Advanced Excel Tutorial
🌏 Install Telegram App: telegram.org/apps
💡 Join our Telegram Channel: t.me/futureinhands
💡 Join our Telegram Group: t.me/futureinhandsclub
📚 Want to see more awesome content like this as soon as it is published: goo.gl/K99P4j
☕ If you find my videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/Vivekana...
👮♂ ABOUT VIVEKANANDA SINHA:
An MCA Professional and a Microsoft Certified Microsoft Office Specialist, Vivekananda is working as a Chief Mentor and currently heading Future in Hands. He worked with the Top corporates like Mphasis, Motherson Group with 10+ years of industry exposure. He received several Best Trainer Awards from corporates for Microsoft Office based workshops. He facilitated 100000+ professionals from 500+ companies like Taj Group, ICAI, British Council, BSI, NIIT, IndiaMart, MetLife, Mahindra and lots more from Executive level to Sr. Management. Learners say his sessions are like magic shows.
🌐 LinkedIn Profile: / vivekananda-sinha
🎤 GEARS, I USED TO CREATE THIS TUTORIAL
Screen Recorder: amzn.to/2MrJYkl
Microphone: amzn.to/3odwYwT
🎼 MUSIC IN THIS VIDEO
Music by / ikson
🌐 SHARE, SUPPORT, SUBSCRIBE !!!
Subscribe: goo.gl/K99P4j
RUclips: / futureinhands
Twitter: / myfutureinhands
Facebook: / futureinhands
Facebook Myself: / vivekananda.sinha
Instagram: / vivekanandasinha
LinkedIn: / future-in-hands
LinkedIn Myself: / vivekananda-sinha
Website: futureinhands.com
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#FutureInHands #VivekanandaSinha #MicrosoftExcel #MicrosoftOffice
Awesome 👍
Awesome Sir..
Magical trick🙏🙏
Very good sir
All clear
Really it's magical
Clear
Super
Very useful method sir... 👏👏👏👏
Awesome tip. Thank you so much Sir for sharing. Enjoying and learning all the videos:)
Sir, got it. Thanks a lot
Sir aap bahut smart dikh rahe hai Raju ekma Bihar
Hahahaha 😅🤣
Thank you so much ❤
बहुत बढ़िया एक्सप्लेन किया। सर क्या कस्टम लीस्ट को VBA मे इस्तेमाल कर सकते है?
Bilkul kar sakte hai
I will introduce a raw on the top and give number 1, 2,3...5 to the required columns. Then select all the data and sort it horizontally from smallest to biggest. Work is done easily.
But you have to do it everytime if you are not creating a custom list. Further, the new raw data is coming everyday... so you have to write 1,2,3,4... every time in the raw data and it is again a time consuming and manual process...
With due respect sir, this is an excellent way to do provided you want to have the same order as per custom list. What Will you do if you have different order every time? Imagine the total number of permutations of 12 columns taken 7 at a time. However, I am your fan have leart many excellent tricks and short cuts from your videos. Your videos are magnificent. Thank you.
Thank you for your wonderful words. It meant lots to me. ❤ Yes.... if the order is different every time then... either manually or VBA.
Clear