2 Functions to Calculate Weighted Averages in Your Excel

Sometimes you will calculate the weighted averages for your data. Here you can use two functions to calculate it quickly. In Excel, you will certainly do many calculations. Among those calculations, you will sometimes need to calculate the weighted average. For example, there are sales volumes of different products. The image below shows the sales volume of one representative. Here you need to calculate the weighted average of different sales representatives. And the weight of different...

Read more »

How to Change the Default Settings of a New Excel Workbook

You will certainly make some modifications in an Excel workbook. But changing the default settings according to your need can quicken your work pace. There are four options that you can modify in an Excel workbook. When you create a new workbook, you will see the settings that you have made. Below we will talk about how to change the settings in detail. 1.      Font When you open a new workbook, the default font is “Body Font”. Here we open a new workbook and input a phrase into...

Read more »

How to View More Than 30 Outlook Calendars at the Same Time

By default, Outlook only supports us to view less than 30 calendars at the same time. If you wish to view more simultaneously, you can utilize the method introduced in this article. When you select “Calendar” as the current view and try to view more than 30 calendars in Outlook 2010 or 2013, you must be going to receive an Outlook alert. It looks like the following screenshot. That is to prompt you that only less than 30 calendars can be viewed at once. Apparently, Outlook is...

Read more »