How to Subtract Dates in Microsoft Excel using DATEDIF
https://youtu.be/Qg6sDPqke0g In this tutorial, you'll see how to subtract two dates from one another in Microsoft Excel using the DATEDIF function. The DATEDIF function allows you to calculate the difference between two dates and return a variety of values, including days, weeks, months or years. Learn...
How to Create a Crystal Report using Microsoft Excel Data
https://youtu.be/5a3j9-nvDf0 In this tutorial, you'll see how to create a report in Crystal Reports using data from an excel worksheet. This video will demonstrate the different methods for connecting to Microsoft Excel data from Crystal Reports and covers using both Excel 2003 and prior as well...
Creating Fractions, Adobe Photoshop CC 2015.1
Photoshop’s Glyphs Panel can create custom fractions. In a previous post we talked about the newly added Glyphs Panel to Adobe Photoshop CC 2015.1. Now let us take a look at using fractions from this panel. Most fonts will supply a few fraction glyphs like our...
Glyphs Panel, Adobe Photoshop CC 2015
A Glyphs Panel has been added to Photoshop Those of you that use Illustrator or InDesign have had access to this panel for some time now. But, Photoshop for some reason has taken it’s time in making it available. Well, it’s finally here! The June 2015...
Change the Open File Workspace, Adobe Photoshop CC 2015.1
Show Recent Files Workspace When Opening a File. Some of the most recent changes we have seen in Photoshop CC 2015 began with the code name Spectrum. This name describes changes to the applications involving the darkened user interface. We introduced the new Start Workspace in...
Quick Export, Adobe Photoshop CC 2015.1
Export artboards, or layers using Quick Export Photoshop has offered numerous file options for saving an image over the years. Selecting File > Save As from the menu currently offers over 20 different file formats. Frequently there is the need to save images for publishing online....
Adobe InDesign CC 2015.2; Start Workspace
Start and Recent files workspace After installing the November update to InDesign CC 2015 the first thing (actually the second, because the first is the new splash screen) you will notice is a new default workspace. The new Start workspace provides access to recent files, libraries,...
QlikView – Dynamic Chart Titles
It’s every chart maker’s dream to have dynamically changing titles (well, that and a coffee table that looks like a giant floppy disk.  Seriously; Google that one if you haven’t seen it.  It’s pretty cool.)  Any-hoo…  To have a chart’s title change based on data you...
Adobe InDesign CC 2015.1; What’s New
InDesign Makes Working with Glyphs Easier First things first, what exactly is a glyph? In the world of typography a font is a set of characters, numbers, and punctuation that comprise a family to be used together. A glyph, on the other hand, is a single...
Crystal Reports – Missing Template Preview
When applying a template to a report, it’s often preferred to “peek” inside the template to see what it has to offer prior to applying it to your report; to “take it for a test drive”, as it were. If you have a vast template library,...
Crystal Reports – Importing Values and Descriptions into Parameters
If you are creating a list of choices for a parameter drop-down list, you can acquire the choices from several sources: Manually enter the choices in the list (static and least exciting of all of the options) Append a unique list of choices derived from a...
QlikView – Scheduled Update of QlikView Reports
Suppose you want your QlikView report to automatically reload its data based on a schedule.  The manual process would be for you to open the report, click the RELOAD button, and then close the file.  If you team up the QlikView report with the Windows Scheduler,...
Adobe Photoshop CC 2015.1; What’s New Pt. 3
Part 3: Font Filtering and Searching With each new version of Photoshop working with fonts continues to improve. The addition of Typekit and filtering font names as you type have both been great additions. With the latest update, November 2015, a few more choices emerge. i....
Crystal Reports Multi-Pass Processing Engine
Crystal Reports uses a three-pass reporting method to generate reports.  A pass is a process that Crystal Reports uses each time the data is read and manipulated.  Depending on the complexity of the report Crystal Reports may make 1, 2, or 3 passes over the data....
Adobe Photoshop CC 2015.1; What’s New Part 2
Part 2: Customizable Toolbar   The toolbar has been a part of Photoshop dating all the way back to version 1.0, released for the Mac in 1990. It has gone through a variety of changes over the past 25 years, most of them involving arrangement of...
QlikView  – Popular Hotkeys / Shortcuts List
Script Editor <F5> or <Ctrl> + R Runs load script <CTRL> + <Shift> + R Partial reload <Ctrl> + T Shows model diagram <Ctrl> + E Opens table editor for LOAD INLINE statements (cursor should be placed inside statement) <Ctrl> + Q + Q Inserts script...
Crystal Reports – Adding a Watermark to a Report
If you have ever looked for the watermark feature in Crystal Reports, you no doubt walked away smothered in soul-crushing despair wondering how Life could be so cruel. True, there is no official tool in Crystal Reports that adds a watermark to a report, but that...
Adobe Photoshop CC 2015.1 What’s New
Part 1: Start and Recent Files Workspace After installing the November release update to Photoshop CC 2015 the first thing (actually the second, cause the first is the new splash screen) you will notice is a new default workspace. The new Start workspace provides access to...
Excel – Conditional Formatting with Subtotals
If there has ever been a more “You’ve got your chocolate in my peanut butter!” moment, it’s the blending of Conditional Formatting with the Subtotals tool in Excel. If you have ever used the Subtotals tool to group information you have probable been impressed with its...
QlikView – Mandatory Include Statement to Prevent Data Inconsistencies
The goal of every QlikView developer is to do as little work as possible.  When you notice that you are writing the same instructions in multiple app scripts, the notion of re-use is a red flag that flies with great fervor.  QlikView’s Include statement provide just...