News & Tips
How to Insert slides from another Presentation in PowerPoint
You may have slides in other presentations that you would like to use. In PowerPoint, there is a tool called Reuse slides that we can learn to reuse slides from another PowerPoint presentation. This makes combining presentations that you’ve previously…
4 Different ways to Print your PowerPoint Presentation
When creating a PowerPoint presentation it can be tempting to just select print slides and get your hands on a real copy of your work. However, PowerPoint printing has several different layouts and settings for printing presentations. This guide will…
Using The Gradient Mesh Tool In Adobe Illustrator
Adobe Illustrator is full of handy tools to make sophisticated and detailed art. Learning how and when to use them will help you to reach your artistic or graphic design goals. The Gradient Mesh Tool in Adobe Illustrator is one…
Backup Types & Strategies For SQL Databases
Backup and Restore are critical concepts to understand when working with databases in SQL and SQL Server. Whether you are new to SQL and/or SQL Server or an experienced database analyst, you never know when a disaster might occur. It…
Microsoft Outlook: Folders, Sub-Folders and Automatic Forwarding
Folders in Outlook are a great feature to help you organize your workflow. EMail services can often get messy with so many different types of emails coming in to one account. If proper care isn’t taken, you can even be…
All About Pivot Tables – Excel Guide
For those of you who know how to create a Pivot Table, have you ever considered turning your list into a Data Table? From this you can then start creating a Pivot Table. This would be beneficial if your data…
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…
Excel Font Formatting
Font formatting makes your Excel Spreadsheet stand out. This is often an underappreciated part of making spreadsheets. But visual design is key to engaging people! This skill is extremely important for hooking people in to your work. We also cover…
[Master Guide] Excel Cell References
Learning about Relative, Absolute and Mixed Cell References is imperative to being a skilled Excel user. This will save you a great amount of time. If you want to like this guide and want to learn more about the fundamentals…
Excel Formulas and Functions
Formulas and Functions are some of Excels most powerful tools. They allow the user to make complex and useful spreadsheets. This article shows you how to use both Formulas and Functions in Excel, as well as take you through some…
Microsoft Excel: How To Name A Worksheet
In Excel, there are a few different methods to rename worksheets. This guide will take you through each of them, so you can find whichever approach suits you best. When working in an Excel workbook with multiple worksheets, it is…
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…