MAX and MIN in Excel - Excel tutorial

Category: Excel tutorials > Functions - Difficulty:

Whether you have to give a presentation or you need to liven up your worksheets, giving it a 3D look could be just the thing.

The scenario feature allows you to quickly change a number of input cells based on some predefined situations e.g. Low case, High Case, Realistic Case. You can then switch between the various scenarios easily

Learn how to create Excel spreadsheets with multiple Worksheets from VB.NET

This nice tutorial shows you a simple approach to creating Excel spreadsheets with multiple worksheets programatacally from VB.NET

Includes step by step instructions and full source code.

Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the Column letter or a $ before the Row number (or both). This is called Absolute Positioning.

The EOMONTH (end of month) function allows you to generate a month end date no matter what the original date (even taking into account leap years). Extremely useful when you want to report on standardized dates.