INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick
Microsoft Excel Tips and Tricks Learn how to create an advanced array formula to spill two-way lookup results using INDEX[…]
Read more
Tag: learning
Excel Add A Blank Row After Each Subtotal
Microsoft Excel Tips and Tricks Your manager asks if you can add a blank row after each subtotal. Episode 2433[…]
Read more
Excel MAX Across All Worksheets
Microsoft Excel Tips and Tricks Can you use the MAX function in Excel to find the largest value across all[…]
Read more
What new managers should do.. or at least I would if I started over!
Management Tips and Tricks Ever wonder what someone would do if they had to the chance to start over? I’m[…]
Read more
Most managers AVOID building this but shouldn’t!
Management Tips and Tricks This one trait is what makes leaders sooo sexy..in a professional way of course! Credit Leadership[…]
Read more