top of page

ADVANCED EXCEL (COMING SOON...)

ADVANCED FILTER

POWER QUERY- COMBINE DATA FROM MULTIPLE WORKBOOKS

UNPIVOT COLUMS USING PQ

UNIQUE

SORT FUNCTION

SORTBY

FILTER FUNCTION

RANDARRAY

SEQUENCE

VSTACK

HSTACK

CHOOSEROWS

CHOOSECOLS

TOROW

TOCOL

LAMBDA

FORMULATEXT FUNCTION

FV FUNCTION

PV FUNCTION

PMT FUNCTION

PPMT & IPMT

MORTGAGE CALCULATOR

RUN A VBA MACRO CODE

bottom of page