Ned
Footballguy
I'm an Excel nerd to the hilt and enjoy helping others when it comes to Excel problems, so I figured I'd start a thread where y'all can ask questions on how to do certain things in Excel. I'm game for anything from formulas to Excel VBA.
I'll also try to bump this at times with various tips/tricks I've learned over the years. Here are a few random thoughts:
Repeating formulas
When you're using a formula against a data population that resides in multiple rows, you can make Excel do the work for you. First, enter the formula you want to use next to your data. While still selected on that cell with the formula, take your mouse and double click the tiny box that's in the lower right hand corner of the cell. Excel will autofill that formula all the way down until it finds a gap in your data.
Autofill Days, Months
Excel will autofill Days or Months for you. Enter "January" and then click/drag the tiny box in the lower right hand corner (while still selected on January) and drag it as far as you need it. Excel will fill the rest of the months. The same can be done for days of the week as well as the 3 letters for each (Jan, Feb, Mon, Tue). You can also add your own custom lists for Excel to autofill by going to File - Options - Advanced - Edit Custom Lists (this is the 2013 path).
Pivot tables are powerful
Learn how to use this tool - it will take care of a lot of things people are looking to do with formulas when they want to summarize/analyze it. Here's a decent video - https://www.youtube.com/watch?v=8ffdXfriLPQ
I'll also try to bump this at times with various tips/tricks I've learned over the years. Here are a few random thoughts:
Repeating formulas
When you're using a formula against a data population that resides in multiple rows, you can make Excel do the work for you. First, enter the formula you want to use next to your data. While still selected on that cell with the formula, take your mouse and double click the tiny box that's in the lower right hand corner of the cell. Excel will autofill that formula all the way down until it finds a gap in your data.
Autofill Days, Months
Excel will autofill Days or Months for you. Enter "January" and then click/drag the tiny box in the lower right hand corner (while still selected on January) and drag it as far as you need it. Excel will fill the rest of the months. The same can be done for days of the week as well as the 3 letters for each (Jan, Feb, Mon, Tue). You can also add your own custom lists for Excel to autofill by going to File - Options - Advanced - Edit Custom Lists (this is the 2013 path).
Pivot tables are powerful
Learn how to use this tool - it will take care of a lot of things people are looking to do with formulas when they want to summarize/analyze it. Here's a decent video - https://www.youtube.com/watch?v=8ffdXfriLPQ