Tag Archives: excel

How to Enter a Series of Dates in Excel That Are Only Weekdays

Posted on August 21, 2016 by garysch

Do you have to enter data for a bunch of dates but only need weekdays? Excel has the answer for you using the Autofill feature. It allows you to create a series of dates that only include the weekdays.  All … Continue reading →

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

How to Use the SUMPRODUCT Function in Excel

Posted on October 19, 2014 by garysch

Many people will have at least two columns or rows of numbers that first need multiplying together and then totalling up. In most cases they will create a formula that multiplies them together and then use the SUM function to … Continue reading →

Posted in Excel, Excel Functions, Microsoft Office | Tagged , , , , , | Leave a comment

VBA: Using the IF Statement

Posted on May 29, 2014 by garysch

The IF statement is one of the most important concepts to use when programming, it is simply used all the time. The IF statement helps the program make decisions based on criteria you have set. So it can decided on … Continue reading →

Posted in Excel, Microsoft Access, Microsoft Office, microsoft word, Office 2010, PowerPoint, VBA, Visual Basic for Applications | Tagged , , , , | 1 Comment

How to Use Excel PivotTables

Posted on February 17, 2014 by garysch

Excel is full of great tools for doing data analysis, in fact it is sometimes useful to import data from another application or database and analyse it in Excel. One of these great tools is the PivotTable. It is quick … Continue reading →

Posted in Excel, Microsoft Access, Microsoft Office | Tagged , , , , | 1 Comment

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

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

Printing a Selection with Excel 2010

Posted on June 23, 2012 by garysch

This is another one of those questions I get asked regularly “how can I print just this section in Excel?”. Thankfully the answer to this is easy and can be done in one of two ways. One is to select … Continue reading →

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