In this Blog I want to show you how you can use Quick Parts to quickly drop standard blocks of text into an Outlook message.
Saving document parts as Quick Parts not only saves time it promotes consistency through-out your documents. A standard paragraph of text can be recorded and quickly dropped into a document at any time. Continue reading Word – Quick Parts and Building Blocks: How can I modify a Quick Part?
Anyone that regularly imports data into Excel will be familiar with the process of “data cleaning”. This is where you need to remove spaces and irrelevant data in order to get the data fit for use in Excel.
I recently had an excellent question regarding working with data imported into Excel where negative numbers are imported with the negative sign to the right of the number, e.g. 500-. These numbers are commonly referred to as “mirrored negatives”. Continue reading Excel – How do I move the negative sign in front of the number?