Posts tagged "Excel"

Excel


Unmerge and fill

Office Tips & Tricks: Unmerge and Fill Cells in Excel

| | 4 comments

 
I’ve recently discovered a great time saving trick in Excel so wanted to share it with you.
 
So I have spreadsheet with lots of merged cells.

Using cell comments in Excel (12)

Lynda.com sharing Playlists

| | 0 comments

In our last Lynda.com themed post, we talked about using Playlists to curate meaningful content.

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

Office Tips & Tricks: Split Excel data into 2 columns

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

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.

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

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

| | 0 comments

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

| | 3 comments

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

| | 0 comments

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

| | 0 comments

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.

Page 1 of 3123