Microsoft Excel
Need to calculate the weighted average for work or school? There are two ways to do it but the easiest is to use the sumproduct function in Excel. It is easy to calculate the average. Just use the average function in MS Excel which will show you the calculated “central”
Microsoft Excel
You can’t import recurring or repeating events into the Google Calendar. Here is a workaround I use so you can pull in the recurring events. The top row of your csv file should contain the fields needed to import into Google Calendar. I added a field called Recurring and
Microsoft Word
Microsoft Word has a feature that is rarely used but is very helpful. It is double click and type. Just double-click anywhere in the document and your insertion point (the cursor) will be placed exactly at that place. I use this all the time to add videos or images to
Microsoft PowerPoint
Are you the person that has a 75MB PowerPoint? The reason most PowerPoint presentations get too large in size is due to images. The good news is you can batch compress all your images at once. So if you have 100 slides with an image on every slide, you can
Microsoft Excel
Need to apply conditional formatting to groups of data? It can be done, you need to sort and have a “helper” column. This short video demonstrates how to add a helper column and use an IF statement and then you the ISODD or ISEVEN function statement with conditional formatting. Video
**Irfanview** is a free popular free image viewer and has a batch processing feature. One of the batch processing features allows you to resize all your large images at one time. Another feature I came across is the ability to change JPG images into PDF files. Why would you want
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