### Latest Tutorial: PowerPoint Creating a Video from Presentation

Check out my latest tutorial on my website. How to create a video from a PowerPoint Presentation-
### Recent Posts

### Archives

### Buy me a coffee

Donation

If you like this free blog and would like to help keep it going then a coffee will help.

$2.00

### Categories

### Meta

### Latest Tutorials

- About
- AutoFill to Copy Data, Values,Functions and Formulas and Also to Create a Series
- AutoSum to Total Up a Column, Row or Range
- Calculating the Number of Days Between Dates
- Conditional Formatting
- Contact
- Creating a Pie Chart in Excel 2003
- Excel Tutorials
- Formatting Data Series in a Chart
- Freeing Up Memory on Your Mac OS X
- Getting Start with Charts in Excel 2010
- Getting Started with Excel 2010
- Goal Seek
- IF Function
- Introduction to Date Functions
- Introduction to Excel Functions
- Introduction to Functions on a Mac
- Naming Cells and Ranges
- PowerPoint Tutorials
- PowerPoint: Using Slide Master
- Printing a Selected Area
- Recording a Macro in Excel 2003
- Resizing Columns and Rows
- Splitting the First Name and Last Name in a Cell into Two Separate Cells
- SUMIF Function
- The COUNTIF Function
- The Payment (PMT) Function for Calculating Repayments on Loans
- Using a Percentage in a Formula
- Using Data Validation to Create a Drop Down List
- Using Scenarios (also known as the Scenario Manager)
- Using the $ signs in an Excel Formula or Function for Absolute and Mixed Referencing
- Using the TODAY() Function to Calculate Someone’s Age
- VLOOKUP Function

### Follow me on Twitter

My Tweets

# 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 excel functions, hlookup, pmt, sum, vlookup
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

Posted in Excel, Excel Functions, Microsoft Office
Tagged excel, excel functions, how-to, maths functions, SUM function, SUMPRODUCT function
Leave a comment

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

## 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
Tagged excel functions, hlookup function, lookup matrix, microsoft excel, vlookup function
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
Tagged database functions, DMAX, DMIN, DSUM, DVAVERAGE, ECDL adavanced, excel database, excel functions
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

Posted in Excel
Tagged excel functions, if function, insert functions, mac functions, pmt function, vlookup
Leave a comment