Mis Training
Price On RequestBasic Advanced Excel Worksheet Operations, Cell Operation, Format Cells, Freeze Panes, Techniques of Paste Special, Protect Worksheets Workbooks , Format Painter, Data Sorting using custom list, Summarizing data using Auto Outline, Concept of Cell Referencing, Relative Referencing, Absolute Referencing, Mixed Referencing, Function :-Logical, Text, Date Time, Lookup Reference, Math , Statistical , Information Formulas: How to make formula with use of Function. Array Formulas, Database Formulas. Name Manager, Conditional Formatting Excel Shortcut Method and Excel Setting, Format Tricks, Advanced Custom Format, Data Validation :--Different Data validation in Excel ,Using list in validation Charts in Excel :--Elements of Charts ,Major charts used in Excel Pivot Table :--Pivot Table creating Methods ,Rearranging a Pivot Table ,Filtering Pivot Table Data ,Performing Custom Calculation ,Consolidating Data from external source or multiple files in less than a minute Data Filter :--Normal Data Filter ,Advance Filter ,Calculation based filter ,Filter using wild cards , Subtotal Information From Excel Options:-Popular, Formulas, Profing, Save, Advanced, Customize List Box, Combo Box, Button, Spin Button, Option Button, Group Box, Text Box, Label, Check Box. Much More Home Work. Excel Class Fee:-3500 Ruppes, Excel VBA Class Fee:-4000 Rupees, Fees will be taken Only after 3 Class, If you will be interested to continue. Class video will be given, Whatever will be taught that will be recorded just like a film video.