Microsoft Excel
Conditional formatting is one of my favorite features in Excel. I like it because I’m a visual person. Excel has a lot of predefined rules in Conditional Formatting, but it is very easy to write a formula if the predefined rules don’t have what you need. An Executive
Microsoft Excel
You can use data validation to restrict the type of data or the values that users enter into a cell. An example would be if you have a column for Departments, and someone puts in Accounting but another person types in Acct. (abbreviating Accounting). Data validation keeps bad data from
Microsoft Excel
There may be times when you do not want a cell reference to change when filling cells. Unlike relative references, **absolute references** do not change when copied or filled. You can use an absolute reference to keep a row and/or column **constant**. The keyboard shortcut for absolute reference is
Microsoft Excel
Excel has built-in custom lists. You can sort data by days of the week or months of the year. Or create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically, such as July to June; October to September; S, M, L, XL. With
Microsoft Excel
When the numbers in your Excel file vary widely from data series to data series and you want to create a chart, the chart to create is a **Combo** chart. You would also use a combo chart when you have mixed types of data (for example, revenue and net income
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 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
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