How to Look up Values in a Range by Combining MATCH & INDEX functions

In our previous article, we have introduced the function of VLOOKUP and explain the usage of the formula. And today we will introduce the function combination of MATCH and INDEX to look up values. Excel functions have very amazing effects, which can help us do many complex tasks. The independent function can achieve certain functionalities. In addition, you can also try to combine different functions to deal with your problems. Thus today, we will combine the MATCH and INDEX functions to...

Read more »

When Do You Need Absolute References in Excel?

There are many different functions in Excel that you can use. And due to the feature of insert, you can save a lot of time on changing the area in formulas. However, in some formula, you don’t need to change certain area. Thus, we have today’s article of absolute references in Excel formulas. Excel contains many different functions, and some of which can always be used in your work. For example, the sum function, average function, count function and many others. Some of the functions...

Read more »

How to Change the Fonts in Outlook Navigation Pane

Are you tired of the default fonts in Outlook navigation pane? In this article, we will look at how to change its fonts, no matter in Outlook 2010, newer versions or older versions. As we all know, Outlook provides us with a lot of initiatives when customizing the appearance of Outlook pages. For instance, we can change the fonts in Outlook navigation pane. Since Outlook 2010, we have been permitted to change the navigation pane fonts directly within Outlook. As for Outlook 2007 and older...

Read more »