The following are a dozen helpful things I learned at a day-long seminar “The Power of Excel – Part 2,” held on location at the offices of the CFA Society of Toronto on June 10, 2015. The seminar was conducted by Jon Zelman of The Marquee Group.
4. If you filter, use SUBTOTAL, not SUM
5. To count the number of visible rows
6. Searching with multiple conditions
8. “Exact” string matching versus “includes”
9. Multiple conditions for SUMIF
10. Weed out bad parameters early with Data Validation
11. Match and Index functions complement each other
ª
Click here to browse the Spreadsheeto website, which is full of handy tips on Excel.
Click here to browse the Guru99 website, which contains free Excel tutorials.