'TODAY function' category

How to track sector performance in the stock market – Excel template
The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]
How to use the TODAY function
What is the TODAY function? The TODAY function returns the Excel date (serial number) of the current date. Note! This […]
Calendar – monthly view
This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]
Yet another Excel Calendar
What's on this page How to use this Excel Calendar How to add events How I built this calendar Worksheet […]
Excel calendar
Table of Contents Excel monthly calendar - VBA ┬áCalendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]
Shift Schedule
Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]

Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

Excel categories