Welcome To Microsoft Excel In Ideal Tutorials
Unit-1 All Topic Notes Of Pc Software In Excel File
MS-Excel | Features of MS-Excel | Three Major Parts of Excel are | Different Parts of MS Excel Window | Chart | Various Types of Charts | Steps to create different types of Charts in MS Excel | Goal Seek
Unit-2 All Topic Notes Of Pc Software In Excel File
Formula | Basic Properties of Formulas | Formula consists of cell-references and operator | Function | Macro | Creating or Recording a Macro | To Run a Macro | Pivot Tables | Uses of Pivot Tables | Steps to Creating a Pivot Table | Pivot Charts
Unit-3 All Topic Notes Of Pc Software In Excel File
Conditional Formatting | One can control the following formats | Steps to use Conditional Formatting: (using example) | Steps to Increase / Decrease the width of a column in MS Excel | Functions are performed in MS Excel
Unit-4 All Topic Notes Of Pc Software In Excel File
Spreadsheet | Features of Spreadsheets | Sorting a Database in MS Excel | Sorting can be done in two ways | Filtering on Database | Basic AutoFilter | Using AutoFilter | Advanced Filter | Data Validation
Unit-5 All Topic Notes Of Pc Software In Excel File
Data Validation enables users to | Data Validation is helpful in the following ways | Steps for Data Validation Coming Soon
Unit-6 All Topic Notes Of Pc Software In Excel File
Different Format supported by MS Excel | Align Text | Format Fonts | Create Borders around Data | Use Patterns | Inserting | Deleting Coming Soon
Important Questions With Answer
Interview Questions
Important notice
Comming Soon..
Post a Comment
No comments