Category Archives: Excel

Excel Formulas, Getting Started with Calculations

Posted on November 17, 2013 by garysch

There are many things that Excel can do but fundamentally it is used for doing calculations. These can be simple or complex. I’ve done quite a few on functions and also some that use multiple functions but I needed to … Continue reading →

Posted in Excel, Office 2010 | Tagged , , , , , | 6 Comments

How to Do Headers and Footers in Excel 2010 and 2013

Posted on October 12, 2013 by garysch

Headers and footers in Excel 2010 and 2013 are a bit different to how you get to them in say Excel 2003. Here in this video is how you can use them.

Posted in Excel | Tagged , | Leave a comment

How to Get Multiple Lines in an Excel Cell

Posted on October 10, 2013 by garysch

This is a common request in Excel, how do you have more than one line in a cell? All you need to do it turn word wrap on. In the video below you can see how to do it.

Posted in Excel | Tagged , , , , | 1 Comment

Recording Macros in Excel to Make Tasks Easier

Posted on September 8, 2013 by garysch

Excel is a great program and it is even better when you get it to do repetitive or complex tasks at a click of a button. You’ve thinking but how is that possible when everyone has different requirements and tasks … Continue reading →

Posted in Excel, Office 2010 | Tagged , , | 1 Comment

Excel: 3D Formulas

Posted on April 4, 2013 by garysch

If you have been creating formulas in Excel then you may have been wondering about what to do if you have a formula that needs to used values from different worksheets or workbooks. This is known as a 3D formula. … Continue reading →

Posted in Excel | Leave a comment

Excel: Formula Auditing

Posted on April 2, 2013 by garysch

Excel worksheets can be full of formulas and functions and in many instances you did not create them and are trying to decipher how a formula was created. It might also be that you created it some time ago and … Continue reading →

Posted in Excel | 1 Comment

Filtering Data in Excel Using Autofilter

Posted on December 14, 2012 by garysch

We all know Excel is great for doing calculations but it is also handy for managing lists of data which means being able to filter information to find what you are looking for. When Excel 2007 came out there were … Continue reading →

Posted in Excel | Tagged , , , | 1 Comment

Excel Tip: Freeze Panes and Split Windows

Posted on December 14, 2012 by garysch

If you have large worksheets when you scroll from side to side and up and down you cannot see what is in the top row and first column. Thankfully Excel has a couple of features to help sort this out. … Continue reading →

Posted in Excel | Tagged , , , , | 1 Comment

Compare Data in Excel Lists

Posted on December 2, 2012 by garysch

This is one of those things I get asked about on a regular basis. It is when someone has two lists and they need to check that they have the same data. It could be an old list that needs … Continue reading →

Posted in Excel | Tagged , , , , , | Leave a comment

Excel 2010: Conditional Formatting

Posted on October 29, 2012 by garysch

Conditional formatting allows you to automatically get Excel to change the appearance of some cells based on their values. This is particularly useful if you need something to stand out so that as you scan the worksheet you are quickly … Continue reading →

Posted in Excel, Office 2010 | Tagged , , , | Leave a comment