Posts tagged "Excel"


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 (17)

Office Tips & Tricks: Alt key tips (all Office programs)


If you prefer to use keyboard shortcuts instead of the mouse, then this handy tip is for you.
Did you know, if you press the Alt key, letters appear over every item on the ribbon?  Just tap the relevant key to activate that option.

Using cell comments in Excel (15)

Office Tips & Tricks: Sparklines (mini charts) in Excel


If you like to represent your Excel data visually, you might be interested in using sparklines.
So what is a sparkline?
A sparkline is a mini-chart which is displayed within a single worksheet cell of your choice.

Using cell comments in Excel (14)

Office Tips & Tricks: 2016 Round-Up


It’s almost the end of another year full of ups and downs. 2016 will certainly be remembered as a year of major worldwide events.

Using cell comments in Excel (7)

Office Tips & Tricks: Remove Duplicates in Excel


A common problem when working with Excel spreadsheets is duplicate data.  If your spreadsheet contains duplicate entries you’ll probably want to clean it up so it doesn’t impact on calculations, tables etc.

copy and paste visible cells in excel

Office Tips & Tricks: Excel – copy & paste only visible cells


Working with Excel spreadsheets containing hidden rows or columns?
Recently we had a query from our colleague, Trevor, who has a spreadsheet with hidden rows and columns and wanted to copy and paste only visible cells onto a new worksheet.

Using cell comments in Excel

Office Tips & Tricks: Using cell comments in Excel


Did you know that there’s an easy way to make Excel data more meaningful? Adding cell comments means you can provide the spreadsheet user with additional information.

Rules (12)

Office Tips & Tricks: Validate Excel data to make drop down menus


Do you create spreadsheets for other people to use? Did you know it’s really easy to create a drop-down menu of selections to choose in particular cells?
To create drop down menu selections:

Highlight the cell, go to the Data tab, and cli

Rules (7)

Office Tips & Tricks: 2015 Round-up


It’s almost the end of another year… The perfect opportunity to review the Microsoft Office Tips & Tricks we’ve shared with you during 2015. So grab a cup of tea and mince pie and take a few minutes to read our round-up.


Office Tips & Tricks: Creating easy charts and diagrams with SmartArt


Having trouble creating diagrams and models in your Microsoft Office documents?
Then SmartArt could be just what you need to help you create professional looking graphics to grab your audience’s attention.

Page 1 of 3123