Online Video Courses

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

Two Ways to Work with Conditional Text Tags in RoboHelp and FrameMaker

By Ugur Akinci | May 13, 2014

Conditional text tags are at the heart of “single sourcing integration” between Adobe RoboHelp (RH) and Adobe FrameMaker (FM), especially if you are using FM in the unstructured mode. Even though it is possible to create your source files in RH and then use RH10 or RH11’s many delivery formats including PDF and HTML, a…

Read More