Advanced Excel - Office 2010

This Advanced Excel - Office 2010 contains 12 Units and each unit contains 160 slides in it.

To "View/Download" the sample of this presentation, go to the following link: http://www.slideshare.net/nsprash/advanced-excel-unit-01

Contents…

• Manage cell and range names

• Calculate data across worksheets

• Use specialized functions

• Analyze data with logical and lookup functions

• Create and modify tables and Format tables

• Sort or filter worksheet or table data

• Calculate data in a table or worksheet

• Create, Modify and Format chart

• Create a PivotTable report

• Analyze data using PivotCharts

• Insert and modify pictures and ClipArt

• Draw and modify shapes

• Illustrate workflow using SmartArt graphics

• Layer and group graphic objects

• Customize the Excel environment

• Customize workbooks

• Manage themes and Create and use templates

• Apply conditional formatting

• Add data validation criteria

• Update a workbook’s properties

• Modify Excel’s default settings

• Share a workbook

• Set revision tracking and Review tracked revisions

• Merge workbooks

• Administer digital signatures

• Restrict document access

• Trace precedents and dependents of a cell

• Troubleshoot errors in formulas and invalid data and formulas

• Watch and evaluate formulas

• Create a data list outline, a trend line and scenarios

• Perform what-if analysis and statistical analysis

• Create a workspace and Consolidate data

• Link cells in different workbooks

• Edit links and Export Excel data

• Import a delimited text file

• Publish a worksheet to the web

• Import data from the web

• Create a web query

• Develop XML maps and Import and export XML data