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

Courses at Atlanta

New Batches start Every week On Mondays and Wednesdays.

New Batch Starting Date & Timing

Copyright © 2010-2017 All Right Reserved - Atlanta Computer Institute, Nagpur. Site Map