I have used Excel since the start of my career, more than eight years in different sales jobs. For me it is the main tool to keep sales under control. I keep my customer and dealer lists in it, follow weekly and monthly sales against target, and prepare price and offer calculations with discounts. Pivot tables and filters are what I use most, with them I can turn a long list into a clear summary in a few minutes. Formulas like VLOOKUP and IF save me from doing the same calculation by hand again and again. Charts help when I need to show the numbers to management. Another big plus is that everybody has it. Customers, dealers and colleagues all open the same file without any problem. Review collected by and hosted on G2.com.
The advanced side is hard to learn. The basics and pivot tables came quickly, but things like macros and Power Query have a steep learning curve and I could not get comfortable with them without spending a lot of extra time. I think many users like me stay on the same level because of this. Simpler guidance inside the program for these advanced features would help. Review collected by and hosted on G2.com.





