NCMOSMI024 — Excel III - 6 hrs
This course will introduce you to analyticalfeatures used in Excel topics including advancedformulas and list management; pivot tables;exporting & importing data; analytical options;and macros. Additional features covered are:*Using names *If and nest If functions *Paymentand Lookup formula *Match & Index formula*Subtotals *Data validation *Database functions*Creating, Rearranging, Formatting a Pivot Table