Categories
Categories
-
Excel (1,077)
- Add-in (4)
-
Basic formulas (76)
- Count (10)
- Dates (15)
- Extract (9)
- INDEX + MATCH (7)
- Logic (9)
- Lookups (8)
- Sum (12)
- Text string manipultion (3)
- Time (3)
- Blank cells (5)
- Calendar (16)
- Case sensitive (3)
-
Charts (93)
- 100% stacked column chart (1)
- Animate (3)
- Area chart (1)
- Bar chart (2)
- Box and whisker chart (1)
- Bubble chart (1)
- Candlestick chart (1)
- Chart basics (7)
- Chart elements (16)
- Column chart (6)
- Combination chart (3)
- Custom charts (6)
- Data labels (1)
- Doughnut chart (1)
- Funnel chart (1)
- Gantt (2)
- Highlight (5)
- Histogram chart (1)
- Interactive (10)
- Line chart (4)
- Map chart (1)
- Pareto chart (1)
- Pie chart (1)
- Radar chart (1)
- SCATTER (x y) chart (8)
- Sparkline (3)
- STACKED COLUMN chart (1)
- stock chart (4)
- Sunburst chart (1)
- Surface chart (1)
- Treemap chart (1)
- Waterfall chart (1)
- Combinations (2)
- Combine Merge (9)
- Compare (16)
- Concatenate (5)
-
Conditional formatting (53)
- CF-basic-formulas (4)
- CF-built-in (3)
- CF-compare (6)
- CF-dates (9)
- CF-duplicates (9)
- CF-formatting (3)
- CF-min-max (3)
- CF-misc (3)
- CF-search (4)
- CF-unique-distinct (4)
- Highlight Cells Rules (4)
- Highlight duplicates (1)
- Top/Bottom Rules (3)
- Count unique distinct records (1)
- Count values (31)
-
Dates (45)
- Overlapping (15)
- Duplicate records (1)
- Duplicate values (16)
- Excel Basics (16)
-
Features (78)
- Advanced filter (6)
-
Data validation (28)
- Drop down lists (25)
- Excel table (22)
- Named range (5)
- Pivot table (16)
- Solver (5)
- Filter emails (2)
- Filter records (9)
-
Finance (13)
- Stock market trend (5)
- Stock portfolio (4)
- Find numbers in sum (4)
-
Functions (473)
-
Compatibility (22)
- BETADIST function (1)
- BETAINV function (1)
- BINOMDIST function (1)
- CHIDIST function (1)
- CHIINV function (1)
- CHITEST function (1)
- CONFIDENCE (1)
- COVAR function (1)
- CRITBINOM function (1)
- EXPONDIST function (1)
- FDIST function (1)
- FLOOR function (1)
- FORECAST function (1)
- FTEST function (1)
- GAMMADIST function (1)
- LOGNORMDIST function (1)
- MODE function (1)
- PERCENTRANK function (1)
- QUARTILE function (1)
- RANK function (2)
- STDEV function (1)
-
Database (11)
- DAVERAGE function (1)
- DCOUNT function (1)
- DGET function (1)
- DMAX function (1)
- DMIN function (1)
- DOUNTA function (1)
- DPRODUCT function (1)
- DSTDEV function (1)
- DSTDEVP function (1)
- DSUM function (1)
- DVARP function (1)
-
Date and Time (44)
- DATE function (5)
- DATEDIF function (2)
- DATEVALUE function (2)
- DAY function (2)
- DAYS function (1)
- EDATE function (1)
- EOMONTH function (1)
- HOUR function (4)
- MINUTE function (2)
- MONTH function (5)
- NETWORKDAYS function (1)
- NETWORKDAYS.INTL function (1)
- NOW function (2)
- SECOND function (2)
- TIME function (7)
- TIMEVALUE function (1)
- TODAY function (5)
- WEEKDAY function (6)
- WEEKNUM function (1)
- WORKDAY function (1)
- YEAR function (2)
- YEARFRAC function (1)
-
Engineering (14)
- BIN2DEC function (1)
- BIN2HEX function (1)
- BIN2OCT function (1)
- BITAND function (1)
- BITLSHIFT function (1)
- BITOR function (1)
- BITRSHIFT function (1)
- BITXOR function (1)
- COMPLEX function (1)
- CONVERT function (1)
- DEC2BIN function (1)
- DEC2HEX function (1)
- DEC2OCT function (1)
- DELTA function (1)
-
Financial (27)
- ACCRINT function (1)
- ACCRINTM function (1)
- AMORDEGRC function (1)
- AMORLINC function (1)
- CUMIPMT function (1)
- CUMPRINC function (1)
- DB function (1)
- DDB function (1)
- DOLLARFR function (1)
- EFFECT function (1)
- FV function (1)
- IPMT function (1)
- ISPMT function (1)
- NOMINAL function (1)
- PDURATION function (1)
- PMT function (1)
- PPMT function (1)
- PRICEMAT function (1)
- RATE function (1)
- RRI function (1)
- SYD function (1)
- TBILLEQ function (1)
- TBILLPRICE function (1)
- TBILLYIELD function (1)
- VDB function (1)
- XNPV function (1)
- YIELD function (1)
-
Information (34)
- CELL function (1)
- ERROR.TYPE function (1)
- INFO function (1)
- ISBLANK function (5)
- ISERR function (1)
- ISERROR function (5)
- ISFORMULA function (1)
- ISLOGICAL function (1)
- ISNA function (3)
- ISNONTEXT function (1)
- ISNUMBER function (5)
- ISODD function (1)
- ISREF function (1)
- ISTEXT function (3)
- N function (1)
- NA function (1)
- SHEET function (1)
- SHEETS function (1)
- TYPE function (1)
-
Logical (27)
- AND function (4)
- FALSE function (1)
- IF function (8)
- IFERROR function (1)
- IFNA function (1)
- IFS function (1)
- ISEVEN funtion (1)
- NOT function (6)
- OR function (6)
- SWITCH function (1)
- TRUE function (1)
- XOR function (1)
-
Lookup and reference (48)
- ADDRESS function (4)
- AREAS function (1)
- CHOOSE function (2)
- COLUMN function (2)
- COLUMNS function (4)
- FORMULATEXT function (1)
- HLOOKUP function (1)
- HYPERLINK function (5)
- INDEX function (2)
- INDIRECT function (7)
- LOOKUP function (7)
- MATCH function (4)
- OFFSET function (1)
- ROW function (5)
- ROWS function (2)
- TRANSPOSE function (4)
- VLOOKUP function (7)
-
Math and trigonometry (119)
- ABS function (3)
- ACOS function (1)
- ACOSH function (1)
- ACOT function (1)
- ACOTH function (1)
- AGGREGATE function (5)
- ASIN function (1)
- ASINH function (1)
- ATAN function (1)
- ATAN2 function (1)
- ATANH function (1)
- BASE function (1)
- CEILING function (1)
- COMBIN function (1)
- COMBINA function (1)
- COS function (1)
- COSH function (1)
- COT function (1)
- COTH function (1)
- CSC function (1)
- DECIMAL function (1)
- DEGREES function (2)
- EVEN function (2)
- EXP function (1)
- FACT function (7)
- FACTDOUBLE function (1)
- FLOOR.MATH function (1)
- FLOOR.PRECISE function (1)
- GCD function (1)
- GDC function (1)
- INT function (4)
- LCM function (1)
- LN function (1)
- LOG function (1)
- LOG10 function (1)
- MINVERSE function (1)
- MMULT function (10)
- MOD function (5)
- MROUND function (1)
- MULTINOMIAL function (1)
- MUNIT function (1)
- PI function (2)
- POWER function (4)
- PRODUCT function (1)
- QUOTIENT function (2)
- RADIANS function (2)
- RAND function (2)
- RANDBETWEEN function (3)
- ROUNDDOWN function (1)
- ROUNDUP function (1)
- SEC function (1)
- SECH function (1)
- SERIESSUM function (1)
- SIGN function (1)
- SIN function (1)
- SINH function (1)
- SQRT function (1)
- SUBTOTAL function (3)
- SUM function (15)
- SUMIF function (1)
- SUMIFS function (2)
- SUMPRODUCT function (6)
- SUMSQ function (1)
- SUMX2MY2 function (1)
- SUMX2PY2 function (1)
- SUMXMY2 function (1)
- TAN function (1)
- TANH function (1)
- TRUNC function (1)
-
Statistical (124)
- AVEDEV function (1)
- AVERAGE function (7)
- AVERAGEA function (1)
- AVERAGEIF function (2)
- AVERAGEIFS function (1)
- BETA.DIST function (1)
- BETA.INV function (1)
- BINOM.DIST function (1)
- BINOM.INV function (1)
- CHISQ.DIST function (1)
- CHISQ.DIST.RT function (1)
- CHISQ.INV function (1)
- CHISQ.INV.RT function (1)
- CHISQ.TEST function (1)
- CONFIDENCE.NORM (1)
- CONFIDENCE.T function (1)
- CORREL function (1)
- COUNT function (4)
- COUNTA function (7)
- COUNTBLANK function (2)
- COUNTIF function (8)
- COUNTIFS function (6)
- COVARIANCE.P function (1)
- COVARIANCE.S function (1)
- EXPON.DIST function (1)
- F.DIST function (1)
- F.DIST.RT (1)
- F.TEST function (1)
- FORECAST.LINEAR function (1)
- FREQUENCY function (6)
- GAMMA function (1)
- GAMMA.DIST function (1)
- GEOMEAN function (1)
- GROWTH function (1)
- INTERCEPT function (2)
- LARGE function (2)
- LINEST function (1)
- LOGEST function (1)
- LOGNORM.DIST function (1)
- MAX function (2)
- MAXIFS function (2)
- MEDIAN function (3)
- MIN function (5)
- MINA function (1)
- MINIFS function (4)
- MODE.MULT function (1)
- MODE.SNGL function (1)
- NORM.DIST function (1)
- NORM.INV function (1)
- PERCENTRANK.EXC function (1)
- PERCENTRANK.INC function (1)
- PERMUT function (8)
- PERMUTATIONA function (3)
- PHI function (1)
- PROB function (1)
- QUARTILE.EXC function (1)
- QUARTILE.INC function (1)
- RANK.AVG function (1)
- RANK.EQ function (1)
- SKEW function (1)
- SLOPE function (2)
- SMALL function (8)
- STANDARDIZE function (1)
- STDEV.P (1)
- STDEV.S function (1)
- STDEVA function (1)
- STDEVPA function (1)
- TREND function (1)
- TRIMMEAN function (1)
- VAR.P function (1)
- VAR.S function (1)
-
Text (52)
- ASC function (1)
- CHAR function (3)
- CLEAN function (1)
- CODE function (2)
- CONCAT function (1)
- CONCATENATE function (1)
- EXACT function (5)
- FIND function (4)
- FIXED function (1)
- LEFT function (4)
- LEN function (5)
- LOWER function (1)
- MID function (3)
- REPT function (3)
- RIGHT function (2)
- SEARCH function (4)
- SUBSTITUTE function (7)
- T function (1)
- TEXT function (5)
- TEXTJOIN function (4)
- TRIM function (4)
- UNICHAR function (1)
- UNICODE function (1)
- UPPER function (3)
- VALUE function (1)
- Web (2)
-
Compatibility (22)
- Fuzzy lookup (2)
- Hyperlinks (9)
- Invoice (7)
- Maps (3)
- Maze (3)
- Misc (6)
- Missing values (8)
- Normalize data (2)
- Pathfinding (4)
- PDF (1)
- Permutations (9)
-
Random (9)
- Team generator (3)
- Rank (3)
- Rearrange values (4)
- Records (9)
- Relational tables (7)
- Schedule (12)
-
Search and return multiple values (12)
- Wildcard Search (1)
- Sequence (7)
- Sort values (25)
- Split values (7)
- Substitute Replace (1)
- Templates (16)
- Text string manipulation (2)
- Tournament (1)
- Two-dimensional lookup (7)
- Unique distinct records (8)
- Unique distinct values (32)
-
Unique values (11)
- Range (1)
-
VBA (156)
- Arrays (3)
- Check-boxes (6)
- Combobox (5)
- Dialog boxes (1)
- Files and folders (14)
-
Form Controls (6)
- Scroll bar (1)
-
Functions (7)
- ARRAY function (1)
- Fix Function (1)
- INT function (1)
- JOIN function (1)
- Lbound Ubound function (1)
- SGN function (1)
- SPLIT function (1)
- Listbox (3)
- Macro (73)
-
Methods (2)
- Evaluate method (1)
- Range.Find method (1)
- Print (5)
- Properties (1)
- Recursive (1)
- Regular expressions (4)
-
Statements (19)
- DO LOOP statement (1)
- FOR NEXT statement (6)
- GoTo statement (1)
- IF THEN ELSE statement (6)
- SELECT CASE statement (1)
- SET statement (1)
- WITH … END WITH Statement (4)
- Text boxes (1)
- User Defined Function (33)
- Worksheet (2)
- VLOOKUP and return multiple values (13)
Comments Off on Categories
English
Spanish