​​​​Excel knowledge base

Search


General

  • Installing Excel
  • Change Excel’s language to English
  • Use English functions in Excel
  • Multiplying in Excel
  • Excel error types and their fixes
  • Absolute referencing
  • Excel Autofill
  • Calculating a percentage in Excel

Excel functions

Reference and lookup functions

  • Vlookup
  • Index
  • Match
  • Lookup
  • Hlookup
  • Indirect

Conditional functions

Counting and summing

Functions on numbers

  • Rand
  • Round

Text functions

  • Text
  • Concatenate

Date and time

  • Datedif

This knowledge base is a work in progress. We are always working on improving the number of articles available. If you have any suggestions for articles that you would like to see here, do not hesitate to send us a message through the contact form.

Learn Excel online

Looking for even more Excel knowledge? If this knowledge base isn’t enough, you can take your Excel skills to the next level and learn Excel online with our online Excel course. It has lessons for beginners all the way to advanced Excel skills.

​Get Good at Excel on Autopilot

Sign up to our newsletter and receive ​Excel articles, tips and tricks delivered straight to your inbox. All you have to do is read them! ​Plus, to get you started, you'll receive a PDF with 200+ Excel shortcuts.

>