You can certainly do more with the Find and Replace function! More »
Find out which commonly misused singular words that make it into my top list. More »
Changing values in a drop-down list doesn’t have to be a headache. Learn how! More »
There are just so many formulas in Excel that you could use to your advantage, especially when your report involves a fair bit of calculation or requires a certain amount of analysis. I will share with you, my top four basic formulas that I frequently use in most of my reporting tasks.
Have you came across a document that opens up a dizzyingly view of red markings and balloons all over the place such as this one?
In my previous post on how you can creatively use the Find and Replace function to do more than just the average task of finding and replacing words, you can also use this function to search for highlighted words throughout the document. But then you’d probably wonder, why would you want to highlight some words and then search for it later?
Conditional formatting in Excel has many useful purposes. I normally use it to alert or warn me if a certain condition is met (or otherwise). Let me get started on how I use this feature in a spreadsheet that I have developed to monitor the status of a data migration project.
Most of us use the Find and Replace function for basic word search and/or to replace an existing word with a new one. You can certainly do more than that. Here’s the scenario. An engineer came up to me and asked whether he could do a global change on the formatting for selected words throughout a 20-page document without having to search and replace it one by one. Well, of course he can. Here’s how:
I have been working in the IT industry for almost eight years and frequently encountered common singular words that are misused in project documentation. Just like the singular word “furniture”, these words do not have plural forms:
This simple tutorial will show you how easy it is to change the values in a drop-down list.
Drawing with precision takes a lot of effort and time, but this is usually necessary when you want to create a good quality professional diagram. Thankfully, Visio has an excellent feature that enables you to quickly align your shapes horizontally or vertically.
While there are countless tips and tricks out there, these three are perhaps the most widely used based on my experience so far.
Generally, the default size of a slide is large enough for reading when it is printed out in Notes Pages mode. But somehow, the set of slides that my manager received appears to be smaller than usual. Take a look at the following picture: