Categories

Most used functions

Categories

Combobox (5)
Excel (1,075)
- Add-in (4)
- Basic formulas (72)
  - Count (10)
  - Dates (15)
  - Extract (7)
  - INDEX + MATCH (6)
  - Logic (9)
  - Lookups (7)
  - Sum (12)
  - Text string manipultion (3)
  - Time (3)
- Blank cells (5)
- Calendar (17)
- Case sensitive (3)
- Charts (92)
  - 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 (6)
  - 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)
    - Column (1)
    - Line (1)
    - Win/loss (1)
  - 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 (32)
  - Count text values (1)
  - Count unique distinct values (6)
- Dates (48)
  - Overlapping (16)
- Duplicate records (1)
- Duplicate values (15)
- Excel Basics (16)
- Features (75)
  - Advanced filter (6)
  - Data validation (27)
    - Drop down lists (24)
      - Dependent drop down lists (6)
  - Excel table (20)
  - Named range (4)
  - Pivot table (15)
  - Solver (5)
- Filter emails (2)
- Filter records (9)
- Finance (13)
  - Stock market trend (5)
  - Stock portfolio (4)
- Find numbers in sum (4)
- Functions (469)
  - 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 (25)
    - 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)
    - SYD function (1)
    - TBILLEQ function (1)
    - TBILLPRICE function (1)
    - TBILLYIELD function (1)
    - VDB 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 (49)
    - 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)
      - Lookup numerical ranges (1)
    - MATCH function (4)
    - OFFSET function (1)
    - ROW function (6)
    - ROWS function (2)
    - TRANSPOSE function (4)
    - VLOOKUP function (7)
  - Math and trigonometry (116)
    - 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)
    - 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 (5)
    - SUMSQ function (1)
    - SUMX2MY2 function (1)
    - SUMX2PY2 function (1)
    - SUMXMY2 function (1)
    - TAN function (1)
    - TANH function (1)
    - TRUNC function (1)
  - Statistical (123)
    - 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 (8)
    - COUNTBLANK function (2)
    - COUNTIF function (8)
    - COUNTIFS function (5)
    - 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 (1)
    - 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 (1)
    - 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 (53)
    - ASC function (1)
    - CHAR function (3)
    - CLEAN function (1)
    - CODE function (3)
    - 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 (4)
    - 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)
    - ENCODEURL function (1)
    - WEBSERVICE function (1)
- 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 (8)
- Related tables (6)
- Schedule (11)
- Search and return multiple values (12)
  - Wildcard Search (1)
- Sequence (7)
- Sort values (25)
- Split values (7)
- Substitute Replace (1)
- Templates (17)
- Text string manipulation (2)
- Tournament (1)
- Two-dimensional lookup (7)
- Unique distinct records (7)
- Unique distinct values (32)
- Unique values (11)
  - Range (1)
- VBA (148)
  - Arrays (3)
  - Check-boxes (6)
  - 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 (71)
  - Methods (2)
    - Evaluate method (1)
    - Range.Find method (1)
  - Print (5)
  - Properties (1)
    - RANGE.OFFSET property (1)
  - Recursive (1)
  - Regular expressions (4)
  - Statements (18)
    - DO LOOP statement (1)
    - FOR NEXT statement (6)
    - GoTo statement (1)
    - IF THEN ELSE statement (6)
    - SELECT CASE statement (1)
    - WITH … END WITH Statement (4)
  - Text boxes (1)
  - User Defined Function (32)
  - Worksheet (2)
- VLOOKUP and return multiple values (13)

Comments Off on Categories

Weekly Blog EMAIL

Get a FREE PDF book!

Welcome! I am Oscar and here to help you out.

Feel free to comment and ask Excel questions.

Make sure you subscribe to my newsletter so you don't miss new blog articles.