Microsoft Excel
To protect a worksheet 1. Select the cells you want to users to change. 2. On the Home tab, in the Alignment group, choose the small arrow to open the Format Cells dialog box or right click and select Format Cells. 3. The Format Cells dialog box launcher opens. On
Microsoft Excel
Icon Sets in Excel Use an icon set to present data in three to five categories that are distinguished by a threshold value. Each icon represents a range of values and each cell is annotated with the icon that represents that range. For example, a three-icon set uses one icon
Microsoft Excel
Why use sparklines? Excel 2010 brought us a new feature called Sparklines. Data presented in a row or column is useful, but patterns can be hard to spot at a glance. The context for these numbers can be provided by inserting sparklines next to the data. Taking up a small
Microsoft Excel
Why use a treemap in Excel? A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store’s best sellers. The tree branches are represented by rectangles and each sub-branch is shown as a smaller rectangle. The
Microsoft Excel
Microsoft Excel has the number group on the Home tab that is frequently used. The number group has five commands on the bottom row. Going from left to right the commands are Accounting Number format, Percent Style, Comma Style, Increase decimal, and decrease decimal. 1. Accounting Number format 2. Percent
Microsoft Word
To perform a mail merge with Microsoft Word, you need a **data source** or a **mailing list**. The mailing list can be an Excel spreadsheet, a directory of Outlook contacts, an Access database, or an Office address list. It contains the records Word pulls information from to build the addresses
Microsoft Word
Microsoft Word - add the filename and path in the footer by Chris Menard - YouTube You should add the filename and path to a Word Document, so the next time you have to update it, you know exactly where you saved it from looking at the printed copy. I
Microsoft Outlook
You can send an email message out to a contact group (distribution list), or just manually put everyone on the TO or BCC line, but if you want to personalize each recipient’s email message, you need to do a mail merge. Why would you want to do this? If
Microsoft Outlook
Outlook - turn off desktop alerts and notifications by Chris Menard - YouTube An Outlook Desktop Alert is a notification that appears on your desktop when you receive a new email message, a meeting request, or a task request. By default, Desktop Alerts are turned on. If you are doing
I love Gmail and I’ve been using if for over 10 years. One feature that Outlook has that I frequently use is called “Delayed Delivery”. Instead of sending an email at 3:45 pm, when it may not get read today and end up way down in the recipient’
Microsoft Excel
An array formula is a formula that can perform multiple calculations on one or more of the items in an array. Array formulas can return either multiple results or a single result. Array functions keep your Excel file smaller in size. In general, array formulas use standard formula syntax. They
Microsoft Excel
The **Countif** function in Microsoft Excel is one of the most popular functions in Excel you can easily master. I use Countif to figure out how many employees are in a certain state or how many customers placed an order for $100 or over. You can even use wildcards in