News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
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…
How To Backup Your SQL Databases Today!
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…
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…
Master Excel Font Formatting In Just 2 Minutes
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! Changing The Excel Font When you want to format text in Excel, you can see…
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…
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…
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…