Category Archives: Excel

Logo Production Secrets – Best Practices

Posted on by

In my last post, I covered some basics on logo production for use in Word, PowerPoint and Excel. This post will continue that topic with some trade secrets, tips and tricks to make logo production easier.

Let’s start at the beginning with the file that’s to be turned into a graphic. Is there a black element in the logo? If there is, you need to do some special handling. In most design programs, black is not necessarily black. Most artists, coming from a print production background, assume that applying C0 M0 Y0 K100 will give them black. If this was a logo you were actually printing, it would. But you’re not.

You’re going to translate this logo into RGB, which is the only color model used by Word, PowerPoint and Excel. (If you use Office on the Mac, the color picker makes it appear you are choosing other color models, but behind the scenes your choices are all translated to RGB.)

If you watch the color values in Illustrator, when you change C0 M0 Y0 K100 to RGB, you’ll see that you do not get black (R0 G0 B0). You get dark grey, something like  R35 G31 B32. Shake off that print mentality! The rule of thumb is: on all designs destined for Office, change all color values to RGB, preferably using the Pantone Color Bridge values.

Logo Production Trade Secret

The trade secret for this piece is a shortcut that will save you lots of time at the cost of some system setup. For most logos, we do not use the Illustrator file that is linked to the final art. Instead, we use a PDF of the final art, since the logo has been placed at its final size here. To get our logo file, we resize the PDF to get the total number of pixels we want, make a screen grab of the logo, then paste it into Photoshop.

Here’s the theory behind what we’re doing. The screen grab is at screen resolution, but our final file must be print resolution at 600 d.p.i. (For PowerPoint, we use 384 d.p.i., which is exactly 4 times the default Windows screen resolution. This displays beautifully and still prints well.) So we’re enlarging the PDF to get the number of pixels we need on the display. Then when the screen grab is pasted into Photoshop, we tell it that the resolution is 600 d.p.i. If our math is right, the final logo will be exactly the same physical size as the final design, but at a high resolution.

Here’s the system setup part. The calculations are a LOT easier if both your screen and Acrobat are set to 100d.p.i. If you’re using Windows, setting your screen to 100 d.p.i. means opening your Display control panel, clicking on the Setting tab and the Advanced button. On the General tab, change DPI setting to Custom setting and try 104%. On most systems, that will get you 100 d.p.i.

Non-Retina Macs should already be running at 100 d.p.i. Now open Acrobat and choose Edit>Preferences>Page Display. Under Resolution, choose Use system setting, which should say 100 pixels/inch. OK out.

You should be good to go. Open the design PDF with logo, set the zoom to 600% and choose the Edit>Take a Snapshot command. Draw a marquee around the logo. Here’s a cool tip: even if the logo does not fit on your monitor, drag the marquee over to the side of the window, forcing the graphic to scroll. Acrobat captures all parts of the selection even after it has scrolled off to the side! When you let go of the mouse, the screen will blink, indicating that the image is on the clipboard.

Now switch to PhotoShop. Choose File>New and the suggested size should match the area you just grabbed. Change the resolution to 600 d.p.i. Paste the logo.

Now crop it. Our practice is to do the initial crop leaving one pixel of background clear on the top and left sides of the image. This compensates for Word 2003’s propensity to display the logo on-screen looking like the top or left is “clipped”, even though it prints fine. Crop the right and bottom edge to contain the faintest shading of the logo and no more.

Cropping in Logo Production

Left: raw screen grab
Right: initial crop – 1 pixel top and left, no clearance right and bottom.

Minimal File Size with Precise Sizing in Office

Word, PowerPoint and Excel can only measure to 1/100″. So if your logo is big or small by a few thousandths, Word will resize it vertically or horizontally to make it fit. Your logo will be slightly distorted. So now we’re going to add back some of the background. In PhotoShop, choose Image>Canvas Size and change the units of measurement to inches. Round the numbers up to the next highest 1/100 of an inch, so 1.999 becomes 2.0, 12.742 becomes 12.75, etc. Set the canvas addition to flow to the right and bottom, as in this screen shot:

Canvas Size in Logo Production

Dimensions rounded up to next 1/100″, canvas set to increase right and bottom size.

Click on OK. In the Layers palette, choose Flatten Image. Now follow the steps from last week’s post: choose Image>Mode>Indexed Color, set Palette to Local (Adaptive), reduce the colors to 8 for each color in the original logo (so a 2-color logo will use 16 colors), set Forced and Dither to None, click on OK. Save as PNG for most uses.

There you have it, your first professional Office-ready logo file! It will look good and print sharp, it will be size-accurate and the file size is tiny. Congratulations!

March 2017 edit: This article is still relevant if you must use bitmap-format logos. Vector-based logos offer significant advantages, like not getting blurry when image compression is used on the file. Here’s the state of the art: Best Quality Logos for Office

JPEG Logos? Fail! – Best Practices

Posted on by

JPEG logos are the automatic choice for most artists when a client needs a wordmark in Office. It’s the worst possible format.

JPEG seems to be the all-purpose file format where the designer realizes they need to place an image with a smaller file size than a full-scale EPS or TIFF. The JPEG format is fine for photos and photo-like graphics, such as graduated tone areas. But it has 2 things going against it for flat color line art: lossy compression and the RGB color space.

The Disadvantages of JPEG Logos

Lossy compression renders flat color as a pixelated and sharpened hodge-podge where every pixel can be a different variation on the original color. You’ve all seen this on blowups of low-quality JPEGs where weird textures are introduced to areas that were formerly smoothly shaded. Lossy compression does reduce the size of the file, but at a visual cost. When you’re dealing with flat color, this visual cost is all too noticeable.

The other down-side to JPEG is the RGB color space. While admirably suited to photos, it’s simply not needed for line art logos. The RGB color space means thousands of color definitions are stored in the file, even for a logo that started as 1 color when it was a happy piece of vector art. This bloats the file size

The net result is a fuzzy, textured logo that is just too big. Then the client wonders why their letterhead template is over a megabyte before they type one word. Instead, let’s go back to first principles and figure out how to do this right.

The Alternative to JPEG Logos

The average logo starts life as an Illustrator file colored with one or two colors. How can we keep it as close to that original as possible?

Let’s start by throwing out the RGB color space. We don’t need millions of colors, we only need a few. Let’s use Indexed Color instead. With indexed color, only a few color definitions need to be stored in the file, so the file size goes way down. It goes down so much, that we can now increase the resolution of the image to get better sharpness.

Let’s go through it step by step. If you’re using Adobe products, it takes 2 steps to get to indexed color. First you have to export the logo from Illustrator as RGB, but to a file format that is not lossy, like TIFF. Then you open the RGB file in PhotoShop and reduce the image to indexed color.

Open a test logo in Illustrator. Start with a one-color version to make life simple. Now use the File>Export command with the following settings:

Save as type: TIFF
(Click on Save)

Color Model: RGB

Resolution: Other 600dpi

Anti-aliasing: Art Optimized (Supersampling) – assuming logo text has been converted to curves.

Check LZW Compression and click on OK

Now open the TIFF in Photoshop. Choose Image>Mode>Indexed Color and the following settings:

Palette: Local (Adaptive)

Colors: 8

Forced: None

Dither: None and click on OK

The format to save in depends on which version of Office your client is using (you did ask, didn’t you?). GIF format stores more compactly in Office 2003 and earlier. PNG has a smaller file size in Office 2007 and above. The difference is not huge and PNG has the advantage of remembering its resolution, so you could safely just stick with it if you’re not sure. GIFs always import into Office under the assumption that they are 72 d.p.i., which means your logo have to be reduced to the correct size after placing in Word or PowerPoint.

The Proof That JPEG Logos Suck

Are you skeptical that it’s worth the trouble? Here’s an enlargment of a typical artist’s result at left versus a Brandwares logo on the right:

JPEG Logos with RGB Color

Enlargement of a typical artist-supplied 300dpi RGB JPEG.

OK, it’s obvious the indexed color image looks way better. But the other benefit is that it’s also much a much smaller file size. Typically, the crappy-looking JPEG will be 8 (yes, eight) times larger! I know, file size may not matter to you, but it does to your client. They have to pay for storage for thousands of documents based on your template. The rule of thumb is: if your letterhead is bigger than 100kb, you’re doing something wrong. Ours range between 40kb and 90kb.

High-res Indexed Color, the alternative to JPEG Logos

Enlargement of a Brandwares 600dpi indexed color PNG.

It’s not a lot more work to give your client a superior product. Forget JPEG as a logo format, just use it for photos. Indexed color PNGs are the way to go for line art.

March 2017 edit: This article is still relevant if you must use bitmap-format logos. Vector-based logos offer significant advantages, like not getting blurry when image compression is used on the file. Here’s the state of the art: Best Quality Logos for Office

Brand Guidelines for Office – Part 2

Posted on by

In my last post, I covered speccing RGB colors for brand guidelines, colors that are becoming more important as we shift away from a print world. Today I’m going to talk about font specifications, an area that is also commonly misunderstood by designers.

The trend I see over and over is that designers will either specify fonts that are trendy, or fonts that are unusual. Useability seems to be way down on the list of font attributes in a designer’s mind.

Trendy Fonts: Curse of the Brand Guidelines

Examples of trendy fonts include Gotham at the moment, Frutiger for the last 10 years and before that Helvetica. Remember when everyone used Helvetica for everything? Thank god those days are over. Trendy fonts are both a stylish and safe choice. After all, if everyone else is using it, it must be hip and it must be good!

In reaction to the safe, stylish choices, some designers choose to be bold iconoclasts and spec fonts that are quirky or odd. These are designers who want to be remembered for their bold choices and their ability to define new directions.

But hmmm, what’s missing? Are we forgetting something? Oh right, the needs of the client!

As soon as you start to work directly with the client to implement guidelines in the real world, you immediately notice a number of drawbacks to the choices of fonts:

  • Most designer fonts are not embeddable in Microsoft Office. Word and PowerPoint only allow TrueType fonts to be embedded, but most fonts in use by designers are PostScript or OpenType.
  • Even when the fonts are embeddable, often the resulting document is not editable because paranoid type foundries have crippled the fonts.
  • Specifying a designer font for corporate documents means that the fonts would have to be purchased for all users in the company (a huge cost) and then installed on each desktop and laptop (a giant hassle for I.T.).
  • If the client emails documents to clients or partners for collaborative input, the designer fonts are silently substituted and the whole appearance of the document falls apart.

After we walk designers through the steps above, their usual decision is to spec designer fonts for printed pieces (an ever-shrinking piece of the brand pie) and Arial and Times New Roman for everything else! Well that certainly leaves the client looking anonymous! What was it they hired a designer for again?

This is so sad, but folks, it doesn’t have to be this way. It’s 15 years since the only choices were Arial or Times New Roman. Microsoft Office comes with a wealth of fonts that are installed with the software. Yes, some of these are crappy, there are are many gems in there too.

Brand Guidelines That Show Your Client Some Love

We’ve created a list of useful fonts that come with Microsoft Office. These are useable text fonts, we didn’t include display faces, script fonts or faces that only have one weight. Our list tells you which Office versions have which fonts. Our list gives you clickable previews of the whole font.

Microsoft Office useful fonts for brand guidelines

Part of our PDF showing useful fonts that are installed with Microsoft Office.
These are the best fonts to choose for user-filled text.
Contact us for the full PDF that shows full-font previews.

Drop me an email and I’ll send you the full PDF, updated for current versions.

Significant Advantages for Your Client

There are significant advantages to speccing these fonts:

  • They come free with Microsoft Office and are already installed on every computer. This saves your client a boatload of money and installation hassles.
  • Since these fonts are are most computers that have Word, collaboration is possible. Your client can email a document to their clients or partners without fonts being substituted. The document remains fully editable.
  • You can still achieve a distinctive brand identity for client documents with only a few moments research.

Desktop-generated documents are the vast majority of documents created by your client, dwarfing the few printed pieces they may create. It’s time to jump out of the print-oriented mindset and find ways to brand your client in every document from every source. Creative use of available fonts is one way to get there!

Brand Guidelines for Office – Part 1

Posted on by

Brand guidelines are an essential part of establishing worldwide graphic standards for any large company. When they are done right, they’re an effective way to propagate the corporation’s standards to remote markets. Unfortunately, when they contain errors, those errors are almost impossible to correct in a systematic way.

Brand guidelines are a top-down or hierarchical means of propagating the corporation’s brand. One design firm sets the standard, the standard is approved by head office and then distributed to subsidiary designers. There are two weak points in this structure that can lead to branding errors, if not disasters.

The first weak point is at the graphics company that creates the standard. Brand guidelines are a lot of work and many hands are required to meet the deadline. All too often, tasks that are deemed “less important” are farmed out to junior designers and approval of their work can be perfunctory under pressure. Even when senior people are working hands-on with specifications, their familiarity with all the end uses of the guidelines can be hazy or rooted in old practices that are no longer relevant.

Vulnerability number 2 is at the approval stage by the client business. This is a yawning chasm, because there is often a huge knowledge gap between the designer and the client. More often than not, the client looks over the pages, gets all impressed and loses any sense of critical analysis of the content. If there are errors in the document, they are unlikely to get caught here.

Brand Guidelines must include RGB

One of the ways that I discern expertise in a design company is by how they specify RGB equivalents for the colors in brand guidelines. As with many aspects of the design world, color specification had its roots in defining standards for print applications. The dominant model was and is the Pantone Matching System and it’s poor brother in process color, the CMYK equivalent. PMS and CMYK numbers have been the main modes of color specification in brand guidelines for decades.

RGB equivalents to Pantone specs are relative newcomers to the party. They’ve really only become commonplace in the last 10 years. RGB colours are vital to web and mobile applications, but they are also the native color model for Microsoft Office. Even Adobe Acrobat, when queried as to the color of an element, reports back in RGB. Let’s face it, the digital realm is RGB and the digital realm is the future. So let’s get it right!

Getting it right sounds easy, but there is no universally accepted equivalence between Pantone or CMYK and the RGB color models. It’s notoriously difficult to compare monitors with ink swatches. Each software vendor has come up with their own conversion tables. Adobe provides swatches for 10 different versions of Pantone colors. Between coated vs uncoated, process vs solid and color bridge vs solid to process EURO, its amazing anyone gets any colors picked at all! The RGB numbers that you get out of these models is all over the map. I’ve seen blues that were supposed to resemble the rich deep blue of PMS 286 that looked more like a robin’s egg!

The RGB in Brand Guidelines Can’t be Invented In-House

Even worse is the plucky designer (I’ve spoken to more than one!) who tries to make up their own RGB colours by invented new combinations on their monitor. They either forget, or have never learned, that Mac displays and Windows monitors show very different results, and that in the Windows world, color uniformity is only a theoretical dream. The colors you pick on your Mac monitor are guaranteed to look different on your client’s PC.

Needless to say, this is a hazardous way to pick colors for your client’s web site and office documents. I’ve seen it too many times: a Pantone 486 that looks like salmon on the web, a Pantone 116 that comes out lemon in Microsoft Word. This is not a brand identity, this is brand suicide!

If anyone is listening, I’d like to suggest a solution that has worked well for my company and my clients: the Pantone Color Bridge swatch books and Pantone Color Manager software. It’s not that I’m an avid fan of Pantone, but I have found that the RGB values are, on average, across platforms and displays, closer to the appearance of printed PMS colors. It’s also a simpler process than trying to choose from a multiplicity of software color models.

With the books, there’s one for coated colors and another for uncoated and you have the reference swatch right in front of you while working. With the Pantone Color Manager software, you have access to all 11,000 Pantone colors and their RGB equivalents for a very reasonable price.

If you have a branding color horror story, or a suggestion for a superior RGB conversion table, please feel free to comment. I’d love to hear from you!

Microsoft Blinks!

Posted on by

Microsoft has been trying to push customers to their Office 365 subscription service. But when this strategy backfires, Microsoft blinks!

The subscription scheme promises them a steadier cashflow. One of the ways they have been applying pressure to consumers is by maintaining the high price of Office but adding burdensome licensing provisions. The worst of these was the rule that you could only install Office 2013 on one computer and could not transfer that to a new machine. See my previous post on this subject.

Apparently abysmal sales figures for both Office 2013 and Windows 8 have prompted a rethink.

Microsoft Blinks!

The good news is, they’ve caved on two fronts:

  • They are lowering the pricing on Office 2013. OEM clients who bundle it on new machines will now get a Windows 8/Office 2013 bundle of 1/4 of the previous price. unfortunately, there are no price cuts on the retail version of Office.
  • Microsoft has also announced new licensing terms that allow transfer of Office 2013 to a new computer, as we have always been able to do with all other software. The amendment to the licensing agreement now reads:

Updated transferability provision to the Retail License Terms of the Software License Agreement for Microsoft Office 2013 Desktop Application Software:
Can I transfer the software to another computer or user? You may transfer the software to another computer that belongs to you, but not more than one time every 90 days (except due to hardware failure, in which case you may transfer sooner). If you transfer the software to another computer, that other computer becomes the “licensed computer.” You may also transfer the software (together with the license) to a computer owned by someone else if a) you are the first licensed user of the software and b) the new user agrees to the terms of this agreement before the transfer. Any time you transfer the software to a new computer, you must remove the software from the prior computer and you may not retain any copies.

The restriction remains in place that you can only install on one machine at a time, so you’ll still have to buy separate licenses for your desktop and laptop, but that is something we’ll have to live with.

The Most Expensive Office Version

Posted on by

At first glance, the new version of Microsoft Office appears to be pretty much a standard upgrade. List price $399 for Office Professional doesn’t sound like the most expensive office ever. That gets you Word, Excel, PowerPoint, Access, Outlook Publisher and OneNote. The list of new features is brief, including gems like:

• Show your style by using Word templates in more than 40 categories
• New functions in the math and trig, statistical, engineering, date and time, lookup and reference, logical, and text function categories
• Add your local weather forecast right there in Calendar view, along with current conditions

Not enough to motivate me personally to upgrade, but lots of people have to have the latest.

Expensive Office Licensing Restictions

Hold on, though, there’s a little note here:

• Office on 1 PC for business use

If that sounds unusual, it’s because it is. Most software allows you to install on 2 machines, like a desktop and a laptop, so you can use the software wherever you are. But wait, it gets worse! The fine print on the license agreement reads:

You may not transfer the software to another computer or user. You may transfer the software directly to a third party only as installed on the licensed computer, with the Certificate of Authenticity label and this agreement. Before the transfer, that party must agree that this agreement applies to the transfer and use of the software. You may not retain any copies.

In other words, your license lasts only as long as your computer! Microsoft attempted to soften their position recently by stating that “An exception is granted when the software is on a PC that is replaced under warranty.” Oh, I feel so much better! Now if I have a new PC and it dies, I can get Microsoft’s permission to reinstall!

If I’m installing on an older machine and the hard disk dies tomorrow, it’s back to the store to buy a new copy of Office!

In the document production business, we depend on having access to our software for as long as our clients are still using it. Sending a client a file developed on a later version is a sure way to lose a client. We still support Office 97, if a client needs it!

The only upside to this mess is that clients will be unable to continue using Office 2013 for as long as they have previous versions, because dying hardware will force them to upgrade. This is an obvious ploy to shift clients to their Office 365 subscription model, which will be much better for the Microsoft cashflow. But more about that mess in another post.

This is the most expensive Office suite Microsoft has ever produced. If you’re in corporate I.T., it’s time to think seriously about more reasonable alternatives like Apache OpenOffice, LibreOffice or Kingston Office Suite (We support them all!). If you’re in the template production business, you should consider stockpiling copies for future installs. And if you’re a serious programmer, get to work on the next great office suite! Now!

Best Practices

Posted on by

In the years I’ve spent creating great documents for companies, its become painfully obvious that the best practices are unknown to design professionals. Almost all of the files we receive as source material, whether they have been created by graphic artists or end user, are badly constructed and unreliable.

Best Practices are not about looks

I’m not talking about aesthetics. The documents created by artists are usually quite pretty. I’m talking about how well they are constructed. Most artist-created Office documents are like beautiful houses built on sub-standard foundations. It just takes a little tremor to make them crumble.

This is not the fault of the users or artists. There is no leadership from Microsoft or Adobe. There’s no awareness of this issue at educational institutions. There is some good information from the web community, but you have to seek it out and discern good from bad advice. This is why I have started this blog, to create a place for sharing proven best practices for document creation.

This will not be a hard and fast set of rules. There are always many ways to solve problems and I’m always discovering new creative solutions to seemingly intractable problems, both through my own work and by looking at the work of others. My guiding philosophy is to always picture the end user. What will make their life easier? How can I create a document that will be so easy to use and bullet-proof, it disappears? Disappears in the sense that it becomes a conduit for the user’s efforts instead of an impediment to their work.

I hope you will find this journal useful and informative. I hope it will let you work better. And I hope it will remind you to always look at your work from your clients or users point of view.