Excel and Advance Excel - Learn Excel and Advance Excel Classes in Nagpur at Best Excel and Advance Excel Institute of Nagpur
Microsoft Excel is a spreadsheet package used for Calculations of all kinds . In Excel all kinds of Financial Calculations, Business Calculations, Sales figures, Stocks tally, Employee salary etc are done. Most of the small offices, Business Executives, Accountants etc use excel for their day to day calculations.For Batches of Excel and Advance Excel contact Atlanta Computer Institute Nagpur. Excel Training Education is necessary for persons or professional dealing with calculations, reports etc.
Excel & Advance Excel
-Creating Worksheets in Excel
- Printing, Inserting, Deleting, Copying, Moving worksheets in Excel
- Formulas, Built-in functions in Excel
- Graph-Plotting facilities in MS Excel
- Database Management System.
- Using externally created data files.
- What-if analysis in MS Excel
- Formatting cells, Worksheets etc. in Excel
- Custom Controls
- Protection facility
- Pivot tables in Excel
Customizing common options in Excel
Absolute and relative cells
Protecting and un-protecting worksheets and cells
Working with Functions
Writing conditional expressions (using IF)
Using logical functions (AND, OR, NOT)
Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
Data Validations
• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell
Working with Templates
Designing the structure of a template
Using templates for standardization of worksheets
Sorting and Filtering Data
Sorting tables
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
- Macro facility in MS Excel
-Creating Worksheets in Excel
- Printing, Inserting, Deleting, Copying, Moving worksheets in Excel
- Formulas, Built-in functions in Excel
- Graph-Plotting facilities in MS Excel
- Database Management System.
- Using externally created data files.
- What-if analysis in MS Excel
- Formatting cells, Worksheets etc. in Excel
- Custom Controls
- Protection facility
- Pivot tables in Excel
Customizing common options in Excel
Absolute and relative cells
Protecting and un-protecting worksheets and cells
Working with Functions
Writing conditional expressions (using IF)
Using logical functions (AND, OR, NOT)
Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
Data Validations
• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell
Working with Templates
Designing the structure of a template
Using templates for standardization of worksheets
Sorting and Filtering Data
Sorting tables
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
- Macro facility in MS Excel
After this course you can do following course