In this Package, trainees will learn basic features of Microsoft Excel 2010. Trainees will have a systematic guidance through the development of spreadsheets and will learn how to use & create formulas, functions & charts that can help them to calculate & analyze their numeric data, in general, the Package stresses on providing basic understanding of spreadsheet building, and also will learn advanced features of Microsoft Excel 2007. Trainees will have a systematic guidance through the development of spreadsheets and will learn how to use & create Templates, use conditional formatting, functions & pivot charts that can help them to calculate & analyze their numeric data. Trainees will also be able to use MACROS and apply security on spreadsheets in general.

• Opening & Saving Excel files
• Edit & format data & sheets
• Create & Format Tables
• Use Formulas & Functions
• Create & Modify Charts in Excel.
• Adjust Printing settings from Excel.
• Customize Excel sheet Interface according to his needs.
• Insert Objects, Photos, and Forms in workbooks.
• Exchange spreadsheets through E-mail.
• Import and Export Data between Excel & other office applications.
• Summarize data using Group  and Outline feature.
• Summarize Data using PivotTable and PivotChart.
• Perform various data analysis techniques using Scenario, Data Table, Goal Seek & Solver.
• Use Lookup & Reference functions effectively to search data.
• Apply conditional functions on numerical values.
• Evaluate different types of formulas errors.
• Apply security and protection concepts on spreadsheets.
• Protect workbooks using Digital Signature.
• Share workbooks with workgroups.
• Record macros modules & assign security level to them.
• Explain the basic concepts of Visual Basic Editor.

Topics :