Excel functions video tutorial. Learn how to use excel in exactly 30 minutes starting with the very basics for the complete beginner and then move to more intermediate features such as ch. Cell references in excel are very importantunderstand the difference between relative absolute and mixed reference and you are on your. This tutorial explains how to use formulas and functions in excel. Want all of our free microsoft excel advanced formulas and functions training videos.
Weekday function applies to a date and returns the output for day of the week. 1 count and sum. This video shows you how to use microsoft excels vlookup function to compare values in two lists. Excel function weekday.
Weekday as the word suggest it is day count in a week. The output of the function varies from 0 to 7 and by default weekday function takes sunday to saturday as a week and counts sunday as 1st day till saturday as 7th day. The most used functions in excel are the functions that count and sumyou can count and sum based on one criteria or multiple criteria. This video will demonstrate how to use microsoft excel in order to perform calculations via formulas on existing data tables to quickly and productively.