12 Excel Keyboard Shortcuts for Every User
Keyboard shortcuts are a great way to improve the speed at which documents are built, regardless of the application.  It seems like there is a keyboard shortcut for just about every feature Excel contains; and there may be that one guru in the office that knows...
QlikView – Limiting Record Loads with the FIRST Prefix
While developing a report, you may be loading thousands if not millions of records during the execution of your script.  If you are making edits to your script, and require a reload of the data to test your script changes, you may find yourself spending more...
QlikView – Export All Tables as QVD Files
Because QVD files load SO MUCH FASTER than the original data sources (i.e. Excel, Access, TXT, etc...), you may wish to save all of your tables to QVD files.  There are a couple compelling reasons to do this: You wish to develop your report in an...
Adobe Animate CC, Coming Soon to the Creative Cloud
From its creation at FutureWave to Macromedia to Adobe, Flash Professional has given us 20 years of animation and video for the web. The development of HTML5 and the proliferation of mobile devices has lead Adobe to retool the application to better serve our needs. No...
Paragraph Shading in Adobe InDesign CC 2015
Select only the paragraphs you want shaded. Having a background color for a paragraph in InDesign has always been possible. Just use the selection tool and set the fill color to the background color of your choice. If there were several paragraphs in the text frame,...
How To Arrange Windows Side-by-Side in Windows 7 and Above
https://youtu.be/1JZKsmZjDiU In this tutorial, you'll see how to arrange windows on the desktop side-by-side using the Windows snap feature. You'll also see how to split windows across your screen when using multiple monitors.
Auto-Size Text Frames in Adobe InDesign CC 2015
Eliminate overset text when editing content in InDesign. Your document is finished, your layout is perfect, and you get that last minute email or phone call telling you there are six copy changes that need to be made. We have all been in this position before....
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....