Key Skills > Formulas

Excel Formulas and Functions

Use Excel formulas and functions to summarize data, return values from a lookup table, do mathmatical calculations, and much more!

Author: Debra Dalgleish

Excel Function Tutorials

These tutorials show how to use some of the most popular Excel functions.

1 -- How to Sum Cells - Start with the SUM function, then try SUMIFS and more!

2 -- Count All or Specific Cells - Do a simple count, or count based on criteria

3 -- How to Do a VLOOKUP - Find a lookup item in a table, such price for specific product

4 -- Lookup With Criteria - Use formulas to get values from a lookup table, based on multiple criteria

4 -- Combine Text & Numbers - Use formulas to combine values text and numbers from different cells

To see full list of Excel functions, go to the Excel Functions List page.

Excel Function Videos

Here's one of my most popular Excel function videos, and almost all of my Excel function tutorial pages include a video too.

This short video how to quickly split a combined date and time into separate date and time columns. You can use simple Excel formulas, or use a quick trick, with no formulas!

Excel Functions - Sample Files

Here are the download links for a couple of my latest Excel Function sample workbooks, and most of the Excel tutorial pages include a sample file too.

More Workbooks: For even more function sample files, go to the Excel Sample Files page, and scroll down to the Functions section.

Loan Payments -- Enter your loan information, Excel calculates the monthly payment amount, using the PMT function.
Excel File: Loan Payment Schedule (no macros)