Gary Eckstein Microsoft Office 1 COUNTA, excel, Function (mathematics), Microsoft Excel, Microsoft Excel 2007, SUMPRODUCT
I recently had the need to count the number of rows in a Microsoft Excel 2007 workbook. Normally I’d be able to use the ROWS function that ‘Returns the number of rows in a reference or array’. ROWS wouldn’t meet my needs as I required to calculate the number of rows where any value besides [...]
Gary Eckstein Microsoft Office 0 how to, Microsoft, tutorials, word 2007
Occasionally, pages of arbitrary text are required. For example, you may require seeing what a Blog post of 5000 words looks like or you may be designing a pamphlet and need text to see what the design with text looks like. Fortunately, Microsoft Word has an inbuilt function (Microsoft claim that it isn’t an ‘Easter [...]
Gary Eckstein Microsoft Office 3 how to, instructions, Microsoft, Microsoft Office, microsoft word, Office, Page Break, Software, word, word 2007, Word Processors
Microsoft Word Page Breaks have caused much anxiety in this world. Many of us have experienced the anguish of an unwanted break separating text. Attempting to identify the reason for the break and removing the cause can be a very frustrating experience. Without further ado, here is how to get rid of an unwanted Page [...]
Gary Eckstein Microsoft Office 2 google, google docs, Microsoft, Microsoft Office, ms office, office software, openoffice, oracle, Software, software suite, visio
In the newspaper this morning was an interesting article titled ‘Battle for Office reaches new heights‘. I like that the article mentioned the fundamental difference being that MS Office is installed locally on the Computer whereas Google Docs requires an Internet connection. Many people do not have constant Online access therefore need to be aware [...]
Gary Eckstein Microsoft Office 0 Software, visio
Microsoft Visio is a very powerful tool and may be used for many time saving and diagramming activities besides the common flowcharting for which it is employed. For example, are you aware of the Visio ShapeSheet and the information and opportunities it provides? Because so much of the functionality of Visio is hidden (or not [...]
