Digital FrameworkUsing cell comments in Excel (5)excel tips transpose2Using cell comments in Excel (23)Using cell comments in Excel

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...
Read more >>
| 0

Office Tips & Tricks: Split text into different columns in…

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...
Read more >>
| 0

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

Transposing - 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...
Read more >>
| 0

Office Tips & Tricks: Get organised with Planner

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.   The Board is essentially your...
Read more >>
| 1

Office Tips & Tricks: Convert handwritten equations to text in…

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...
Read more >>
| 2
Digital Framework

Have a go at assessing your digital competencies online

| | 0 comments

 
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 text into different columns in Excel

| | 0 comments

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)

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

| | 2 comments

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

| | 2 comments

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 .

Using cell comments in Excel (19)

Office Tips & Tricks: Create a group in Yammer

| | 0 comments

Yammer is a private social network that helps you network with others within your organisation, share information across teams, and organise projects or working groups.

Using cell comments in Excel (18)

Office Tips & Tricks: Create a Sway using a topic

| | 0 comments

If you’re an Office 365 user, you may have noticed Microsoft Sway.
 
What is Sway?
Sway is a digital storytelling program/app useful for creating visual and interactive reports, presentations and stories.

Page 1 of 2512345...1020...Last »