Online Video Courses

How to Display the Contents Tab (TOC) in a Compiled Robohelp HTML Help File

By Ugur Akinci | April 4, 2013

Follow the directions in this post to display the Contents Tab (TOC) in a compiled Robohelp HTML Help File. If you compile a Robohelp .CHM (pronounced “chum”) HTML help file and do NOT see your CONTENTS tab (TOC) anywhere, don’t panic. There is actually a very simple reason why the CONTENTS tab does not display: you have…

Read More

How to Find the Workday a Specific Number of Days Before of After a “Start Date” in MS Excel by using WORKDAY.INTL Function

By Ugur Akinci | April 3, 2013

Let’s say you have a reference START DATE like “February 2, 2005″. You would like to calculate the exact WORKDAY 100 days BEFORE or AFTER that date. How would you do it? What’s more, how would you do it if the “weekend” definition varied, like “Sunday only” or “Saturday and Sunday”, or even just “Monday”?…

Read More

How to Add Running Headers or Footers to a MS Word Technical Document

By Ugur Akinci | April 2, 2013

© Ugur Akinci You can add running headers (also called “running headings”) or running footers to a MS Word technical document so that the text of the selected heading style is automatically printed as a “header” or “footer” either at the top or bottom of every page. Such running headers are useful in identifying the section or chapter that…

Read More

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

By Ugur Akinci | March 29, 2013

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 to produce each item. The number of raw material units you need to produce each item. The unit price, unit cost,…

Read More