I use the functions listed on a regular basis specially v look ups. But, when it comes to charts i normally prefer Bar charts over column or pie charts.Also, i frequently use index and match functions.& yeah Pivot tables obviously are one of the tools i use for performing variance analysis and sales analysis.