Array Formulas / Shortcuts in Excel
Long time no post...
And this post has nothing to do with VBA either, but I'd like to point out two incredibly useful Excel tutorials by
slowfox
1. Have you ever heard of Array Formulas in Excel? No? Or you did, but never really understood how they work? Then have a look at this tutorial. Although the described tasks would also be solvable with ordinary formulas, they're a great example to understand the concept of array formulas. And as soon as your task is something else than counting or adding up or gets more complex, array formulas are a powerful tool that might save you from coding macros.
2. Working with a program is always quicker and more efficient if you don't have to use keyboard and mouse in parallel. You can hardly work with Excel using only the mouse, but you can try to do everything with your keyboard to get faster. Here's a nice overview of Excel shortcuts that will free you from your mouse maybe not entirely, but a big lot.
And this post has nothing to do with VBA either, but I'd like to point out two incredibly useful Excel tutorials by
slowfox
1. Have you ever heard of Array Formulas in Excel? No? Or you did, but never really understood how they work? Then have a look at this tutorial. Although the described tasks would also be solvable with ordinary formulas, they're a great example to understand the concept of array formulas. And as soon as your task is something else than counting or adding up or gets more complex, array formulas are a powerful tool that might save you from coding macros.
2. Working with a program is always quicker and more efficient if you don't have to use keyboard and mouse in parallel. You can hardly work with Excel using only the mouse, but you can try to do everything with your keyboard to get faster. Here's a nice overview of Excel shortcuts that will free you from your mouse maybe not entirely, but a big lot.