Excel and Advance Excel - Learn MS Excel Course, Excel and Advance Excel Classes in Nagpur at Best Excel and Advance Excel Institute of Nagpur - MS Excel Course

Microsoft Excel is a spreadsheet package used for Calculations of all kinds . In MS 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. For Excel and Advanced Excel course fees and batch timings Contact Atlanta Computer Institute in Nagpur.

MS Excel Full Course is Conducted in English Hindi & Marathi as per students convenience in Offline ( In person ) and Online mode.

Excel & Advanced 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

Power Bi

Business / Data Analytics

VBA

Courses at Atlanta

New Batches start Every week On Mondays and Wednesdays.

New Batch Starting Date & Timing

Copyright © 2010-2023 All Right Reserved - Atlanta Computer Institute, Nagpur.