Course Outcomes:
Define and alternative and multiple data sets;
Vary your data to get a desired result by using Goal Seek;
Find optional solutions by using Solver;
Analyse data by using descriptive statistics;
Analyse data dynamically by using PivotTables;
Filter, show, and hide PivotTable data;
Edit and Format PivotTables;
Create PivotTables with external data;
Create Charts;
Customise the appearance of charts;
Find trends in your data;
Summarise your data by using sparklines;
Create dynamic charts by using PivotCharts;
Create diagrams by using SmartArt;
Create shapes and mathematical equations;
Enable and examine macros;
Create and modify macros;
Run macros when a button is clicked;
Run macros when a workbook is opened;
Include Office documents in workbooks;
Store workbooks as part of other Office documents;
Create hyperlinks;
Paste charts into other documents;
Share workbooks;
Manage comments;
Track and manage colleagues’ changes;
Protect workbooks and worksheets;
Authenticate workbooks;
Save workbooks for the Web.