header pivots

Extending pivot tables with Conditional Formatting

Because pivot tables exist as values in cells once you have created them you can then apply conditional formatting to their results to further clarify their summaries for your viewers.

Using cell comments in Excel (2)

Office Tips & Tricks: 5 ways to use Yammer


Interested in using Yammer but not sure where to start?
Here are five ideas to get you started using Yammer whether it’s for learning, teaching or assessment, within a group or as an individual user:

Ask for feedback: Tell people what you̵

Using cell comments in Excel (6)

Office Tips & Tricks: Ctrl G in Outlook Calendar


This week, we visited colleagues at our Brackenhurst campus to share some tips for using Outlook more efficiently.
We showed them various nifty Outlook tips including Quick Steps and Clutter.

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.

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