Рет қаралды 41
We have all encountered an Excel file that’s too large. The kind that takes minutes to open or save, so everything takes twice as long. Florence, Senior Consultant at UpSlide, has a few easy hacks up her sleeve that will help you reduce your Excel file size within seconds. Discover seven easy ways to compress Excel files in the article video.
Audit a large Excel file
Before we show you how to reduce your Excel file size, we’d first like to share a quick tip on auditing an Excel workbook.
For finance professionals working in Transactional Services or Investment Banking, building models with tons of formulas, tables and sheets is the norm. However, the more comments, formulas, conditional formatting, and hidden sheets you add, the heavier the Excel file gets.
You can easily discover which sheets are the heaviest in your Excel file. To do so, make a copy of your Excel file and follow these steps: #viral #youtubeshorts #video