Advanced Formulas. Formulas make Excel smart. ... Tables & Formatting. Advanced Excel users know how to structure & present their data so that it looks impressive. ... Conditional Formatting. ... Advanced Charting. ... Pivot tables & Pivot Reporting. ... VBA & Macros. ... Using Excel Productively. ... Data Tables, Simulations & Solver.