Related Posts
Anyone in the Houston area?
Your most positive customer interaction?
Additional Posts in Tax Technology
A bowl for all things tax technology
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.





Pretty much no one expects new staff to know anything past adding and subtracting on Excel, but it's good if you want to have some knowledge before starting. Basic formulas like SUMIF/COUNTIF, VLOOKUP, and generic IF( ) conditions are helpful down the road. Absolutely none of my staff know INDEX(MATCH,MATCH) and don't seem to want to learn anything new, but I would suggest you learn it as it's a powerful formula that you could do a lot with. I also don't know what firm's tools you have at your disposal but if you're starting at a midsize or a small firm, Excel will likely be your best friend if you know how to utilize its features. If you're a keyboard person, you may want to set up your Quick Access ribbon for easier access to functions you use often (like special paste options) and learn other shortcuts.
Tip: Any time I learn a new formula that took me a while to understand, I write it down in my OneNote with an explanation for future-me for when I have to use it again.
I'd be a millionaire if I got a dollar for every time I used SUMIFS or XLOOKUP
I havent used XLookup yet? Just Vlookup and Hlookup. Wow what's Xlookup used for ?