How do I access more advanced Excel Functions like 'Table'?

Answer 1

Table and several other complicated activities are hidden under Data on the menu. While learning, you might want to go into Tools, Customize, Options, and select Always Show Full Menus, instead of the short menus default which hides things.