# Tag Archives: excel functions

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

## Useful Site of Excel Functions

Excel is such a useful program but many people using it only scratch the surface. One of the most useful things about Excel are its functions for doing calculations. They are basically built in formula to work out everything from … Continue reading

Posted in Excel, Excel Functions, Microsoft Office | Tagged , , , , | Leave a 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

## Excel Using Text Functions

Excel is great for dealing with numbers but it also has functions for dealing with text. You can check in a bit of the text by extracting it using one of the functions like LEFT, RIGHT and MID.  You can … Continue reading

Posted in Excel | | 1 Comment

## Combining VLOOKUP and HLOOKUP Functions

HLOOKUP and VLOOKUP functions are very useful functions on their own but if you combine them together you can do even more. If you are using VLOOKUP rather than having the two columns one with the value to lookup and … Continue reading

Posted in Excel, Office 2010 | | 2 Comments

## Excel Database Functions

So this week I’ve had a bit of inspiration creating some Excel tutorials but don’t worry I’ve also started others including the photography and video podcasts which will be with you in January 2014. But here is one Excel one … Continue reading

Posted in Excel, Office 2010 | | 1 Comment

## Using Excel Functions on a Mac

OK, so this one is a little specific but as both a Windows and Mac user the one thing that does frustrate me is that Excel on a Mac uses the Insert Function differently to how it works on Windows. … Continue reading