MS EXCEL

Formatting excel work book

<!--[if !supportLists]-->·      <!--[endif]-->New, Open, Close, Save, Save As

<!--[if !supportLists]-->·      <!--[endif]-->Formatting Text: Font Size, Font Style

<!--[if !supportLists]-->·      <!--[endif]-->Font Color, Use the Bold, Italic, and Underline

<!--[if !supportLists]-->·      <!--[endif]-->Wrap text, Merge and Centre

<!--[if !supportLists]-->·      <!--[endif]-->Currency, Accounting and other formats

<!--[if !supportLists]-->·      <!--[endif]-->Modifying Columns, Rows & Cells

Perform Calculations with Functions

<!--[if !supportLists]-->·      <!--[endif]-->Creating Simple Formulas

<!--[if !supportLists]-->·      <!--[endif]-->Setting up your own formula

<!--[if !supportLists]-->·      <!--[endif]-->Date and Time Functions, Financial Functions

<!--[if !supportLists]-->·      <!--[endif]-->Logical Functions, Lookup and Reference

<!--[if !supportLists]-->·      <!--[endif]-->Functions Mathematical Functions

<!--[if !supportLists]-->·      <!--[endif]-->Statistical Functions, Text Functions.

Sort and Filter Data with Excel

<!--[if !supportLists]-->·      <!--[endif]-->Sort and filtering data

<!--[if !supportLists]-->·      <!--[endif]-->Using number filter, Text filter

<!--[if !supportLists]-->·      <!--[endif]-->Custom filtering

<!--[if !supportLists]-->·      <!--[endif]-->Removing filters from columns

<!--[if !supportLists]-->·      <!--[endif]-->Conditional formatting

Create Effective Charts to Present Data Visually

<!--[if !supportLists]-->·       <!--[endif]-->Inserting Column, Pie chart etc.

<!--[if !supportLists]-->·       <!--[endif]-->Create an effective chart with Chart Tool

<!--[if !supportLists]-->·       <!--[endif]-->Design, Format, and Layout options

<!--[if !supportLists]-->·       <!--[endif]-->Adding chart title

<!--[if !supportLists]-->·       <!--[endif]-->Changing layouts

<!--[if !supportLists]-->·       <!--[endif]-->Chart styles

<!--[if !supportLists]-->·       <!--[endif]-->Editing chart data range

<!--[if !supportLists]-->·       <!--[endif]-->Editing data series

<!--[if !supportLists]-->·       <!--[endif]-->Changing chart

Analyze Data Using PivotTables and Pivot Charts

<!--[if !supportLists]-->·       <!--[endif]-->Understand PivotTables, Create a PivotTable

<!--[if !supportLists]-->·       <!--[endif]-->Framework Using the PivotTable and PivotChart

<!--[if !supportLists]-->·       <!--[endif]-->Create Pivot Chart from pivot Table.

<!--[if !supportLists]-->·       <!--[endif]-->Inserting slicer

<!--[if !supportLists]-->·       <!--[endif]-->Creating Calculated fields

Protecting and Sharing the work book

<!--[if !supportLists]-->·      <!--[endif]-->Protecting a workbook with a password

<!--[if !supportLists]-->·      <!--[endif]-->Allow user to edit ranges

<!--[if !supportLists]-->·      <!--[endif]-->Track changes

<!--[if !supportLists]-->·      <!--[endif]-->Working with Comments

<!--[if !supportLists]-->·      <!--[endif]-->Insert Excel Objects and Charts in Word Document and Power point Presentation.

Use Macros to Automate Tasks

<!--[if !supportLists]-->·      <!--[endif]-->Creating and Recording Macros

<!--[if !supportLists]-->·      <!--[endif]-->Assigning Macros to the work sheets

<!--[if !supportLists]-->·      <!--[endif]-->Saving Macro enabled workbook

Proofing and Printing

<!--[if !supportLists]-->·       <!--[endif]-->Page setup, Setting print area, Print titles

<!--[if !supportLists]-->·       <!--[endif]-->Inserting custom Header and Footer

<!--[if !supportLists]-->·       <!--[endif]-->Inserting objects in the header and footer

<!--[if !supportLists]-->·      <!--[endif]-->Page Setup, Setting margins, Print Preview, Print

<!--[if !supportLists]-->·      <!--[endif]-->Enable back ground error checking