Microsoft Excel Expert (Level 3)

Many users are aware of the basics. After this class you will have a distinct competitive advantage as the Excel go-to-person performing sophisticated data analyses. Show others how to stop wasting time on repetitive tasks, be the protector of spreadsheet data from errors and unwanted manipulation, and quickly share your work with others by converting workbooks to different file formats. In this course, you will learn: (1) Working with tables: Calculated columns, structured references, table features, (2) Financial functions and what-If analysis: PMT, PV and NPER Functions, (3) PivotTables and Pivot Charts, (4) Work with Macros and (5) Workbook protection and inspecting workbooks for compatibility.