# Tag Archives: excel

## Excel: Using the MAX() and MIN() Functions

Want to find the highest or lowest values in the a range in Excel? Then there are two functions that are easy to use to do that. They are MAX(), for finding the highest, or maximum value, and you guessed … Continue reading

## Excel: Using the LARGE() and SMALL() Functions

If you have been using Excel you have probably come across the MAX and MIN functions for finding the highest or lowest values in a range. But what if you want to find the second largest or third and so … Continue reading

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

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 | | 1 Comment

## How to Use the SUMPRODUCT Function in Excel

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

## VBA: Using the IF Statement

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

| | 1 Comment

## How to Use Excel PivotTables

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 | | 1 Comment

## Excel Formulas, Getting Started with Calculations

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 | | 6 Comments

## How to Do Headers and Footers in Excel 2010 and 2013

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.