If there is one single most important thing that you need to know in excel, that would be ‘Excel binary format‘.

When you save workbooks in binary format, your data will be compressed and the size will reduce drastically. This would prevent possible crashes due to file size. ( see figure 1)

Excel bynary format







Another notable feature is its compatibility, in case if you were to write & run some Macros in your workbook then the ‘binary’ format is your ideal option.

In fact, I did some comparison to prove it factually correct, the results are mind-blowing.

For a full content or more Tips & Tricks follow the link: https://plus.google.com/collection/YeJ9ME
Public Courses delivered in our Amelia ST Office, just opposite the Europa Hotel in Belfast City Centre.
Courses can be Delivered on Your Own Premises with the Following Provided at NO EXTRA CHARGE:
• Up To 10 Laptops
• LCD Projector
• Projector Screen & Flipchart
Click here for more info: https://www.mullantraining.com/
Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com

#ITCourses #NorthernIreland

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks