News & Tips

Using A Data Table To Create A Pivot Table [Quick & Easy!]

Have you ever considered turning your list into a Data Table? From this, you can easily create a Pivot Table. A Pivot Table is a table of values which are aggregations of groups of individual values, much like a…

VLookup vs IndexMatch – What To Use?

VLookup is used to look up information in a list and extract the data into another list. It can also be used for matching; is the value I have in one list, also in another? The benefit of using Index…

[Master Guide] Excel Cell References

Cell References tell your formula how it works. Using the right kind will let you copy your formulas across your data. All while keeping them working as intended We also teach this on our Microsoft Excel courses, as it’s…

Formulas And Functions In Excel [Getting Started!]

Formulas and Functions are some of Excels most powerful tools. They allow the user to make complex and insightful spreadsheets. Understanding Formulas In Excel An Excel formula is an expression that returns a result. They save you time and effort.…

[How To Use] Adobe InDesign Spell Check

InDesign spell check works differently from the other spell checkers. InDesign is primarily a publishing tool. InDesign assumes that by the time text hits it, the text has been proofread and that it won’t contain misspelt words. Of course, this…

Temporary Tables In MS SQL

There are four types of tables in MS SQL: Permanent: Normal tables you create and save #Local Temporary: Short term tables, only used in that procedure for that user ##Global Temporary: Short term tables available to all…

A Complete Guide To Page Numbering In InDesign

Page numbers help your reader and add a professional finish to your documents. InDesign makes numbering documents incredibly easy so you’ve no excuse for not using them! In this article, you’ll learn how to use InDesign to : Adding Page…

[Complete Guide] Page Numbering In InDesign

Master pages are a huge time saver in InDesign. They’re a great ‘one and done’ solution to make sure that all of your content is consistently formatted. If you are an InDesign beginner, learning to use master pages should be…

Adobe Fonts: Creating Your Own Glyphs

This is part 2 of a 4 part series. For the other parts see here: Part1, Part3, Part4. As before to follow this tutorial you will require: FontSelf Extension for Photoshop and/or Illustrator. Creating Glyph Alternates Open Photoshop and…

10 Tips For First Time Managers – Infographic

If you are looking to bolster your ability to lead a team at work or are a first time manager, this infographic is for you! Becoming a manager is tricky. There are lots of new skills to learn. Some…

Adobe Photoshop: How to Create An Image Using A Displacement Technique

This Photoshop tutorial will show you how to create an image with a displacement technique. You will see this commonly used for movie posters and media like that. Our Photoshop courses cover the techniques covered in this article if you…

InDesign: Entering A Column Break Instruction

First place the text cursor at the point where you wish to insert a column break. On the numeric keypad, press the Enter key. On a laptop, press and hold the blue Fn key while pressing Return. For more quick…