When you know how to use pivot tables, VLookup, and date functions, among other things, you're deemed intermediate. Excel users with advanced skills must be able to manage and organise vast amounts of data. You must be able to create detailed graphs and tables, as well as record a macro to automate routine activities.