MS-Excel - Functions and Formula Tutorials

Once you can see the results of conditional formatting, you might want to create formulas that reference only the data that was conditionally formatted.

Once a formula is entered into a cell, you can tell whether the cell is a static value or a value derived from a formula only by clicking in each cell and looking in the Formula bar, or by pressing Ctrl-~ (tilde). This tutorial fills that gap with a custo

Excel formulas get pretty complicated when a mega-formula references another workbook.

Mega-formulas-a formula within a formula, within a formula-are enough to send even the most seasoned Excel veteran running for the hills.

When you're creating calendar-related applications, especially payrollapplications, you sometimes need to know how many times a given day of the week appears in a particular month.

When you add hours in Excel, you can have the result return as total hours and minutes, but unfortunately, not as days, hours, and minutes. Displaying that will take some extra work.

Although VLOOKUP itself is very handy, it is restricted to looking in a specified table to return a result, which sometimes is not enough. You can escape this limitation with the INDIRECT function.

This tutorial shows how to extract the weekday of any date by using the WEEKDAY function.

Dates can tricky to work with, and finding the last day of a given month can be a challenge.

Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets, and workbooks can be particularly difficult, especially as spreadshe