Excel program options, automatic calculation, error checking rules, customising the ribbon and quick access toolbar
Format & structure of databases: delimiters, headers, records, fields, flat file vs relational data
Filtering and sorting data and different data formats like Comma Separated Values (CSV), TXT, Tab separated values and how to open data in different programs
Naming Ranges and using Named Ranges in formulas. Data validation and drop down lists and mastering find and replace.
