We can compress images using excel.Sometimes Excel file contains images which increases it size. It could be 30 to 50 Mb. We can use external website to compress files but it is time consuming first you will upload files to website and then again download it. It consumes data sometimes due to internet speed issue file can not be uploaded successfully.
Steps to compress images using Excel:
To compress images using excel. Select image or multiple images and click on Format button in tab as shown below.
Then click on compress picture button as shown above another dialogue box will pop up. Select option 220 and 150 as required then click ok. Images will be compressed and file size will reduced now.
[…] Count formula in excel will count the numbers present in the cell of the selected data whereas counta formula will count the number of cells that contains data.as shown below in image. […]