CONCATENATE is an Excel function that you can add to spreadsheets to merge cells together. The function merges both text and numbers in alternative cells into one. As such, with CONCATENATE you can quickly merge columns and rows i...
A pictograph is a graph with pictures. The number of pictures in the graph shows you a specific value. Excel 2010 does not include any direct options to set up pictographs, but with a little customization you can convert bar graph...
The basic SUM function in Excel is sufficient for adding a variety of numbers across a range of cells. However, what if you only need to add a few numbers that match a specific criteria from a range of cells? If that is so, add th...
Excel includes a Move or Copy option that enables users to move or copy a worksheet with all its formatting and data intact. So if you ever need to set up a new Excel worksheet based on a spreadsheet in another workbook, you can q...
In other articles, I’ve already told you about Data Set and Icon Set conditional formatting options in Excel. In addition to those, you can also select Color Scales conditional formatting. That adds a two or three color sca...
Excel is one of the best spreadsheet applications that has a multitude of functions to select from. Among those functions is SUMPRODUCT. That’s a function that takes one or more arrays of numbers and adds the sum of their pr...
Excel has a multitude of functions that you can add to spreadsheets. Among them is the Count function, which is a handy statistical tool that counts spreadsheet cells. This is how you can add three Count functions to your Excel 20...
Did you know that you can create different text styles in Microsoft Word? This includes strikethrough texts, double strikethrough texts, shadowed texts, subscript texts, superscript texts, vertical texts, inverted texts and a whol...
The MS Office applications keep a handy list of recently opened files that you can open by selecting the File tab and Recent. However, it’s not so handy when it starts to include lots of documents you no longer need to access. Thi...
In MS Word 2007, you can find a list of your recently edited documents. It’s located on the menu that appears right after you click the Microsoft Office icon. With it, you can easily open or switch the documents that you’re workin...
In a previous post, you’ve learned how to add a narrative or voice-over to a presentation online. This time, you’re going to learn how to do it in MS PowerPoint 2007. It’s very easy to do. So if you’re all set, just read and follo...
This holiday season, you might want to give some custom-made calendars as presents. With custom calendars, you can include your family picture or even use it as a calendar background. Speaking of which, you do not really need to s...
In MS Word 2007, you can add and format page numbers according to the type of document that you want. It’s not really that difficult to do. You just need to become familiar with the tools and options that are available in the said...
In a previous post, you’ve learned an interesting trick on how to customize MS Word 2007 to make it appear like a minimalist text editor. It’s a great option for users who just wish to focus on their writing without any distractio...
By default, your MS Word document has a white background. Now, what if you want to customize its background? Like, for example, you want to change the background by uploading your own image? Is that possible? Well, it is. If you s...
