Tag: Excel

Make Your Printed Spreadsheets Pop with this Excel 365 Tip

By

Get Shift Done: Tips and Tricks

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.

Read More

Using the IF Statement to Keep Your Data Clean in Google Sheets

By

Get Shift Done: Tips and Tricks

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.

Read More