Why my excel file size is huge and how to reduce Excel file size (हिंदी में)
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- 👉 FREE Excel Webinar. REGISTER NOW
event.webinarj...
In this video, we will talk about “Why my excel file size is huge and how to reduce Excel file size (हिंदी में)”.
=========================================================
For any training, requirement - trainingbylokesh@gmail.com, info@nurturetechacademy.in
Or
Visit: www.nurturetec...
=========================================================
• Reasons for big file size
1. Unwanted cell colours, formatting or Conditional Formatting
2. Unintentional use of Columns/Rows
3. Presence of unwanted objects in the sheet
4. High resolution or unwanted images
5. Presence of unnecessary hidden sheets
6. Huge Data
• Save the file in Binary i.e. “.XLSB” file extension
• Pros.
Much smaller file size (up to 90%)
Open, saving, closing becomes much smoother
• Cons.
Can’t say it has macros or not.
Hard to open up in non-Microsoft tools e.g. Mobile apps.
Not supported by 2003 & earlier versions
• How to efficiently work in Excel files with Huge Data?
Keep your data sorted while working with Lookup function (this will speed up the process)
Use once concerned ranges in function like Vlookup or CF. Don't refer to entire columns or rows
Disable automatic calculation mode
use Power Query
• Bonus Tip: How to find a sheet’s file size?
Save it as a webpage and it will tell us the size contributed by each sheet.
===================================================
LIKE, SHARE, COMMENT, SUBSCRIBE TO MY CHANNEL, PRESS THE BELL ICON
For more such videos subscribe to our channel: / @learnwithlokeshlalwani
Follow me on my Instagram for the latest updates:
www.instagram....
#learnwithlokeshlalwani #nurturetechacademy
Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥
THANKS BROTHER I HAVE SOLVE MY ISSUES REGARDING BIG SIZE FILE...GREAT VIDEO
Happy to help
Aapne jo vidio bananee mehant ki hai aur jis trha se smjata hai such me lajvab hai..bhagvan apko bhot tarkki de...apke gurdakhshna ke badle apki har aad dekhung
Thank you so much
i like your filing saving system and i am appriciate you dear thanks for valuable information sir
Thank you so much it's very very useful and working information
🙌🙌
thank you so much. you helped out a lot
Best vedio to Reduce size of Excel sheets . Great work
Thanks and welcome
Thanks for the video... It worked with the first tip..
Dear Mr Lalwani, I am enjoying your classes. These are superbly made and the solutions that you give are so simple and lucid. Great work!!! My sincere thanks and congratulations.
Hi Anup, Thank you so much for your message. I am glad you like my work. You can also become an expert in Excel by joining my premium course. Have a good day. learn-with-lokesh-lalwani.thinkific.com/courses/Excel-Masterclass
Hi, This is very useful, nice inputs. Explanation is superb.
I can't thankyou more.. Loved it ❤️
Aapka explanation excellent hai ji
Regards
Please make work schedule file and work progress file
Super information subscribed with clicked in bell
Best information for Excel user. Heartily thanks sir
Hi Hemraj,,
Thanks for commenting 😊
Also, i am about to launch an Excel FREE course soon, I will announce it on our telegram channel, where we post new updates everyday. So, don't forget to join here: t.me/learnwithlokeshlalwani
Stay Connected :)
Happy learning:)
Lokesh Lalwani
Thaaaanks for the great guidance, it helped me a lot
Glad to hear that!
THANK U SO MUCH SIR
YOU ARE REALLY VERY GREAT
I ALWAYS LIKE YOUR EVERY VIDEO
Thank you so much for your lovely comment :)
Nice explanation regarding Excel workbook.
Thank you Sir for this solutions I was facing lot of problems because of this.
The pleasure is all mine Sushil.
Also a relevant information for you . I am doing a FREE webinar on coming Saturday i.e. 4th July at 7 PM on "How to earn online and become freelancer using Excel of any other skill.
Here is the link: mailchi.mp/6b3191d76897/uo32sv5nye
Do join, as this is going to be very useful for you.
Happy learning :)
Oh my god !!! Excellent sir
Hello Lokesh,
thanks for such a very informative and practical video. in fact i was disturb with one of my excel file on which almost everyday i used to work.....in the starting its size was 3 mb and gradually it increased up to 32 mb....i was very much disturb because it was taking lots of time to save.. after watching your this video...i found that there were 19 hidden sheets which were increasing file size and when i deleted one by one...its size came back to 3 mb as usual :)
Hi Saurabh,
Glad to know that my video helped you.
Happy learning :)
Great way of learning useful information. Thanks a lot, you are my inspiration to learn.
Thanks Nirmal
Good video for learning.
Thanks
Awesome sir
Thanks for this valuable information
This was very useful. Many thanks for your inputs.
The pleasure is all mine Sureshsaran. Don't forget to sign up for the FREE Excel course and take your Excel skills to the next level : learn-with-lokesh-lalwani.thinkific.com/courses/Freemium-Excel-Course
Happy Learning 😊
Pls make a vedio when file size less but still file or sheet getting slow
Tanx sirji
Thanks 👍
Thank you
Love this video
thanku sir, its very helpful
Most useful video for me, I needed it, sir this video so long
Thanks, Yes its long because i tried to cover all the ends.
Very useful and crucial concept
Thanks. I am glad it helped. 🙂
Kya aisa krne se EXCEL FILE RAM bhi kam use kregi .
Plz tell me
Good explanation!
Thank you so much 🙏
Sir ji ye files kanha se download karu? Please help!
Toooo good
hatts off🙏🙏
Create move and copy karne par kai baar ok ok karja padta hai.sir give me the solution
Sir what is circular reference,how it can be solved
I have an Excel file of 227 MB and i have to work with that. But I am unable to work there. Please guide me how can I do that.
Super
really fantastic
Thanks Arun :)
Also, don't forget to join my upcoming FREE webinar on 4th July 7 Pm. Were i'll be discussing about how to earn money online and become freelancer using Excel of any other skill.
Here is the link: mailchi.mp/6b3191d76897/uo32sv5nye
Happy learning :)
Thanks for video
Most welcome :)
Hello sir
Sir, please help me.
I am 12th passed out and pursuing BSC from open University and learning basic computer. I am interested in Excel because of you. I got to know that after learning excel and power bi is better option to earn near to 1 lakh per month.
I want 9 to 5 job only as my interest in other things as well so l want only peaceful job. I also want to live in Canada . So l decided to be data analyst, data scientist . But l don't have exact path. Right now my goal is to learn basic and advanced excel . But after that what should I do ?? How can I get my goal which is 9 to 5 job in foreign country, and handsome salary.
Hi Mohit, i believe in one thing that gaining indepth knowledge on a right skill will help you achieving you life goals. So, i woukd suggest that first focus on getting indepth knowledge and then also get certified in the same skills. Once you do so then opportunities will knock your door.
I wish you all th best :)
Regards,
LL
Sir my values are gone what to do but size reduced
Sir maine kiya lekin kuchh bhi nahi hua....
Bahut accha hai.. lekin mera size nahi kam horaha hai
Thanks Subhojit for your comment. Try all the 6 methods mentioned in the video...you will surely get good results.
Thanks
Thanks