5 ways to manage emails and control spam in Outlook

Spam lives on, despite all our efforts to snuff it out—but Outlook has some features to help slow it down. Here are some things anyone can do, plus some tips for working within a corporate Outlook system. 

Use Outlook’s Block Sender feature to add intrusive spam to your Block Sender List, and then move it to the Junk Email folder. This works fine if you receive fewer than a dozen emails a day.

Read more »

1

How to create custom Input & Error Messages In Excel

In Excel, custom input or error messages explain the rules for each field to prevent data-entry errors. Imagine, for instance, that it's your job to create, maintain, and assign user IDs and passwords for your company employees. You create a spreadsheet to perform this task. Then you get transferred. So now you have to delegate this task to someone else. The best way to ensure the job is done right is to create input and error messages. 

For the User IDs, first create an Error Alert that says, "No duplicates allowed." Then create an Input Message that, when displayed, explains what kind of data can be entered. And last, a backup Error Message for column E that says: "Only 7 digits allowed."

Read more »

0

How to customize Excel Conditional Formatting

Excel Conditional Formatting already lets you format cells based on the value of those cells or the value of the formulas in those cells (see our conditional formatting tutorial for more details). Now we'll show how you can customize these features so you (and others) can quickly scan your spreadsheet and determine at a glance what the data means based on the way each column, row, cell, or range is formatted.

Here's how to find the customization options. In any spreadsheet, choose Home > Conditional Formatting > New Rule. The New Formatting Rule dialog window opens.

Notice the first panel: Select a Rule Type. We'll go through the options in turn:

Read more »

0

Photoshop Text Effects: Adding Styles to fonts

Photoshop Text Effects, also called Styles, let you add color schemes, textures, and other variations to fonts. Text Effects take a font much further than we've shown you in tutorials on creating swirls and flourishes with text, or Text Type and Text Editing.

Text Effects or Styles should not be confused with Special Effects, which include features such as Shadow, 3D Effects, Lighting, and Depth, and apply to both Text and Shapes. They are also not the same thing as Microsoft or HTML Stylesheets or Style Sets, which define how fonts and paragraphs are displayed in documents. Text Effects in Photoshop are also much more elaborate and decorative than Styles in other software programs. If you want your text to look tie-dyed or beveled or shaded, this is the place to go.

Styles are accessed through the Window tab and, when checked, appear as a floating palette menu on your Photoshop desktop. Photoshop comes with many pre-designed (Default) Styles, 16 of which are preloaded. You can load the additional Default Styles like this: 

Read more »

0

How to use Word to create holiday cards and other projects

Microsoft Word may not be a full-fledged graphics program, but you can use its layout, font, text box, and other features to make, surprisingly, exceptional custom holiday cards with a little clever manipulation and some creativity. You can use images or clipart from your own collection, download royalty-free images from the web, or use Shapes and Special Effects in Word to draw your own custom images. 

Note: If you’re planning to use envelopes (as opposed to a postcard-type design), note that the paper size may be determined by the size of the envelope. So, choose your envelopes first, then create your project.

Read more »

0

Excel Spreadsheets: Navigation, shortcut keys, data sort and filter, formulas and functions

Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more. We’ll add to this guide over time, so bookmark it and come back to keep learning.

Think of an Excel spreadsheet as an electronic flat-file database modeled after a bookkeeper’s ledger. Excel’s “spreadsheet” is like the ledger’s page, and Excel’s “workbook” grouping of spreadsheets is akin to an entire ledger. The best use of a spreadsheet is to provide users with groups of records that are available on one screen for easier management.

Read more »

0