Articles written by: Alice Antonsen

Aug 29, 2020

Predict your data with Excel Forecasting

Predict your data’s future using a Forecast Sheet  (Excel 2016 – Subscription Version) Did you know that you can easily create a forecast when [...]

Aug 22, 2020

InDesign CC Presets

InDesign CC Presets Graphic Design is all about getting the best end result from your project. Often in industry we do repetitive work; annual reports, newsletters, [...]

Jun 27, 2020

How does a Creative Cloud Library help in InDesign?

A Creative Cloud Library is a collection of design assets. Several types of design assets can be added to a Creative Cloud Library. Adobe Creative Cloud Libraries allow [...]

May 18, 2021

Get Creative with Adobe Stock Templates!

Do you ever want to create an edgy design but just don't know where to start? You never have to start with a blank page again! Designing from scratch is made much [...]

Apr 04, 2021

Reuse and Share InDesign Presets

Adobe InDesign has many customisation options within the application; such as the ability to create and save workspaces that preserve the arrangement of panels onscreen, [...]

Feb 15, 2021

How-to: Use clipping masks for typography

Step One: Create a new document in Photoshop. If your document is going to be used on the web, I recommend setting the resolution to “72 pixels/centimeter”. [...]

Jan 25, 2021

Photoshop: Using clipping masks for custom photo layouts

In today's blog, I'll be teaching you how to make a custom photo layout in Photoshop. We will go though how to make a grid with four square images, but you [...]

Dec 14, 2020

Understanding layers in Photoshop

What are layers and why should we use them in Photoshop? You will have more control. They do not destroy your original photo. You are working on top of or on [...]

Nov 17, 2020

InDesign CC multiple page size documents

Adobe InDesign is a remarkable tool for many print and marketing design projects. What happens if your project requires different size pages for each item you design [...]

Nov 08, 2020

Why do I need to run a Preflight in InDesign?

It’s frightening how many errors can become very obvious on a printed document, compared to just reviewing it when it’s up on screen. But unfortunately there is no [...]

Nov 01, 2020

Dreamweaver CC - Pop up thumbnails of image and colour filenames

I always try to give the images I use in my web pages relevant names if I can. Realistically, who can possibly remember what DSC00012.jpg is? But now Dreamweaver will [...]

Oct 21, 2020

Define and solve a problem by using Excel Solver

Solver is a Microsoft Excel add-in program you can use for What-If Analysis. You can use Solver to determine the maximum or minimum value of one cell by changing other [...]

Oct 11, 2020

Microsoft Project 2013 & 2016: Levelling Gantt

Microsoft Project 2013 & 2016 allow you to use the Leveling Gantt to show the visual impact of the leveling of resources across your project. Level Resource [...]

Sep 26, 2020

How-to: Put SharePoint calendars into Outlook

A SharePoint calendar is a convenient way for all members to add, update and maintain a single record of dates. If you have a team with deadlines, deliverable due dates [...]

Sep 06, 2020

What you did not know about the Excel SUMPRODUCT function

SUMPRODUCT is about more than sums and products. This is what Excel's Insert Function feature says of SUMPRODUCT: 'Returns the sum of the products of [...]

Aug 02, 2020

Easy customisations in Word 2013

Whatever your preferences may be, Word 2013 allows you to modify some basic settings to work the way you would like it to. Here are a couple of easy customisations you [...]

Jul 19, 2020

How-To series: Password protect sections in OneNote 2013

If you have any private or confidential information inside a particular section, then you can also password protect it to ensure only the person with a password may open [...]

Jun 30, 2020

View Types in SharePoint

There aren’t a lot of different view types, but you can create many views with each of the different types available. You can also create custom views with SharePoint [...]

Jun 03, 2021

Finding just the working days in Excel

If you need to generate a dynamic series of dates that are workdays only (i.e. Monday through Friday), you can do so with a simple formula that uses the WORKDAY function [...]

May 23, 2021

InDesign CC - Colour Theme Tool

Adobe snuck a cool feature into InDesign CC back in 2014 called the Colour Theme tool. You just select the tool in the Tool panel (it's just above the Hand tool), [...]

May 17, 2021

InDesign CC - Creative Cloud Libraries

What is a Creative Cloud Library? A Creative Cloud Library is a collection of design assets. Several types of design assets can be added to a Creative Cloud Library. [...]

May 09, 2021

Using the right black in InDesign

Black is just black, right? When it comes to working with black in InDesign, there are a few things that you should keep in mind. There seems to be some confusion [...]

Apr 19, 2021

Ten Tips for Using Microsoft Project

Using Project can be tricky at times. Here are 10 of the tricks and hidden functions can save time and effort for users. 1. When a start date is changed, the [...]

Mar 03, 2021

How-To Series: Photoshop CC Intelligent Upsampling

Scaling up low resolution images is now simple with intelligent upsampling If you been ever had a low resolution image, or an image that was very small, that needed [...]

Feb 25, 2021

InDesign - Data Import Feature

I am often asked how to format an Excel table in InDesign as many of us frequently work with Excel tables given to us by clients. The one I run into most often is the [...]

Dec 16, 2020

Word 2013 easy customisations

Word-2013-easy-customisations Word 2013 comes with many pre-decided features, however, customising them is not as hard as you might think! Remove the Start [...]

Nov 16, 2020

The Quick Brown Fox...

To insert sample text in Word 2007, 2010 or 2013, use one of the following methods. Method 1: Use rand() You can control how many paragraphs and lines appear by [...]

Oct 22, 2020

Absolute Cell References use in Formulas

Definition: In Excel, an absolute cell reference, like other cell references, identifies the location a cell or group of cells and are used in such things as [...]

Aug 18, 2020

Create a Custom Tracking View in Project 2013

By creating custom tables and views, you’ll import the same data and still be able to switch back to the delivered Gantt chart and standard tables. If you don’t create a [...]

Jul 27, 2020

Unlinking A Pivot Table From Its Source Data

You may have a situation in which you need to send someone a pivot table summary report, but you don't want to include the original data. In other words, you want to [...]

Jul 09, 2020

Using conditional formatting to highlight weekend dates in Excel

When you design an automated calendar in Microsoft Excel, you don’t need to colour the weekends yourself. With the conditional formatting tool, you can automatically [...]

Jun 11, 2020

Customising the Project 2013 interface

First time users to Microsoft Project often ask me how to do an initial customisation of the Microsoft Project 2013 interface so I have created these four simple steps [...]

Jun 01, 2021

Troubleshooting an upgrade to Exchange Server 2013

So you are thinking of upgrading your existing Exchange Server 2010 to the all new and improved Exchange Server 2013, and you are wondering about those lovely pitfalls [...]

May 28, 2021

PivotTable timelines in Excel 2013

Timelines are a new feature in Excel 2013. A timeline lets you filter records in a PivotTable - it works similar to a slicer, but you'll filter by dates. Once you [...]

May 08, 2021

Round, RoundUp and RoundDown in Excel

This article explains the three functions to round numbers in Excel - the ROUND, ROUNDUP and ROUNDDOWN function. Note: Before your start, if you round a number, you [...]

Apr 17, 2021

Create a SharePoint list based on an Excel spreadsheet

You can create a list in Microsoft SharePoint by importing an Excel spreadsheet file, if your data is already in a spreadsheet format. When you create a list from a [...]

Apr 07, 2021

Copy visible cells only in Excel

I am often asked why it is that sometimes when you copy and paste a filtered or subtotaled range of cells in Microsoft Excel, they expand and paste even the hidden [...]

Mar 19, 2021

Customise quiet hours with Windows 8.1

Do you ever wish you could turn off your Windows and Office notifications for a little while, just so you could get some work done without interruptions? Perhaps you are [...]

Feb 03, 2021

Reverse engineering a nested formula in Excel

Sometimes, understanding how a nested formula in Microsoft Excel calculates the final result is difficult because there are several intermediate calculations and logical [...]

Nov 28, 2020

Scheduling Rostered Days Off (RDO) in Project 2013

I am often asked how to schedule non-working time for resources in Project 2013 who have a nine day fortnight so I have put together this little set of instructions. It [...]

Nov 18, 2020

Using SharePoint to create a 'Team Based Master Calendar'

Your team can now have a master calendar that can overlay up to 10 calendars over one another to create a calendar that the whole team can view, and each calendar is [...]

Sep 18, 2020

Action buttons and hyperlinks in PowerPoint

Microsoft PowerPoint makes it easy for users to navigate within their presentations or link objects and shapes to files, programs or videos. The two easiest ways of [...]

Aug 28, 2020

5 steps to create a custom field in Microsoft Project

Microsoft Project 2010 and 2013 allows end users to customise their application views by creating custom fields. Not every industry has the same type of information [...]

Jul 18, 2020

10 essential keyboard shortcuts in Photoshop

Keyboard shortcuts greatly enhance your speed and productivity in any application. They are especially beneficial in Photoshop. Here are just a few that will make your [...]

Jun 12, 2020

Pinpoint your 3D chart's data points with drop lines in Excel

One of the frustrating things I find about Microsoft Excel, particularly when you're producing a chart, is the huge quantity of formatting options that are available. [...]

Apr 14, 2021

'Revise Contents' – Outlook's hidden gem

Have you ever wanted to highlight information or make notes in a received email? Or make the email contents easier to recognise or find in the future? Or perhaps even [...]

Feb 17, 2021

Time saving tips in Microsoft Outlook

Microsoft Outlook is probably the most widely utilised Microsoft Application in the world and in my opinion, it is also the application that should have the most [...]

Feb 07, 2021

Create and lookup custom fields in Microsoft Project

Microsoft Project allows end users to customise their application views by creating custom fields. Not every company or industry has the same type of information [...]

top
Back to top