NCMOSMI025 — Excel III Bs8
This course will introduce you to analytical features used in Excel topics including advanced formulas and list management; pivot tables; exporting & importing data; analytical options; and macros. Additional features covered are: *Using names *If and nest If functions *Payment and Lookup formula *Match & Index formula *Subtotals *Data validation *Database functions *Creating, Rearranging, Formatting a Pivot Table *Creating a Pivot Chart *Goal Seek, Solver, Scenarios and Views.