Key Skills > Formulas Excel Formulas and FunctionsUse Excel formulas and functions to summarize data, return values from a lookup table, do mathmatical calculations, and much more! Author: Debra Dalgleish |
Excel Function TutorialsThese 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 VideosHere'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 FilesHere 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. |
![]() |
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: November 8, 2022 2:46 PM