Knowledge base – Excel

knowledge base excel

With this Excel knowledge base I am aiming to give you the best most concise pill of Excel tech skills you need to master.

Excel – The Foundation of Data Analysis

Excel is one of the most widely used tools for analysts and businesses. With functions such as VLOOKUP, XLOOKUP, pivot tables, logical formulas, and text functions, Excel allows you to quickly analyze data, create reports, and visualize information. In this section, you will find practical guides on the most important functions and tips for optimizing your work in Excel.

Excel – aggregate functions

  • COUNT
  • COUNTA
  • COUNTIF
  • COUNTIFS
  • SUM
  • SUMIF
  • SUMIFS
  • AVERAGE
  • AVERAGEIF
  • AVERAGEIFS
  • MIN
  • MAX

    • Excel – date, time and calendar functions

  • NOW
  • TODAY
  • YEAR
  • MONTH
  • DAY
  • HOUR
  • MINUTE
  • SECOND
  • WEEKDAY
  • WEEKNUM
  • EOMONTH
  • EDATE
  • DATE
  • DATEDIF
  • YEARFRAC
  • WORKDAY
  • NETWORKDAYS
  • TIME

    • Excel – logical functions

  • CHOOSE
  • IF
  • IFERROR
  • IFS
  • AND
  • OR
  • NOT
  • ISNUMBER
  • ISTEXT
  • ISERROR
  • ISNA
  • ISBLANK

    • Excel – lookup functions

  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • INDEX
  • MATCH
  • OFFSET
  • INDIRECT

    • Excel – math functions

  • SMALL
  • LARGE
  • ROUND
  • ROUNDUP
  • ROUNDDOWN
  • INT
  • TRUNC
  • MOD
  • ABS
  • RAND
  • RANDBETWEEN
  • CEILING
  • FLOOR
  • SQRT
  • POWER
  • EXP
  • LOG
  • LOG10
  • SIN
  • COS
  • TAN
  • ASIN
  • ACOS
  • ATAN
  • PI
  • VALUE
  • T

    • Excel – text functions

  • TEXT
  • LEFT
  • RIGHT
  • MID
  • LEN
  • FIND
  • SEARCH
  • SUBSTITUTE
  • REPLACE
  • CONCATENATE
  • CONCAT
  • TEXTJOIN
  • PROPER
  • UPPER
  • LOWER
  • TRIM
  • CLEAN

    • Excel – other functions

  • ADDRESS
  • TRANSPOSE
  • UNIQUE
  • SORT
  • FILTER
  • SEQUENCE
  • FORMULATEXT

    • Check other stuff 👇

    Get back to the main knowledge base page here.