Helpful Tips Blog
Excel Tips
How can I assign colors and Background Image in Excel?
Background Color To add background color there are a few ways. If you want to add color to a range, you can select the range (or select the entire worksheet by clicking on the box above the cell rows) and then click on the Fill icon on the Home tab. If you...
Calculating Averages in Excel
The Average() Function The Excel AVERAGE function returns the average (arithmetic mean) of a range of values. It's much like the SUM function where you enter the range of values you want summarized. For example A10:A50 or B3:B156. The following example averages the...
How do I embed a “live” Microsoft Excel chart into my Word document?
When you paste your chart into Word, make sure you select the correct Paste Options. Use one of the options that will Link Data. Your chart will be pasted into your document. When your Excel data has changed, make sure that you save your Excel file. Now go to the...