Description Knowing how to use advanced functions with spreadsheets is essential to your business career. Properly designed spreadsheets help you manage information. You will examine the use of templates, pivot tables and macros within spreadsheet applications, and practice your skills to gain proficiency in organizing information.