Related Posts
Thoughts on XT?
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Thoughts on XT?
Would anyone be willing to teach me vlookup?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

Lookups, sum/sumifs, concat, embedding multiple functions, count, average, subtotal, Len, left, right, mid, substitute,if/ifs, And are some that come to mind. But it depends on the expectations of the role.
Knowing the difference between similar functions and when they should be used would be considered “expertise.” For example, despite performing similar tasks, there are differences between VLOOKUP and INDEX/MATCH in terms of speed and specificity. Understanding the limitations of nested IF statements would be considered “expertise” as another example.
Converting data into pivot tables and visualizations is probably at the top of the list. Short of that, knowing how and when to apply functions to appropriately aggregate information.
Simplifying complex / unorganized data into valuable insights