Best excel functions

I like the left and right functions for when you need to format data that might not be formatted exactly the same.

Concatenate

Not a function per se, but the array formula was amazing when introduced and remains a powerful tool.

quote:

---

Concatenate

---

Use it multiple times a week. Good call.

quote:

---

Learn to work in VBA and create your own Macros and Functions. Tremendous time saver for things you do repatedly and will allow you to do things that look cleaner and are virtually impossible to automate simply using functions.

---

Yes. I knew how to record a Macro, pretty simple, but when I was talking to one of the younger staff here, she mentioned VBA and coding stuff. I don't use it all that much, but I have written a few that are nice at this time of month when I'm building reports.

Pivot tables are awesome, if you have a good source file. We have 3-4 different ones that our system generates either daily or monthly. Everything is spit out into a nice flat file, and I can create a ton of graphs or accumulate data quickly.

Variations on the Sum formula are nice, depending on what type of data you have. I use Sumproduct a good bit when finding weighted avg data on a portfolio. Sumif is another good one. I don't use it that much, but there are some files already built here that use them. All I have to do is insert the next month's file, change the cell references in the formula, and drag it down to the bottom.

Not necessarily a function, but learn how to use PowerPivot. I use that a ton.

As far as functions, index and match are good ones to master.

I use Pivot Tables daily. Get good at nesting formulas. My biggest time saver is probably IFERROR(VALUE(LEFT()) when downloading reports out of our GL software. I also format almost everything into a table. Some people at my office hate tables, but I find them very useful.

I never use the concatenate function. I always use & (=A1&"-"&B1)

not to hijack but does anyone know how to save a custom sort?

I appreciate this thread.

Trying to learn VBA and Visual Basic myself. Haven't done much on the software side of things in many many years. I have a descent understanding of the basic sentax but I don't remember a single one of those commands.

And all the videos I've found are arduously slow.