Steps to reduce File Size
1. Save as xlsb
2. Remove unwanted formats
3. Revoke data from Pivot tables
4. Compress Images
5. Change Formulas to Values
Email: samsgridview@gmail.com
Youtube: https://www.youtube.com/channel/UCfi_ZHNa_yJbkWXcNXbm_-Q
Facebook: https://www.facebook.com/samsgridview
Templates:
Inventory Management: https://youtu.be/hp1bIsQWE8M
Covid Dashboard Playlist https://youtube.com/playlist?list=PLenUwu_HamzPod80zMDvr_6IuY8fVQVUd
Reconciliation Template https://youtu.be/pjYrTFs_nVo
Quick Bites:
Flash Fill https://youtu.be/Bl6vi4aqH1Y
Quick Analysis https://youtu.be/1KoJFHWOero
3 Steps to clear Formats https://youtu.be/l-1AkGRIqzk
Shortcut Challenge https://youtu.be/GqLdiS6uEXs
Dynamic Vlookup https://youtu.be/qD6SQ8tNwQs
Absolute Reference https://youtu.be/3EtB2IhZkLg
Dynamic List https://youtu.be/Lso53Ymb77Q
Format a Row Completely https://youtu.be/KogPmiNE424
0 Comments