Online Video Courses

Health Newsletter Ideas for Health Related Articles

By Ugur Akinci | June 3, 2014

Health newsletters are sent by doctors, hospitals, clinics, insurance and all kinds of health-care companies to their clients and patients to keep in touch and maintain a good business relationship. Writing health related articles to meet the need for a constant stream of fresh health related articles is an excellent niche for writers. The typical…

Read More

FrameMaker – RoboHelp Integration – when to preserve modifications to a RoboHelp file?

By Ugur Akinci | May 19, 2014

© Ugur Akinci If you prepare your source files in FrameMaker and then import (or rather, link) them to a RoboHelp project like I do, there is one feature that you should pay attention to. When you bring in a source file and then save it in RH, the application displays the following warning message:…

Read More

ISNA Function for "Not Available" Excel Data

By Ugur Akinci | May 15, 2014

Data not available creates ugly error messages when we use functions in MS Excel tables. For example, in the below table:

Read More

How to Use SUMIF Conditional SUM Function in Excel

By Ugur Akinci | May 14, 2014

Microsoft Excel SUM Functions: SUMSQ – Square and Add Cell Values SUMPRODUCT – Multiply and Add Two Arrays SUMIF – Add with a Condition SUMIFS – Add with Multiple Conditions SUMX2PY2 – Add Sums of Squares of Two Arrays SMX2MY2 – Add Differences of Squares of Two Arrays SUMIF(), Conditional Sum, is a wonderful function that allows you to find the sum…

Read More