Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013. It has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner.
Advanced Excel is quite different from Basic Excel, the focus for the user is more on Pivot Table, Pivot Chart, Formulas, Functions, and Macros. Some of the other important concepts to explore while working on Advanced Excel are: If Statements. Sum Products.
Your examples should be important to the position and not basic or common functions. For example, you might say “Advanced in MS Excel including PivotTables, VLOOKUP, INDEX/MATCH, and Data Tables”. When you specify your Excel skills, it is best to list this under the Additional section of your resume.
With advanced Excel tools, you can create more complex calculations. Once your formula is written and you have programmed your set command, the program will perform all of the work to complete the calculations, freeing up your time for other tasks and ensuring that you have accurate data the first time around.