Excel basics thematics

 

Series
Solutions for COPY and PASTE
Relative and absolute cell referencing
Data types
How to insert a function (Type in and Insert function icon)
Statistical functions (SUM, AVERAGE, MIN, MAX and COUNT, SUMIF, AVERAGE IF, COUNTIF)
Date functions (TODAY, NETWORKDAYS, EDATE, EOMONTH)
Logical functions (IF, IF with AND, OR)
Text functions
Lookup and reference functions (VLOOKUP, HLOOKUP)
Name manager
Format Table
Text to columns
Remove duplicates
Data validation
Group and Ungroup
Keyboard shortcuts, several tips and tricks
Recommendation - Links, websites to improve your Excel knowledge