Create advanced charts, add graphical elements, create trendlines and insert sparklines. Find out the many features to help share and protect your spreadsheet, such as: commenting, tracking changes, adding passwords and protecting portions of worksheets. Discover how to work with templates and settings, create PivotTables and PivotCharts, and use logical, statistical, financial and date functions. Using lookup functions and creating data tables will also be covered. Prerequisite: Excel II or equivalent.