Microsoft Office articles
When you are working with data that involves money and finances, you often need to round amounts to a specific point such as a dollar or perhaps even a half dollar. The tried and true method has always been to use the ROUND function with […]
How to Round to the Nearest Half-dollar with Excel Read More »
Whether you are crazy about Outlook or not, it is the preferred e-mail software in offices around the world. As such, it would never hurt to learn all you can about this robust piece of software. After all, why wouldn’t you want to save time
Not sure what key combination I accidentally hit the other day in my office while working on a document (time sensitive of course) but lo and behold I suddenly had a split screen in front of me! Half of my document was in the top
Have you ever received a workbook from a colleague and wanted to print selections from more than one worksheet and have them all print on the same page? Sounds like voodoo magic doesn’t it? It can be done and doesn’t involve any crazy magic either!
How to Print Multiple Selections of an Excel Document Read More »
As you know, footnotes are used in documents to provide references or annotations. It is very easy to insert automatic footnotes in documents using Word, but suppose you would like to use a custom footnote mark? Turns out you can do this and just as
The use of macros in Excel is made possible by the VBA programming language and we tend to avail ourselves of it often in our workbooks. We do this because we want to do things within our worksheets quickly and efficiently. Every time we create
How to Remove the Enable Macros Warning from Excel Documents Read More »
In Academia there are often very lengthy documents that have myriad footnotes and they sometimes necessitate cross-referencing. This often occurs in technological business manuals as well. The issue here is that when you use automatic footnote numbering the cross-references can be a burden if you
How to Add Cross-References to Footnotes in Word 2013 Read More »
Folks receive an e-mail and notice that there is what they call a “hard return” at the end and double returns between paragraphs. One could waste a forest and print out the e-mail the way it is, but that seems a bit silly doesn’t it?
I was recently asked if it were possible to view the formulas that are in table cells, which were usually too long for the smaller cells in the table and not completely visible. And wouldn’t it be lovely if Word had a feature like those
Here’s a lesser known method to insert dates into your Word documents. Follow the steps below to learn how: Place your cursor on a blank line in your document. Display the Insert tab on your Ribbon. In the Text group, click Date & Time to
How to use Building Blocks to Insert a Date in Word Read More »
Including video in your PowerPoint presentation can make it pop, but before we begin there are a few points to keep in mind: PowerPoint 2010 will support QuickTime (.Mov, mp4) and Adobe Flash (.swf) files when you have installed the QuickTime and Flash players. There
Very often graphics are used in worksheets. Sometimes the graphics are used to demonstrate what resides in the cells and that is fine. Usually graphics sort with cells well. However, when you apply filters to those cells the graphics sometimes bunch up at the top
Most folks will tell you that Merged cells are a pain in the butt! Why? Because they can cause you lots of problems when you are selecting ranges, pasting, sorting, and other functions. Perhaps you may be in the habit of not using merged cells
I make a lot of appointments on my calendar and I realized soon enough that color coding them makes them easier to identify at a glance. In Outlook, this is done quickly using categories and you can even do it automatically. Assigning a Category to an
