# 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) Weight Tracking -- Enter your target weight, and weekly weight loss goals. Then record your weight each week, to see progress in a line chart
Excel File:
Weight Tracker (no macros)

Last updated: August 14, 2022 1:52 PM