How to Use SUBSTITUTE & REPLACE Functions to Change Patterns in Your Cells Automatically

Due to the special functions in Excel, more and more people rely on it to finish their work. Hence today, we will demonstrate on using SUBSTITUTE & REPLACE function to change patterns of contents in cells. SUBSTITUTE and REPLACE function are very practical in dealing with statistics. And the feature of this function can perform very well in certain condition. For instance, in this image below, there are many student numbers. Those numbers are for students of the last year. This year,...

Read more »

2 Means to Import Facebook Birthdays and Events into Outlook

Facebook know all of your friends’ birthdays. With ones’ birthdays upcoming, you will get notified. This article will teach you to import both Facebook birthdays and upcoming events to Outlook. Actually Facebook has a connection with Microsoft Outlook, which permits us to import all Facebook events to Outlook. Not only can we import them to our original calendar, but also we are able to create a separate calendar for them. Here are the concrete steps. Import Facebook Birthdays and...

Read more »

How to Add BCC Command to New Mail Message Window

As we can see, BCC is hidden deeply. If we need to BCC an email to others, we need to click “To” button to locate “BCC” field. In this article, we will look at how to add BCC command to New Mail Message window. Outlook permits us to customize ribbon as well as quick access toolbar, no matter change the tab order, add or remover tabs, etc. For example, I am frequently required to BCC emails. But BCC option is invisible in ribbon. Thus I add it to the New Mail Message tab, such that I...

Read more »