IT Skills-2

Unit 1

Pivot Table: Developing Pivot Table, Analyzing data using goal seek and solver, Scenarios Create named scenarios. Show, edit, delete scenarios, Creating a scenario summary report. Validating and Auditing: Set, edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time, Trace precedent, dependent cells. Identify cells with missing dependents. Creating applications in Spreadsheet and Macros.

Unit 2

Creating and formatting Charts: Understanding chart types, column chart, bar chart, line chart, pie chart, XY Scatter chart , Area chart, surface chart, bubble chart. Create a combined chart like: column and line, column and area. Change the chart type for a defined data series, Add, delete a data series in a chart, Re-position chart title, legend, data labels. Change scale of value axis: minimum, maximum number to display, major interval. Change display units on value axis without changing data source:

hundreds, thousands, millions. Format columns, bars, pie slices, plot area, chart area to display an image.

References Excel Data Analysis: Modeling and Simulation , Hector Guerrero (Springer )