Today in every IT Industry, MS Excel plays a very crucial part. Either you are a Manager, Team Lead or working in Reporting Team. You must have good working knowledge of MS Excel. In our class we will not only teach you the theory of Excel but also give its practical example and each student will get a chance to work over on the spot scenario. At the end of the course you will be provided with the coaching notes too.

Topics Covered

Topics Covered *Creating a List *Using a Data Form *Adding Records Using a Data Form *Finding Records Using a Data Form *Deleting Records Using a Data Form *Sorting Records in a List *Using AutoFilter in a List WORKING WITH CHARTS *Creating a Chart with the Chart Wizard *Moving a Chart *Resizing a Chart *Changing a Chart Type *Editing Chart Text *Modifying Chart Options *Formatting Category & Value Axis Data *Formatting a Data Series *Changing a Chart’s Source Data WORKING WITH GRAPHICS *Using the Drawing Toolbar *Formatting Objects *Inserting WordArt *Inserting an Organization Chart *Modifying an Organization Chart WORKGROUP COLLABORATION *Web Page Preview *Converting Worksheets into Web Pages *Inserting Hyperlinks *Viewing & Editing Comments IMPORTING & EXPORTING DATA *Importing External Data into Excel *Importing Text Data into Excel *Importing Data from a Database *Exporting Data from Excel *Publishing Worksheets & Workbooks to the Web FORMATTING NUMBERS *Creating Custom Number Format *Using Conditional Formatting *Removing Conditional Formatting WORKING WITH RANGES *Naming a range *Using a Named Range *Deleting a Named Range *Using the VLOOKUP Function CUSTOMIZING EXCEL *Creating a Macro *Running a Macro *Editing a Macro *Adding a menu to the Menu Bar *Adding a Commands to a Menu *Adding Buttons to a Toolbar DATA ANALTSIS TOOLS *Tracing Formula Precedents *Tracing Cell Dependents *Tracing & Fixing Errors *Creating a Pivot Table *Rearranging a Pivot Table *Filtering Pivot Table Data *Creating a Pivot Chart SUMMARIZING DATA *Adding Subtotals to a List *Nesting Subtotals *Applying Advance Filters *Adding Group & Outline Criteria to Ranges *Using Data Validation WHAT–IF DATA ANALYSIS *Using Goal Seek *Using Solver *Creating & Displaying Scenarios WORKGROUP COLLABORATIONS *Locking/Unlocking Cells in a worksheet *Protecting a Worksheet *Protecting a Workbook *Creating a Shared Workbook *Tracking Changes to a Workbook *Accepting & Rejecting Changes to a Workbook *Password Protecting a Workbook *Merging Workbooks

Who should attend

Managers, Team Leads, Students and all interested candidates can attend

Pre-requisites

Basic knowledge of computers

What you need to bring

NA

Key Takeaways

*Working with Excel in a professional environment. *Excel shortcuts *Steps to reduce your time of routine work. Coaching Notes