I have been using Excel (1997, 2000, 2007) for lists, planning and rudimentary budgets, using formulas and VBA (for generating stickers with serial numbers based on an order form and the quantities listed, or a form that lists entries from a SQL database and then allows you to see more, etc). In the last five years I was introduced to Pivot Tables and charts, cell styles (and cleaning them up), conditional formatting and Tables (as opposed to ranges). I like solving colleagues' problems , but wish I knew more about the stuff I don't use every day (that nobody asks me about), like (obviously not limited to) Index, Offset and Array formulas.
I have a decent book, and there are good forums like this one, but if you don't know what you're missing, you don't know what to ask, right?
What I do know: my confidence took a dive when migrating my just working custom code and little solutions from Windows 7 (64) and Office 2010 to Windows 8 (64) and Office 2013.
Bookmarks