News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
[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…
[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…
Microsoft Access – Master IF Queries in 2 Minutes
This article assumes a knowledge of the standard use of the Criteria row in a Microsoft Access Query and the Operators, for example, =, <>, Like, IS that can commonly be used there (see Appendix – Operators at the end…
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…
How to add a Translator in PowerPoint
Whether you speak a different language and you want to be able to translate a word in a presentation or you just something to give you the definition of a word. There is a handy tool that will do this…