Online Video Courses

How to Print Invisible TOC and Index Markers of a MS Word Technical Document

By Ugur Akinci | March 28, 2013

A well designed and written index is an indispensable component of any technical document. As an indexer and technical author there might be occasions when you’d like to print a list of invisible TOC and index markers of a MS Word Technical Document which is a task that requires some experience. In this post we…

Read More

How to Calculate Optimal Product Mix with MS Excel “Solver” to Maximize Profits

By Ugur Akinci | March 27, 2013

To calculate optimal product mix with MS Excel “Solver” to maximize profits is easier than you thought. Here is the situation: Imagine you’re running a manufacturing plant, producing hats, shirts, gloves, and other similar items. You know the following: The number of each item you are now manufacturing. The number of labor units you need…

Read More

Importance of Technical Communication at MIT

By Ugur Akinci | March 26, 2013

© Ugur Akinci By underlining the importance of technical communication education at august MIT (Massachusetts Institute of Technology), Sam Shames (“Opinion: Beyond technical communication“) has made an important point that we as technical writers should also pay attention to: Technical communication is not only the art of writing reports, emails, memos, and similar “business items”…

Read More

How to Filter a MS Excel Data Set with Multiple Criteria (Advanced Filtering)

By Ugur Akinci | March 25, 2013

© Ugur Akinci Let’s imagine you’re working with the following data set: Let’s say you want to find only those transactions in which SHOES were sold for LESS THAN $20. Follow these steps: (1) Enter a couple of empty rows to the top of your table. (2) Copy your HEADER row and paste it to…

Read More