header subtotal

Using Subtotal to create paging for grouped data

A feature of the Subtotal TOOL is the ability to also group your data into a form ready for printing. For example, let’s say you have a lot of records that you want to separate by one of the fields in the records.

Using cell comments in Excel (4)

Office Tips & Tricks: Adding a video to a Sway


If you’ve already explored Microsoft Sway, you’ll know that this digital storytelling package loves visuals. You can add images, but did you know it’s also easy to add video too?
From the Cards pane, just select a Video card.

Digital Framework

Have a go at assessing your digital competencies online


You may already know that at the beginning of this term we have launched the NTU Digital Framework learning room in NOW:

to support staff in their development of digital competencies and
to provide guidance on the Framework for those involve

Using cell comments in Excel (5)

Office Tips & Tricks: Split Excel data into 2 columns


Working with an Excel column of full names, but wishing you’d set this up as two separate columns? Luckily there’s an Excel trick to help you do this.

excel tips transpose2

Transpose: creating vertical data from horizontal data (& vice versa)

- can be used to convert your current vertically formatted data into horizontally formatted data and vice versa. In this example we see the ‘horizontal’ data transposed to a ‘vertical’ format.

Using cell comments in Excel (23)

Office Tips & Tricks: Get organised with Planner

| | 1 comment

What is Planner?
Planner allows you to create an electronic Board (1) where you can add Buckets (2) and pin electronic cards (3) to your lists.

Using cell comments in Excel

Office Tips & Tricks: Convert handwritten equations to text in Excel 2016


If you’ve upgraded to Office 2016 and are lucky enough to have a touchscreen laptop or tablet you can now handwrite equations which are then converted to typed text.

Using cell comments in Excel (1)

Office Tips & Tricks: Create a Microsoft Form


Microsoft Forms is a program within Office 365 (Education) that enables you to create custom quizzes, surveys and questionnaires. You can then invite others to respond (using any browser and using mobile devices).

adobe acrobat v1

Adobe FORMS: create an interactive PDF form for submission

Amongst the advantages of the PDF format is the ability to exist as individual files that can be printed and sent as email attachments. With Adobe Acrobat DC you can now edit PDF files and include interactive elements that can capture user responses.

excel tips 3

COUNTIF: a powerful filtering function

Excel has a great filtering ability which allows you to filter down by multiple criteria .

Page 4 of 28« First...23456...1020...Last »