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…
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 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…
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…
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 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…
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…
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…
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…
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…
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…
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…
