Pivot in Excel

Skip to content

Excel Functions
Charts
Data Analysis
Data Validation
Excel VBA
Formatting
Grouping
Others

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Data Analysis

Understanding Pivot Tables in Excel

January 18, 2019

Worked Examples

PERCENTRANK.INC function: Description, Usage, Syntax, Examples and Explanation
3D-reference example in Excel
Multi-criteria lookup and transpose in Excel
Roll back weekday to Friday base on a particular date in Excel
Understanding Named Range, Named Constant, Name Manager in Excel Formulas
MONTH function: Description, Usage, Syntax, Examples and Explanation
Chart Axes in Excel

Protect and Unprotect Worksheet in Excel
HEX2OCT function: Description, Usage, Syntax, Examples and Explanation
Next biweekly payday from date in Excel

Search for:

More Topics

Excel Standard Deviation
How to reference named range different sheet in Excel
Get fiscal quarter from date in Excel
Calculate grades with VLOOKUP in Excel
Randomize/ Shuffle List in Excel

Excel Selection Techniques

How to use Fill Handle to automatically enter series data in Excel

1 Key Topics

3D SUMIF
ABS function
ACCRINT function
ACCRINTM function
ACOS function
ACOSH function
ACOT function
ACOTH function
ADDRESS function
AGGREGATE function
AMORDEGRC function
AMORLINC function
Analysis ToolPak
AND function
ARABIC function
Area Chart
AREAS function
ASC function
ASIN function
ASINH function
ATAN function
ATAN2 function
AVEDEV function
AVERAGE function
AVERAGEA function
AVERAGEIF function
AVERAGEIFS function
BAHTTEXT function
Bar Chart
BASE function
BESSELI function
BESSELJ function
BESSELK function
BESSELY function
BETA.DIST function
BETA.INV function
BIN2DEC function
BIN2HEX function
BIN2OCT function
BINOM.DIST function
BINOM.DIST.RANGE function
BINOM.INV function
BITAND function
BITLSHIFT function
BITOR function
BITRSHIFT function
BITXOR function
CAGR
CEILING function
CEILING.MATH function
CEILING.PRECISE function
CELL function
Cell Ranges & References
CHAR function
CHISQ.DIST function
CHISQ.DIST.RT function
CHISQ.INV function
CHISQ.INV.RT function
CHISQ.TEST function
CHOOSE function
CLEAN function
Clustered Column
CODE function
Column Chart
COLUMN function
COLUMNS function
COMBIN function
COMBINA function
Combo Chart
COMPLEX function
Compound Annual Growth Rate
CONCAT function
CONCATENATE function
Conditional Formatting
CONFIDENCE.NORM function
CONFIDENCE.T function
Conversion
CONVERT function
CORREL function
COS function
COSH function
COT function
COTH function
COUNT function
COUNTA function
COUNTBLANK function
COUNTIF function
COUNTIFS function
COUPDAYBS function
COUPDAYS function
COUPDAYSNC function
COUPNCD function
COUPNUM function
COUPPCD function
COVARIANCE.P function
COVARIANCE.S function
CSC function
CSCH function
CUBEKPIMEMBER function
CUBEMEMBER function
CUBEMEMBERPROPERTY function
CUBERANKEDMEMBER function
CUBESET function
CUBESETCOUNT function
CUBEVALUE function
CUMIPMT function
CUMPRINC function
Custom Number Format
Data Table
DATE function
DATEDIF function
DATEVALUE function
DAVERAGE function
DAY function
DAYS function
DAYS360 function
DB function
DBCS function
DCOUNT function
DCOUNTA function
DDB function
DEC2BIN function

2 Key Topics

DEC2HEX function
DEC2OCT function
DECIMAL function
DEGREES function
DELTA function
DEVSQ function
DGET function
DISC function
DMAX function
DMIN function
DOLLAR function
DOLLARDE function
DOLLARFR function
DPRODUCT function
DSTDEV function
DSTDEVP function
DSUM function
DURATION function
DVAR function
DVARP function
EDATE function
EFFECT function
ENCODEURL function
EOMONTH function
ERF function
ERFC function
ERFC.PRECISE function
ERROR.TYPE function
Errors
EVEN function
EXACT function
Excel Controls
EXP function
EXPON.DIST function
F.DIST function
F.DIST.RT function
F.INV function
F.TEST function
FACT function
FACTDOUBLE function
FALSE function
FILTERXML function
Find & Select
FIND function
FINDB function
FISHER function
FISHERINV function
FIXED function
FLOOR function
FLOOR.MATH function
FLOOR.PRECISE function
FORECAST function
Format Cell
Formulas and Functions
FORMULATEXT function
FREQUENCY function
Future value
FV function
FVSCHEDULE function
GAMMA function
GAMMA.DIST function
GAMMA.INV function
GAMMALN function
GAMMALN.PRECISE function
Gantt Chart
Gauge Chart
GAUSS function
GCD function
GEOMEAN function
GESTEP function
GETPIVOTDATA function
GROWTH function
HARMEAN function
HEX2BIN function
HEX2DEC function
HEX2OCT function
Histogram Chart
HLOOKUP function
HOUR function
HYPERLINK function
HYPGEOM.DIST function
IF function
IFERROR function
IFNA function
IFS function
IMABS function
IMAGINARY function
IMARGUMENT function
IMCONJUGATE function
IMCOS function
IMCOSH function
IMCOT function
IMCSC function
IMCSCH function
IMDIV function
IMEXP function
IMLN function
IMLOG10 function
IMLOG2 function
IMPOWER function
IMPRODUCT function
IMREAL function
IMSECH function
IMSIN function
IMSINH function
IMSQRT function
IMSUB function
IMSUM function
IMTAN function
INDEX function
INDIRECT function
INFO function
INT function
INTERCEPT function
Internet
INTRATE function
IPMT function
IRR function
IS function
ISBLANK function
ISERR function
ISERROR function

3 Key Topics

ISEVEN function
ISFORMULA function
ISLOGICAL function
ISNA function
ISNONTEXT function
ISNUMBER function
ISO.CEILING function
ISODD function
ISOWEEKNUM function
ISPMT function
ISREF function
ISTEXT function
KURT function
LARGE function
LCM function
LEFT function
LEFTB function
LEN function
LENB function
Line Chart
LINEST function
Links
LN function
LOG function
LOG10 function
LOGEST function
LOGNORM.DIST function
LOGNORM.INV function
LOOKUP function
LOWER function
Macro
MATCH function
MAX function
MAXA function
MAXIFS function
MDETERM function
MDURATION function
MEDIAN function
MID function
MIDB function
MIN function
MINA function
MINIFS function
MINUTE function
MINVERSE function
MIRR function
MMULT function
MOD function
MODE function
MODE.MULT function
MODE.SNGL function
MONTH function
MROUND function
MULTINOMIAL function
MUNIT function
N function
NA function
NEGBINOM.DIST function
Nested IF
Net Present Value
NETWORKDAYS function
NETWORKDAYS.INTL function
NOMINAL function
NORM.DIST function
NORM.INV function
NORM.S.DIST function
NORM.S.INV function
NOT function
NOW function
NPER function
NPV function
NUMBERVALUE function
OCT2BIN function
OCT2DEC function
OCT2HEX function
ODD function
ODDFPRICE function
ODDFYIELD function
ODDLPRICE function
ODDLYIELD function
OFFSET function
Operator Precedence
OR function
Pareto Chart
PDURATION function
PEARSON function
Percentage
PERCENTILE function
PERCENTILE.EXC function
PERCENTILE.INC function
PERCENTRANK.EXC function
PERCENTRANK.INC function
PERMUT function
PERMUTATIONA function
PHI function
PHONETIC function
PI function
Pie Chart
Pivot
PMT function
POISSON.DIST function
POWER function
PPMT function
Present value
PRICE function
PRICEDISC function
PRICEMAT function
Print
PROB function
Probability
PRODUCT function
PROPER function
Protect
PV function
QUARTILE function
QUARTILE.EXC function
QUARTILE.INC function
QUOTIENT function
RADIANS function
RAND function
RANDBETWEEN function
Random
RANK function

4 Key Topics

RANK.AVG function
RANK.EQ function
RATE function
RECEIVED function
REPLACE function
REPLACEB function
REPT function
Ribbon
RIGHT function
RIGHTB function
ROMAN function
ROUND function
ROUNDDOWN function
ROUNDUP function
ROW function
ROWS function
RRI function
RSQ function
Scatter Chart
SEARCH function
SEARCHB function
SEC function
SECH function
SECOND function
SEQUENCE function
SERIESSUM function
Share
SHEET function
SHEETS function
Shortcuts
SIGN function
SIN function
SINH function
SKEW function
SKEW.P function
SLN function
SLOPE function
SMALL function
Solver
Sort and Filter
Sparklines
Split Text
SQRT function
SQRTPI function
STANDARDIZE function
STDEV function
STDEV.S function
STDEVA function
STDEVPA function
STEYX function
SUBSTITUTE function
SUBTOTAL
SUBTOTAL function
SUM function
SUMIF function
SUMIFS function
SUMPRODUCT function
SUMSQ function
SUMX2MY2 function
SUMX2PY2 function
SUMXMY2 function
SWITCH function
SYD function
T function
T.DIST function
T.DIST.2T function
T.DIST.RT function
T.INV function
T.INV.2T function
T.TEST function
Tables
TAN function
TANH function
TBILLEQ function
TBILLPRICE function
TBILLYIELD function
Templates
TEXT function
TEXTJOIN function
Thermometer Chart
TIME function
TIMEVALUE function
TODAY function
TRANSPOSE function
TREND function
Trendline
TRIM function
TRIMMEAN function
TRUE function
TRUNC function
TYPE function
UNICHAR function
UNICODE function
Unix Time Stamp
UPPER function
VALUE function
VAR.P function
VAR.S function
VARA function
VARPA function
VDB function
View Tab
VLOOKUP function
WEBSERVICE function
WEEKDAY function
WEEKDAY.INTL function
WEEKNUM function
WEIBULL.DIST function
What-If Analysis:
Whisker Plot
Workbook
WORKDAY function
WORKDAY.INTL function
Worksheets
XIRR function
XNPV function
XOR function
YEAR function
YEARFRAC function
YIELD function
YIELDDISC function
YIELDMAT function
Z.TEST function

Powered by WordPress