MIS TRAINING IN INDIA

Working with Pivot Tables Changing the Data Displayed Applying a Style to Your Pivot Table Some Real-life Examples Creating Pivot Charts Creating a Chart from a Pivot Table Creating a Pivot Chart from Data Using What-If Analysis Using Goal Seek Using the Scenario Manager Using a One Input Data Table Using a Two Input Data Table Grouping and Outlining Data Grouping Data Adding Subtotals Outlining Data Grouped and Outlined Data Macros Creating, Recording, executing Hyperlink with MS Word & PDF File How to protect cells in excel file Solving Errors Using Named Ranges Understanding Formula Errors Dependents and Precedents Using the Trace Errors Commands Evaluating Formulas Hyperlink, Transpose & Hlookup Track Changes Managing Your Data Transposing Data Using the Text to Columns Feature Checking for Duplicates Creating Data Validation Rules Consolidating Data