0| Technology: | Excel |
| Level: | Intermediate |
| Audience(s): | Students and Professionals |
| Language(s): | English and Hindi |
| Training method: | Classroom / skype |
| Course Duration: | 15 Days |
| Class Duration: | 2 Hours |
| Fee: | INR 5000 |
This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
- What is the Excel?, Excel Application Setting - Calculation, Vba Tab options, Edit Custom list, Worksheet Calculation, Autocorrect Option, Macro Enable / Disable
- Shortcuts, keyboard shortcuts, navigation shortcuts, Paste Special - many more paste options
- Name Manager and Subtotal tools, Validation and Text to Columns
- Conditional formatting - New Formatting Rule dialog box, Data Shorting, Filter and Selection Concept
- Data Analyzing with Pivot - Chart , multiple conditions, Over 60 Most useful Excel formulas with examples
- Page setting, Excel Protection System - Sheet, Cells, window, Hide Formulas, Insert Other Application in Excel Sheet - Links and file, Hyperlink
- Basic Macro introduction, Vba Project, procedures and write some Vba code.
This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
