Spreadsheet Tutorials

Learn Excel and Google Sheets by building real personal-finance tools.

As promised, this page is dedicated to our tips, tricks, and templates about Excel sheets related topics. We also offer Excel tutorials. You will get to know more about utilizing Excel to its full potential. This will be helpful especially when we are doing our own financials.

Excel Functions

VLOOKUP functions

IF functions

INDEX functions

SUMIFS functions

SUM function

TODAY function

TIME function

SECOND function

NOW function

NETWORKDAYS function

MONTH function

MINUTE function

ISOWEEKNUM function

HOUR function

EOMONTH function

EDATE function

DAYS360 function

DAYS function

DAY function

DATE function

DVARP function

DVAR function

DSUM function

DSTDEVP function

DSTDEV function

DPRODUCT function

DMIN function

DMAX function

DGET function

DCOUNTA function

DCOUNT function

DAVERAGE function

ZTEST function

WEIBULL function

VARP function

TTEST function

TDIST function

TINV function

STDEVP function

STDEV function

QUARTILE function

POISSON function

PERCENTILE function

PERCENTRANK function

NORMSINV function

NORMSDIST function

NORM.INV function

NORMDIST function

NEGBINOMDIST function

MODE function

LOGNORMDIST function

LOGINV function

HYPGEOMDIST function

GAMMAINV function

GAMMADIST function

FTEST function

FLOOR function

FDIST function

EXPONDIST function

CRITBINOM function

COVAR function

CONFIDENCE function

CHITEST function

CHIINV function

CHIDIST function

BINOMDIST function

BETAINV function

BETADIST function

VAR function

MAX function

WEEKDAY function

Excel Cells

Excel Shortcuts