BECOME AN EXCEL GURU!
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.
What Will I Learn?
(1) Working with Tables – Calculated Columns, Structured References, Table Features
(2) Financial Functions & What-If Analysis – PMT, PV and NPER Functions
(3) PivotTables and Pivot Charts
(4) Workbook Protection and Inspecting Workbooks for Compatibility.
Prerequisite: Proficiency using any level of Microsoft Excel is required.