Bland just doesn’t cut it when you’re trying to impress clients or the boss. Here’s how you can punch up the intensity in your Excel 365 spreadsheets with a simple tick of a box.
Excel 365 has a little-known high quality print mode. This mode makes graphics print bold and sharp so your spreadsheets look top-notch. This is particularly helpful if you’re presentation includes hi-res photos.
To set it up, go to File > Options > Advanced. Then, under the Print heading, tick the box for high quality mode for graphics. When you’re done, click OK.
The IF statement surely is among the most commonly-used formulas in Google Sheets. It’s used for looking up data or making calculations under specific conditions. But did you know that the IF statement can help you keep your sheets looking clean and more readable?
That can be important, or at least a time-saver. When setting up a spreadsheet into which you import, add, or copy and paste data frequently, it can be a pain to drag or copy formulas down to your new data.
For example: We created a spreadsheet in which to track inventory for our gift shop. We have a tab for when we purchase inventory, and another for when we sell inventory. Instead of looking up the inventory number, we use a SUMIF statement that looks for the inventory name matching the item we sold, and then fills in the inventory number for that item.