Excel Archives - Page 3 of 3

October 2012

The Perfectly Centred Heading In Excel

Wednesday, October 10th, 2012

Written by Jane Hames

In Excel you can centre values within a cell, merge cells and centre values within those cells, but my preferred option is the one that I often get asked about – Center Across Selection.

Changing a negative value into a positive value in Excel

Thursday, August 16th, 2012

Written by Jane Hames

I was doing some analysis on my banking this week (hmmm, not the most exciting job!) and decided to export the month’s transactions into Excel so that I could separate my incomings and outgoings more easily. The outgoings were displayed as negative values which is what I would expect. However, I wanted to be able to subtract my outgoings from my incomings to check the balance.

Autofill is creating a series and I just want to copy data!

Thursday, August 2nd, 2012

Written by Jane Hames

Many Excel users make use of the Autofill feature for copying formulas or entering days, months, dates or other things that form a series. There are occasions when users want Excel to ignore the fact that the value is part of a series so that rather than create the series, it just copies the value.

Should I use Clear, Delete or Delete in Excel?

Wednesday, July 18th, 2012

Written by Jane Hames

Yes, the title of this post does sound as though I’ve made a mistake! It is, however, entirely deliberate as I am going to explain the difference between Delete on the keyboard, the Delete command on the ribbon and Clear in Excel.

How-To Guide: Reduce document size by compressing pictures

Thursday, May 10th, 2012

Written by Jane Hames

Do you insert pictures into Word Documents, PowerPoint Presentations (or even Excel Workbooks)? Do you need to email those documents? If so, it is worth learning how to use the very simple Compress Pictures feature which will reduce the file size. It only takes a minute and works a treat!

Excel How-To Guide: Sorting (without messing up your data!)

Thursday, May 3rd, 2012

Written by Jane Hames

OK, hands up who thought they knew how to sort a list in Excel and then totally messed up their data? My hand is up! I ask my workshop participants that question and I can’t think of an occasion when no-one has admitted to making the same mistake. Many of Excel’s most useful features are not obvious. Below are some hints for sorting data in Excel:

Excel How-To Guide: PivotTable Slicers

Sunday, April 22nd, 2012

Written by Jane Hames

PivotTables are one of Excel’s most powerful tools, designed to make data analysis quick & easy. This How-To Guide is aimed at those who already use PivotTables and want to learn some new techniques.

Quick & easy tips to gain you more time & greater control

Tuesday, April 3rd, 2012

Written by Jane Hames

I am a great believer in being as efficient as possible when using Microsoft Office and Windows to maximise the time I have to spend doing other things. In case you missed Glide Training’s Microsoft Office tips on twitter, here they are again to help you to become quicker and more efficient.