Excel pivot table

How to Aggregate MS Excel Daily Data with Pivot Table

Introduction If you have daily data that still makes sense when aggregated into weekly or monthly data, then you can accomplish that very easily in Microsoft Excel, thanks to the pivot table. You can apply this method to, for example, a data of “trucks arrived” or “shirts bought” per day since the total aggregate amounts…

Read More

​The “INVERTED PYRAMID” Principle in Technical Writing

The “INVERTED PYRAMID” principle is very simple: write what is most important the first, and what is the least important the last. REMEMBER: IMPORTANT STUFF – write them right away! Don’t sit on them. The traditional style of writing takes its time by first establishing the “base” of knowledge, similar to the way a regular…

Read More

7 Tips to Localize Your Technical Documents Successfully

Here are 7 tips to localize your technical documents successfully. “Localization,” or the translation of documents into multiple languages and their adaptation to local cultures, is a fast developing communication niche. We live in a “globalized” world. These days not only the goods and services but also all kinds of documents are shipped to (or are accessed…

Read More

Watch Your Adjectives Like a Hawk in Technical Writing

Watch your adjectives like a hawk when you’re writing a list or a procedure in a technical document. Here is an example from the “Workout & Nutrition Guide” that came with the exercise equipment I’ve bought the other day. EXAMPLE 1 “Continue your workout until you feel you are no longer using good form.” What…

Read More
Warning caution

How to Write Notes, Cautions, and Warnings

Introduction How to write notes, cautions, and warnings is an important skill in documentation. They can be used to make a point clear or to warn the reader about something they should be careful about or the possibility of personal injury. You can hurt or at least drive your readers crazy if you neglect the…

Read More

Two Ways to Direct Your Readers in Technical Writing

© Ugur Akinci There are many times when while writing a procedure you’ll have to direct a reader in one direction or another. There are two types of directing instructions: A REFERENCE and a BRANCH statement. And both of them can be either CONDITIONAL or UNCONDITIONAL. I’ll give an example of each. UNCONDITIONAL REFERENCE: Refer…

Read More